On Feb 20, 12:55 pm, Toppers
wrote:
See

http://www.cpearson.com/excel/duplic...tractingUnique

HTH



"S Davis" wrote:
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 :)- Hide quoted text -

- Show quoted text -

This worked perfectly, thank you !