Forum Discussion
Repeated Measures (CountIF and VLookup)
Hi all, The data I'm dealing with in Excel has IDs with multiple entries (visit counts), as seen below. Each entry for an ID has been sorted by date (oldest first – not shown) and has been assign...
tdwagner As a variant and in case your Excel version supports the FILTER function:
=IFERROR(VLOOKUP(B2:B26,FILTER(B2:D26,D2:D26=1),3,0),0)