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 :)