Hi,
I have a table where I have two columns that I wanna return a list of values from.
First column is called Code (L81:202) and the second Columns is called Shortlisted (N81:202)
What I want to return is a list of Codes if the Shortlisted column value is "Yes". Any idea why my formula doesnt work?
=HVIS.FEJL(INDEKS(Tabel1[Code];MINDSTE(HVIS(Tabel1[Shortlisted]="Yes";RÆKKE(Tabel1[Code])-RÆKKE($A$4);"");RÆKKER($1:1)));"")
Best regards,
Bahar
Bookmarks