Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Number Formula
Hi,
Try: =COUNTIF(A:A,"invoice") HTH Jean-Guy "FJ" wrote: Hi, I need to create an automatic numbering formula in Excel that will work as follows: For every row that has the word "Invoice" in cell A1, I want cell C1 to number automatically. There are also blank rows in the spreadsheet, and there will be rows added and deleted from time to time. Is there any way to write a formula to automatically number something like this, updating the numbering when rows are added and deleted? I've tried various "IF" and "COUNT" formulas, but to no avail. I hope I've explained this clearly. Thanks in advance for any information. :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
If formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
formula that gives me a random number less than other number | Excel Worksheet Functions | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions |