Capture and list data from a column or row

[Guest]

I would like to query a column and get a list of all data in that column and
the number of times that entry occurs.

Example:
Column C has 100 Rows, each of these rows could have unique data, but the
reality of it is that there will be 4 or 5 entryies that repeate and perhaps
one or two with only one entry.

The ultimate goal is to list all entries in the column and how many rows
have that data, probably use a countif function for that. The problem is how
do I define the variables to do the countif on and set them in a variable
array since I don't know how many possible entries I will have.

I am fairly sure excel supports this just don't know were to look.

 

[Biff]

Hi!

The easiest way would be to use an advanced filter and copy the uniques to
another location then you could use the Countif.

Biff

 

[Guest]

That would be true if I was trying for a one off.

I have a multipage sheet that is populated via a macro query of a DB.

I then need to query this data and pull out the relevent info.

I would like to be able to name a range and then create a list of the
individual entries and how many times they occur. the manual solution does
not really scale to the volume of data and number of times a day/week I would
need to do this.

Thanks for the suggestion though.

Jeff