Do you know the formula for Excel table?

release formula to field a number in ascending order when the field is filled d

The best answer

Thank you, however this would be continuously each column then. I need the invoice number nich among themselves special may be the column for example, 2 to 4 will be sold later and column 5 is sold next. Is there a formula

Give in A1 a first invoice number. In A2 now following formula

  = IF (D2 = ""; ""; A1 + 1)

This you can now to A1000 or further down to copy.

Need consecutive invoice number

My example. A1 and d3

Which field A? A1 or A2, or do you mean column A and column D?

Date: 2012-12-15 Views: 0
Tags: Excel

Related articles



Copyright (C) 2017, All Rights Reserved.

M3tch all rights reserved.

processed in 2.028 (s). 10 q(s)