Unable to extend formula to further rows.....
Dear Excel Experts,
I am tried to extend the excel formula from Row number 172 to row number 500.
I made the respective changes (i.e. changing row number 172 to 500)...but the formula won't work. It works perfectly when up to row number 172.
The Excel sheet is attached herewith.
Can anyone please solve my problem. I wish to extend the range upto row 500.
Thanks in advance
Jay Product list_sort enabled.xlsm
D5=IF($D$2="","",IFERROR(INDEX($A$2:$A$500,SMALL(IF(ISNUMBER(SEARCH($D$2,$A$2:$A$500)),ROW($A$2:$A$500)-ROW($A$2)+1),ROWS($E$5:$E5))),"")) with Ctrl+Shift+Enter and drag down
E5=IF($D$2="","",IFERROR(INDEX($B$2:$B$500,SMALL(IF(ISNUMBER(SEARCH($D$2,$A$2:$A$500)),ROW($A$2:$A$500)-ROW($A$2)+1),ROWS($E$5:$E5))),"")) with Ctrl+Shift+Enter and drag down.
Sample file is attached
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Dear Ankur,
I did same and again did as per your suggestion.
Formula not working.
Unable to download your sample file as there is no any attachment.
Regards
Jay
Please check the attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks