Relative Content

Tag Archive for excelexcel-formulavlookupindex-match

How to find all cells related to specific values using only formulas in excel?

I have to find all values related to specific data from one table. Case is that data by which I have to search can appears more than once, but values will be always unique, do not appear more than once. The issue is more complicated, but there is no need to explain, I just can’t deal with that part, cause I can’t use a macro and can’t use the filters. I has to be done that I write data in specific cell and under that cell, thanks to excel formula, I can see all related values line by line. Could you help me?