Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I have a table which has the letters A-F appearing a number of times in the fields e.g. A A A A B C D E F C D A B E F A A B ..... I want to add the number of times the letter A or B etc. appears and display the answer in another blank field outside the table above. What I would like to do is have a second table that shows the answers like so: A 7 B 4 C 3 D 2 E 4 F 6 How do you get the fields to add up the contents of letters? Help much appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Look up/math text | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Adding + in front of a number | Excel Discussion (Misc queries) |