Hi All,
Much appreciated if someone could advise why this code cannot be works in the attached excel.
=INDEX($B$2:$B$8, SMALL(IF($A$11=$A$2:$A$8, ROW($A$2:$A$8)-ROW($A$2)+1), COLUMN(A1)))
Thanks.
Regards,
Jack
Hi All,
Much appreciated if someone could advise why this code cannot be works in the attached excel.
=INDEX($B$2:$B$8, SMALL(IF($A$11=$A$2:$A$8, ROW($A$2:$A$8)-ROW($A$2)+1), COLUMN(A1)))
Thanks.
Regards,
Jack
Last edited by jackyong1985; 08-18-2012 at 05:39 AM.
Its an array formula, make sure you confirm with Ctrl+Shift+Enter and not just Enter
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks for your info. I've one more question. The data will amend accordingly if i drag horizontally. However, if i drag vertically, it just won't change even i've added the data such as Oranges, Pears etc at row A. My data are quite a lot hence it's impossible for me to edit the code manually. Thanks.
Extend the ranges $A$2:$A$8 and $B$2:$B$8 to include added rows?
Hi,
I've attached the file for further details. The figure just won't changed. Please assist and much appreciated your help.
Regards,
Jack
Still an array formula:
Please Login or Register to view this content.
Docendo discimus.
For your title - it's not code it's a formula
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Sorry for the misleading title. Thanks for your help Cheshirecat. .. much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks