Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel Formula
=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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel Formula
=MATCH(MAX(B:B),B:B,0)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "George A. Jululian" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel Formula
Many thanks it works but when i copy it down it gave the same result
the same row number which is wrong "Bob Phillips" wrote: =MATCH(MAX(B:B),B:B,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "George A. Jululian" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel Formula
What are you trying to achieve by copying the formula down? You asked for
the row number in which the largest value in the range appears. If in copying down you want to start by applying the formula to the range B1:B500 and then want to apply it to a new range B2:B501, you could change Bob's formula from =MATCH(MAX(B:B),B:B,0) to =MATCH(MAX(B1:B500),B1:B500,0) and then copy that down.# If, instead of that you wanted to find in row 1 the row number for the largest, but in the next row the row number for the second largest, and so on, then change Bob's formula to =MATCH(LARGE(B:B,ROW(A1)),B:B,0) and copy down. -- David Biddulph "George A. Jululian" wrote in message ... Many thanks it works but when i copy it down it gave the same result the same row number which is wrong "Bob Phillips" wrote: =MATCH(MAX(B:B),B:B,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "George A. Jululian" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel Formula
Many Many thanks for all
"David Biddulph" wrote: What are you trying to achieve by copying the formula down? You asked for the row number in which the largest value in the range appears. If in copying down you want to start by applying the formula to the range B1:B500 and then want to apply it to a new range B2:B501, you could change Bob's formula from =MATCH(MAX(B:B),B:B,0) to =MATCH(MAX(B1:B500),B1:B500,0) and then copy that down.# If, instead of that you wanted to find in row 1 the row number for the largest, but in the next row the row number for the second largest, and so on, then change Bob's formula to =MATCH(LARGE(B:B,ROW(A1)),B:B,0) and copy down. -- David Biddulph "George A. Jululian" wrote in message ... Many thanks it works but when i copy it down it gave the same result the same row number which is wrong "Bob Phillips" wrote: =MATCH(MAX(B:B),B:B,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "George A. Jululian" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |