Forum Discussion
Solved
Static Column Data Filter
Hi Everyone, I got one issue related to filter the data. I have a data set with few ID's with position list as below. I want this data to be represented as per below snap. Let me kn...
Sridhar0311 the easiest is using FILTER() (which assumer you have the latest Excel)
I also took the liberty to format your data as a table but the formula could be done using row-column references instead:
=FILTER(Table2[ID],Table2[Position]=A$2,"")
Sridhar0311 the easiest is using FILTER() (which assumer you have the latest Excel)
I also took the liberty to format your data as a table but the formula could be done using row-column references instead:
=FILTER(Table2[ID],Table2[Position]=A$2,"")
Thank You