Trying to find current Row

[Wolfin2010]

I'm trying to figure out is there a formula which can output the the row number where it formula is placed?

exp.
A1=CURRENT ROW

Result= 1
....
A22=CURRENT ROW

Result= 22

[Pete_UK]

Try this:

=ROW()

Hope this helps.

Pete

[Wolfin2010]

Try this:

=ROW()

Hope this helps.

Pete

Thank you it worked like a charm but it did not resolve me main objective.

My formula is getting bigger and bigger so I thought if I use the Name Manger it will solve that problem using the ROW gave me the answer I wanted but not as same as I desire.


My Formula

=IF(A15="","",IF(D15="","",IF(D15>OT,((D15-OT)*VLOOKUP(A15,Rate,2)*1.5*1.13*24)+OT*VLOOKUP(A15,Rate,2)*1.13*24,D15*VLOOKUP(A15,Rate,2)*1.13*24)))

Name Manager

• OT
• Rate
• DD
• AA

DD: ="D"&ROW()
AA: ="A"&ROW()

with the Name Manager AA and DD I want to remove the column A & D from the formula and I can use same formula wherever I want.

[Pete_UK]

You will need to use the INDIRECT function to convert the string "D"&ROW() into a cell reference that Excel can work with, so I'm not sure that this is going to shorten your formula.

Pete

[Wolfin2010]

Thank you very much Pete I really appreciate it.

Using INDIRECT I removed the fixed location values and made ONE formula using the Name Manager.

One more question regarding the ROW can get the value of next row as-well, I tried ROW()+1 but it just added 1 with the value of that row.

Exp. T
A18: 101
A19: 100
A20: 250 GET the value of A21 (Trying not to put A21)
A21: SUM

[davsth]

Its not entirely clear what you want but just equal the reference in the row below works. Eg in b21 =b22 for example. An attachment with your desired result as per the banner would make things easier.