tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Hi have a sheet called PDD that has lots of details in it,
I'm creating a dashboard that lets me filter out some data and need to make list of the unique names froma filtered list.
So i'll run a macro to say select the dates and the product type,
and I have a filtered sheet of all this data
now what I need is a list of unique Names rom the data left in Column D (I want to do this to lots of columns but effectively if we do column D I can repeat in as in wish)
If I was righting the formula in English it would go like this:
In Sheets "Cals1" Starting at D2 make a list of all the unique names in sheet PDD range D10:D500 visible cells only.
(a macro might also be ok but it would need to run very quickly as i'll have about 100 of these to do, so a formula will be easier to reproduce.)
any ideas if this can be done and how best to do it?
thanks
Tony
Hi have a sheet called PDD that has lots of details in it,
I'm creating a dashboard that lets me filter out some data and need to make list of the unique names froma filtered list.
So i'll run a macro to say select the dates and the product type,
and I have a filtered sheet of all this data
now what I need is a list of unique Names rom the data left in Column D (I want to do this to lots of columns but effectively if we do column D I can repeat in as in wish)
If I was righting the formula in English it would go like this:
In Sheets "Cals1" Starting at D2 make a list of all the unique names in sheet PDD range D10:D500 visible cells only.
(a macro might also be ok but it would need to run very quickly as i'll have about 100 of these to do, so a formula will be easier to reproduce.)
any ideas if this can be done and how best to do it?
thanks
Tony