| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding ref #
I have a sheet that has a number of rows and that veries daily. Take todays,
the colum I'm checking is C. So there is data in C2 - C5, C7, C9-11. Now in colum D I put 1,2,3... but not in the empty cells. So D5 would be 4 then D7 would be 5 and so on. So for today there would be 8. I was wanting to use a formula in the D colum so if one of the rows was removed that the numbers would adjust and I wouldn't have to renumber be low the row that was deleted. Is there a formula I can put in there that would lood at the C colum and if there was data put 1 then 2,3 and so on but skip rows that had empty cells. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding ref #
In D2 enter 1, then use this formula in D3
=if(C3="","",1+MAX(d$2:d2)) "John K" wrote: I have a sheet that has a number of rows and that veries daily. Take todays, the colum I'm checking is C. So there is data in C2 - C5, C7, C9-11. Now in colum D I put 1,2,3... but not in the empty cells. So D5 would be 4 then D7 would be 5 and so on. So for today there would be 8. I was wanting to use a formula in the D colum so if one of the rows was removed that the numbers would adjust and I wouldn't have to renumber be low the row that was deleted. Is there a formula I can put in there that would lood at the C colum and if there was data put 1 then 2,3 and so on but skip rows that had empty cells. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding ref #
Thanks, that's exactly what I was looking for.
"Duke Carey" wrote: In D2 enter 1, then use this formula in D3 =if(C3="","",1+MAX(d$2:d2)) "John K" wrote: I have a sheet that has a number of rows and that veries daily. Take todays, the colum I'm checking is C. So there is data in C2 - C5, C7, C9-11. Now in colum D I put 1,2,3... but not in the empty cells. So D5 would be 4 then D7 would be 5 and so on. So for today there would be 8. I was wanting to use a formula in the D colum so if one of the rows was removed that the numbers would adjust and I wouldn't have to renumber be low the row that was deleted. Is there a formula I can put in there that would lood at the C colum and if there was data put 1 then 2,3 and so on but skip rows that had empty cells. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with adding 10% | Excel Worksheet Functions | |||
| adding | Excel Discussion (Misc queries) | |||
| Adding Up! | Excel Discussion (Misc queries) | |||
| Adding * | Excel Discussion (Misc queries) | |||
| Adding with & | Excel Worksheet Functions | |||
Linear Mode
