#1
|
|||
|
|||
Dynamic table list
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Dear Friend,
Kindly find attachment, I Hope it would fulfill your requirement |
#4
|
|||
|
|||
Or another formula solution (array formulas).
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dropdown list from a value of another cell in dynamic worksheet | Javir | Excel | 5 | 06-07-2018 02:52 AM |
dynamic dependent drop down list based on input with reference to a two column table | jwan142 | Excel | 4 | 05-23-2018 08:15 AM |
sort dynamic table name with vba | trevorc | Excel Programming | 1 | 01-21-2017 12:58 AM |
Dynamic table numbers | srinidhi.mv88 | Word VBA | 5 | 06-22-2015 06:35 AM |
Mail Merge Into Dynamic Table | Jag618 | Mail Merge | 1 | 03-04-2013 11:26 PM |