Quote:
Originally Posted by NoSparks
another possibility:
assuming the 58 in your example is in A34, try this in A35 and drag down
Code:
=IF(B35="","",MAX($A$34:$A34)+1)
don't know where the first number on sheet 2 would be, but something like this in the cell should get the next number
Code:
=MAX(Sheet1!$A$34:$A$500)+1
|
The IF MAX formula works!! I applied it on my worksheet and at first it returned 1,2,3 but when I retyped 58 on the cell above the formula. The correct numbers popped out. I am now learning the macro of it.
09-08-2018, 03:12 PM
Similar Threads
Return Multiple values from data except blanks with two criteria
Windows 7 32bit 
Office 2007
Threaded Mode