| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the unique values from a range?
I'm trying to build a results sheet for some work that we do.
1 column has the month in which the work was done. ie. 01/01/04 01/01/04 01/02/04 01/02/04 01/04/04 01/09/04 01/09/04 01/09/04 etc... In the example above, as you can see, some months have multiple jobs done, others only 1. Also there are some months when no work was done at all. The dates are always the 1st of the month, so no problems in looking at specific dates, just the month values. So if I wished to show the last 4 month's when work was done, what function would I need to use to get Excel to produce a list like this... 01/01/04 01/02/04 01/04/04 01/09/04 TIA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting unique values and matching to quantities | Excel Worksheet Functions | |||
| Match formula that pulls unique values from another column? | Excel Discussion (Misc queries) | |||
| Unique Values | Excel Worksheet Functions | |||
| Count Unique Values | Excel Worksheet Functions | |||
| MIN with zero values in the range | Excel Discussion (Misc queries) | |||
Threaded Mode
