Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count of Different Columns
I have exported an Access crosstab query into Excel. Each row has a unique
identifier and I have 50 columns with different counts for each row. I need to know which rows have counts in more than one column and how many columns have a count in per row. i.e. For Row 1 I would want to report a value of 1 as there is a value in only one column, Row 2 I would want to report a value of 2 and Row 3 I would want to report a value of 3. With 50 columns I need an easy way!!! Column A Column B Column C Row 1 6 0 0 Row 2 1 0 3 Row 3 4 1 1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count for 3 columns | Excel Worksheet Functions | |||
Count in two columns | Excel Worksheet Functions | |||
I would like to Count values in two columns. | Excel Worksheet Functions | |||
count conditionally across two columns? | Excel Worksheet Functions | |||
Count certain changes between columns | Excel Worksheet Functions |