Using Formulas to Match Variables Across Grouped Data in Excel
Hi If I have a data set grouped in a cell under the heading "Markers," then each section labeled 0, 1, 2, etc. contains the same set of variables, with different values within. Is it possible to use a formula to match a specific variable in each section (0, 1, 2) and, if the variable value matches, return all variables and their values from that section?
Loading attachments
