is there a way to add number of rows and a number? example: P8 + 5 and the result will be P13.
K kyoko May 16, 2009 #1 is there a way to add number of rows and a number? example: P8 + 5 and the result will be P13.
A ANONYMOUS May 16, 2009 #2 How about something like this: =ROW()+5 The result will be a cardinal number. You will then need to add a VLOOKUP formula to interpret =COLUMN() to give A, B, C etc. hth
How about something like this: =ROW()+5 The result will be a cardinal number. You will then need to add a VLOOKUP formula to interpret =COLUMN() to give A, B, C etc. hth
