because cells A4 to E172 represent my database, the value in B1 (first name) is the category or field I want Excel to search for, and cells A1 and A2 (the category name "ID" and the ID in cell A2 ...

Learn how to master dense ranking in Excel to fix ranking gaps and improve data analysis with this step-by-step guide. Fix ...