Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula - Analyse range, return unique value
Hi there,
I used to have a formula for this, but a computer swap has left me without any of my saved excel formulas. If someone can help me out, I would appreciate it. I need a formula where it can essentially look at a range, dynamically, and then return the unique values within that range. This formula will be present beside a query being refreshed from our server, so it cannot be a 'drag down' type formula and must coincide to its row number. But perhaps Im asking for too much - I'll take what I can get. Essentially, return the value only if the data is being returned the first time: Data - - - Returned 101 - - - 101 102 - - - 102 101 - - - 103 - - - 103 104 - - - 104 102 - - - 101 105 - - - 105 Any help is greatly appreciated!!! I'm starting my furious searching (this has already gone off to a VP with an error... woops) and will report back with any findings - in the meantime, any knowledge that can be shared would be great :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Formula based Cell Content Return Unique Consecutive Duplicate Values | Excel Worksheet Functions | |||
formula to look up and return smallest date from a range of dates | Excel Worksheet Functions | |||
Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
Return a unique value | Excel Worksheet Functions | |||
Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions |