Hi Experts,
I have file with 3 tab, I need formula in 1 sheet, there are 3 rows Value, Direction and percent, I need first 5 data extract from data tab according the criteria, if client choose from drop down any code out put will come in bottom and give me best five choise, then client choose days best 5 chooise will come as per criteria, as it is for value, direction and percent, I have attached screenshot and excel file.
Thanks is Advance.
gul
any expert can help?
Please try at sheet D16 press Ctrl+Shift+Enter and copy over
=INDEX(data!$C:$E,SMALL(IF((data!$A$1:$A$599=$D$2)*(data!$B$1:$B$599=$D$4),ROW(data!$A$1:$A$599)),COLUMNS($D16:D16)),ROWS(D$16:D16))
Hi Bo_Ry,
Thanks for help, but is not working on Value, after match code and days when I type in D6 any value it should only show matched value in output
please see screenshot if D2, D4 and D6 match that value will be come outbox, you will understand when you see screenshot and excel file...Thanks again
Last edited by AaruJaan; 11-24-2018 at 06:53 PM.
I see,
Please try again at D16 press Ctrl+Shift+Enter and copy over
Formula:
Please Login or Register to view this content.
Thank You Bo-Ry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks