Hi all,

I seem to be doing a lot a filtering on a spreadsheet and was wondering if there is a quick way maybe using a formula to create a dynamic list of names when a cell is selected. My only criteria is that it should show people who have scored less than 55% I have attached a spreadsheet which will probably make a lot more sense.



Many thanks to everyone taking the time to read this message

Attached Files

practice.xlsx (14.2 KB, 18 views)

See attached file, salimnore. This uses formulas in a way that you envisaged. It has blank rows but you can 'Ctrl+t' to make it a table and then filter out the blank rows.

I'm not sure however that this is any quicker than just converting your data to a table and then filtering.

You could use a macro to get exactly what you want.

Attached Files

practice_mktshare.xlsx (19.9 KB, 10 views)

Dear Friend,


Kindly find attachment, I Hope it would fulfill your requirement

Attached Files

practice.xlsm (32.2 KB, 12 views)

Or another formula solution (array formulas).

Attached Files

practice_2.xlsx (23.6 KB, 12 views)