Help - code to automatically indicate the value

[captainobvious]

Hi everyone!
I need a code who identify the last value of column D of worksheet "Data" and put this value + 1 in worksheet "Form" cell E3. So the cell E3 of worksheet "Form" must have automatically the last value of column D of worksheet "Data" adding + 1 to this value. If no values in column D ​​then the cell E3 of worksheet "Form" gives the value 1 (0 + 1)

I really appreciate some help,
Cheers

 

[Zack Barresse]

Hi there, welcome to the board Captain O!

Well, with your picture, you could use a simple formula...

=COUNT(Data!D:D)+1

This assumes you will count one number for every record which has a number in column D of the Data sheet. Meaning it doesn't actually get the last row but counts all numbers in the column.

To actually get the last value you could use something like this...

=IFERROR(INDEX(Data!D:D,MATCH(9.99E+307,Data!D:D)),0)+1

I'd recommend using a table for your data though (look on the INSERT tab).

 

[captainobvious]

Hi there, welcome to the board Captain O!

Well, with your picture, you could use a simple formula...

=COUNT(Data!D:D)+1

This assumes you will count one number for every record which has a number in column D of the Data sheet. Meaning it doesn't actually get the last row but counts all numbers in the column.

To actually get the last value you could use something like this...

=IFERROR(INDEX(Data!D:D,MATCH(9.99E+307,Data!D:D)),0)+1

I'd recommend using a table for your data though (look on the INSERT tab).

Thanks for reply! I've been thinking and it was only necessary this:

=IFERROR(MAX(Data!D:D)+1;"")

 

[Zack Barresse]

MAX() works too. But if you want to put a 1 if there is no value you'll need to adjust your formula...

=MAX(Data!D:D)+1

You don't need to wrap it in an IFERROR() either because if no numerics are found a 0 is returned.