6mP64du.png
Basically I want to populate a cell with yes or a checkmark IF the ID Numbers match (for example A2 and A3 match) and column B has at least two rows with the presence of both “Pre-Measure” and “Post-Measure” . So that would populate with a “yes” under H2 and H3 for A2 and A3 as well as A4 and A5, but not for A6 because it only has a “Pre-Measure” row.
Sorry if that wasn’t worded very well, I’m having a hard time describing what I want much less finding any relevant formulas.
Bookmarks