How to mention row number in the formula

[Arpita_Excel]

Hello Everyone,

I want to know that how I can mention the row number in the formula.

Lets say I want to find out the large number in the column, to pick the largest number from the column how I can use the row function along with large function.

Thanks

[FDibbins]

If you want to find the row number with largest value, try this...

=match(max(A:A),A:A,0)

This will only work if there are no duplicates, otherwise it will just find the 1st instance

[sakib]

You can also try this:

=ADDRESS(MATCH(MAX(A:A),A:A,0)

Thanks.

[Arpita_Excel]

Thanks for helping me

I want to know can I use Large function along with row function if yes so how I can make the formula.

[FDibbins]

I want to know can I use Large function along with row function if yes so how I can make the formula.

Why? what exactly are you trying to do?