| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I write a formula in Exel that will keep a running count?
I have created a mail log at work on Exel, but the trouble I'm is each I make
a new entry I to continue to add a item number in colume A (1, 2, 3.....). If anyone can answer this question I would greatly appreciative. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I write a formula in Exel that will keep a running count?
If you are entering your data in column B, for example, then in A1 you could
use =IF(B1="","",ROW()) and copy down the column. -- David Biddulph "48160" wrote in message ... I have created a mail log at work on Exel, but the trouble I'm is each I make a new entry I to continue to add a item number in colume A (1, 2, 3.....). If anyone can answer this question I would greatly appreciative. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I write a formula in Exel that will keep a running count?
hi
in a2 enter.. =A1+1 then copy down. to hide the formula(if you want) until entries are made in column b.... =if(b2="","",A1+1) Regards FSt1 "48160" wrote: I have created a mail log at work on Exel, but the trouble I'm is each I make a new entry I to continue to add a item number in colume A (1, 2, 3.....). If anyone can answer this question I would greatly appreciative. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I write a formula in Exel that will keep a running count?
One way...
Assuming A1 and B1 are column headers and B2 is your first entry. Enter this formula in A2 and copy down as needed to allow for future entries: =IF(B2="","",N(OFFSET(A2,-1,,))+1) -- Biff Microsoft Excel MVP "48160" wrote in message ... I have created a mail log at work on Exel, but the trouble I'm is each I make a new entry I to continue to add a item number in colume A (1, 2, 3.....). If anyone can answer this question I would greatly appreciative. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| better way to write a count if statement? | Excel Worksheet Functions | |||
| How to write a count-if-not function? | Excel Worksheet Functions | |||
| Running Count | Excel Worksheet Functions | |||
| How do I write a conditional statement in Excel to count if two c. | Excel Worksheet Functions | |||
| MY EXEL/WORD OFFICE 2000 IS RUNNING VERY SLOW AFTER DOWNLOADING U. | Excel Discussion (Misc queries) | |||
Linear Mode
