| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell "if"
I'm using this formula to count my records =IF(LEN(B1),COUNTA(B$1:B1),"")
Is there a way to add letters to the count. I want it to count like this in the spreadsheet. ALE1 ALE2 ALE3 ALE4 ALE5... "daddylonglegs" wrote: Try this formula in A1 copied down =IF(B1,COUNT(B$1:B1),"") if column B just contains numbers, if possibly text =IF(LEN(B1),COUNTA(B$1:B1),"") -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=513069 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
