Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to combine 30 columns into 1 or 2
Ive maxed out 256 columns in my database
I need to combine 30 columns into 1 or 2. Is there a way to do this? I need to be able to count how many 1,2,3,4,5,6 up to 30 from my database. I have lots of rows that these numbers are in. Example: Barclay 2 Barclay 2 Cass 4 Cass 4 Cass 4 Howard 8 Howard 8 So, I need to know for Barclay that there are 2 twos, Cass 3 fours and so on? Can I do something like this and how? Any help would be greatly appreciated! |
#2
|
|||
|
|||
I need to combine 30 columns into 1 or 2
Hi,
The easiest way would be do a Pivot Table which will count how many times each individual entry appears. I presume all of them are arranged in a column. Try doing a pivot on this column and set the data as count of the column which contains the info you need to count. Hope this helps "Linda" wrote: Ive maxed out 256 columns in my database I need to combine 30 columns into 1 or 2. Is there a way to do this? I need to be able to count how many 1,2,3,4,5,6 up to 30 from my database. I have lots of rows that these numbers are in. Example: Barclay 2 Barclay 2 Cass 4 Cass 4 Cass 4 Howard 8 Howard 8 So, I need to know for Barclay that there are 2 twos, Cass 3 fours and so on? Can I do something like this and how? Any help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
How do you combine two columns to one? | Excel Discussion (Misc queries) | |||
combine columns | Excel Worksheet Functions | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |