Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Capture and list data from a column or row
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. -- Jeff |
#2
|
|||
|
|||
Capture and list data from a column or row
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 "Jeff" wrote in message ... 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. -- Jeff |
#3
|
|||
|
|||
Capture and list data from a column or row
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 -- Jeff "Biff" wrote: 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 "Jeff" wrote in message ... 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. -- Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot tables & queries | Excel Worksheet Functions | |||
Capture chart elements in VB | Charts and Charting in Excel | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |