=IFERROR(INDEX(... SMALL(IF....,ROW...,COLUMN)))

[Phil1969]

Hi,

Could you please let me know where I could find information on how this formula works:

=IFERROR(INDEX(... SMALL(IF....,ROW...,COLUMN)))

By chance, I made it work in one worksheet where the input data was listed in several rows and the output came in several columns.
But now I need to transform this formular with the input data listed in several rows AND the output also in rows.

Thank you for your advice.

Kind regards.

 

[shili12]

upload an xlsx file for better perception.

 

[Phil1969]

Hello,

Attached the file. The formula is in tab "Find client":

- I do not know how to make the columns change dynamically
- it seems, that with the SMALL function, the dates are not sorted from oldest to latest

Thank you for your advice,
Phil

 

[Phil1969]

Hi,

I used the filter function instead and this worked fine.

Thank you anyway.

Br,
Phil

 

[S P P]

Phil1969

See if it can be like this

 

[Phil1969]

Thank you S P P, that was very insightfull.