Populate dynamic client list based on fix arrangement

[lymanting]

HI, I have a group of clients that come in at different day of the week as indicated in the "fixed arrangement" tab.

based on that, I need to list of clients I would have for a particular day I search for as shown in "search result" tab.

Please advise

[MarvinP]

Hi laymanting,

If you keep your data in a little different format, it would be easy to get your answer. See the attached where I've done that.

2 dimensions filter Better data structure.xlsx

[lymanting]

Hi, thanks for the help but I actually simplified the table quite significantly. that's actually alot more columns so transposing the table is really not an ideal option. please find the revised attached for reference

[kvsrinivasamurthy]

In B4 then copy down

Please Login or Register  to view this content.