Today is my mistake day sory again put this formula in the cell D8 and copy
drag down to where ever you need again the first part of range should have $
and the second part shouldn't:

=IF(F8=0,"",MAX($D$7:D7)+1)

Thanks,

--
Farhad Hodjat


" wrote:

On Aug 1, 10:26 am, Farhad wrote:
Sorry Sorry Sorry lots of confusing here is the best formula is:

=IF(F8=0,"",MAX($D$2:D2)+1)

make sure to put $

Thanks,

--
Farhad Hodjat



"Farhad" wrote:
Hi again,

sorry i made mistake the formula should be:

=IF(ISBLANK(F8),D7,IF(F8=0,D7+1,D7))

--
Farhad Hodjat

" wrote:

This is probably a simple question... but, I'm trying to get a
spreadsheet to fill in a number if there's something in the field...
the column that will populate the number is column D... for example,
the data can be entered column F, rows 7-49...

Right now, I have it set that if there is something in cell F7, put a
1, if not, leave blank. The next field, however, depends on the one
before... so, my formula is...

=IF(F7=0,"",1)

then...

=IF(F8=0,"",D7+1)

This formula continues down the column but because it's dependant on
the row before, if someone skips a row, they get #VALUE... is there a
way to make it count even if they skip? So, if they put something in
F7 but leave F8 blank and then fill in F9, D9 will show as number 2
since F8 had no data?

That's confusing... sorry! Hope you can understand what I'm
asking :) Thanks!!- Hide quoted text -

- Show quoted text -

I think this may be closer - but, keep in mind that you seem to be
starting with F8... I need to start with F7 that is the first row...
basically, if F7 has data, then D7 will be 1... (no one ever skips
F1).

I tried this formula in place of my D7 formula but it errored (even
when changing the F8 to F7...

Can you tell me the formula I'd use to make this work from the first
box?