Thread: excel Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
George A. Jululian[_2_] George A. Jululian[_2_] is offline
external usenet poster
 
Posts: 89
Default excel Formula

it did not work the result gave wrong row number

"excelent" wrote:

=MATCH(A1,$B$1:$B$500,0)


"George A. Jululian" skrev:

Hi

column B from b1 till b500 is full of numbers and I have formula in column a
=LARGE($B$1:$B$500,1)

I want to find the result of the formula came from which row number

please help