What did you want to know... Are you looking for a listing of the unique
entries or ???
--
HTH...

Jim Thomlinson


"mwam423" wrote:

greetings! if i have a range say 40 columns by 10 rows with values in half
of the cells, is there a formula, or macro, or best method, where i can
determine what values are in the range. note, there are many values which
will show up multiple times in the range. i was hoping to use a pivot table
but i'm not sure how to use one over a 40 by 10 range.