Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Have several columns, cell values will contain a letter - A, B, C or D Trying to create a summary of results, what is the percentage for each value i.e - total count values in the column - got that as counta(a1:a390) but now want to summarize the cell values A = 57% B = 13% C= 10% D= 10% Tried the Tool Analysis pak, but not familiar with it, tried a couple of the analysis types - guess range can only contain numbers. But still reading the help on that tool, to see if any of those will work....do any of those functions work with letters for the cell values. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |