| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif left and alphanumberical data
I'm wanted to build a formula that will do the following,
CountIF(Column begins with array) I can't see to get the function to work. Reallife example Count a column of postcodes to find any postcodes beginning with EH, LG, etc... and giving me a total |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving data left | Excel Discussion (Misc queries) | |||
| Using LEFT() in COUNTIF | Excel Discussion (Misc queries) | |||
| COUNTIF(LEFT('SpreadSheet1!A1:A25, 1), "A") | Excel Worksheet Functions | |||
| data entry right to left | Excel Discussion (Misc queries) | |||
| Sort data from Left to Right | Excel Discussion (Misc queries) | |||
Threaded Mode
