Return Numeric Value to their Matched Value Position in Single Column
On Mar 6, 7:01 pm, "Sam via OfficeKB.com" <u4102@uwe wrote:
Hivezerid,
Thank you very much for your time and assistance. Great Input!
I tweaked your Formula so that I could have a single formula to find the
relevant row of numbers and return them to their corresponding row value
Position in a single column.
=IF(ISNUMBER(MATCH(ROW()-ROW($N$17)+1,INDEX(Data,ROWS(Data)-17,0),0)),ROW()-
ROW($N$17)+1,"")
I would not have got the final solution without your help! Very much
appreciated.
Cheers,
Sam
vezeridwrote:
To get all 8 cells in a contiguous 1x8 range: Select all 8 cells and
enter:
=INDEX(Data,18,0)
This is an array formula, hence commit with Shift+Ctrl+Enter.
Let us say these values were collected in cells E1:L1. In N17 enter
the following formula and copy through N103:
=IF(ISNUMBER(MATCH(ROW()-ROW($N$17)+1,$E$1:$L$1,0)),ROW()-ROW($N
$17)+1,"")
HTH
Kostis Vezerides
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200703/1
Glad it worked. Thanks for the feedback.
Kostis
|