| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching alfanumaric cell contents and returning with a numaric v
Is there a way to use a formula to determine how many times an alphanumeric
value is used in a column of cells. For example a column consisting of 300 cells that have one of the folloing notations in each cell "A1, A2, B1, B2, B3, C1, C2 or C3". Can a formula be used to determine how many times A2 appears in the column if so what formula would I use? Can a formula be used to determine how many times A1 or B3 or C2 appears in the column if so what formula would I use? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding the cell with min value and returning the contents of neig | Excel Worksheet Functions | |||
| Returning contents of a cell in another sheet in same workbook | Excel Discussion (Misc queries) | |||
| Searching in another workbook for a string and returning with the contents of the cell next to it. | Excel Worksheet Functions | |||
| Returning contents of a cell | Excel Worksheet Functions | |||
| LOOKUP returning value in cell above what I was searching for | Excel Discussion (Misc queries) | |||
Threaded Mode
