Hi there
I've attached an example spreadsheet. I have a price list spreadsheet listing about 5000 items. What I want to do in a new sheet is type in the keyword and below that it lists all cells with that keyword. Can anyone help me please?
Hi there
I've attached an example spreadsheet. I have a price list spreadsheet listing about 5000 items. What I want to do in a new sheet is type in the keyword and below that it lists all cells with that keyword. Can anyone help me please?
Hi,
Check this with he help of Helper Column
Punnam
Hi thanks
WHere do i find that?
WHere do i find that?
Not clear what your asking for
Punnam
Hi, refer the attachment with formulas
☚ Click ★ just below left if it helps, Boo?ath?
Not sure why mine isn't working
I've substituted into your formula:
=IFERROR(INDEX(Pricelist!$A$1:$A$5000,SMALL(IF(Pricelist!$H$1:$H$5000="YES",ROW(Pricelist!$A$1:$A$5000),""),ROW(3:3))),"")
and I just get a blank?
Hello!
Array formula may be useful here. I've created a name from column B from "Price list" sheet, you may replace _Items with 'Price list'!$B$1:$B$13 if you want.
Formulas for all 3 columns look alike. I am using additional column with row number. Check the attachment.
Formula:Please Login or Register to view this content.
Best wishes and have a nice day!
Observation Required
1) Update "price List" with he if condition
2) after placing the placing the above formula in "find"Sheet of cell A4 you should use the combination of the following keys to activate the Array function
"Ctrl+Shift+Enter"
3) Do you have data in "Price List" from Row 1
4) as it is a array function it will take more time to calculate
5) In case of higher version of excel instead of "," you should use ";"
Punnam
Punnam
How do I attach another file?
Go to Advance tab from there in tool box you will "attachment " image
Punnam
OK thanks, here's a more accurate version of the s/sheet I'm trying to do
I'm using Excel 2010 and there are 5000 rows altogether in my spreadsheet
Hi,
Find the attached updated file
Punnam
Thanks so much, when I change the keyword, how do I get it to calculate again?
NVRensburg
Just type the desired keyword , rest will be done automatically .
Punnam
Hi small Change in formula in Column H of Pricelist
Formula:Please Login or Register to view this content.
Punnam
Last edited by Punnam; 10-08-2014 at 09:13 AM.
Thanks Punnam, however you've got SOUP as the keyword but it's not returning the correct items?
Thanks so much Punnam! I can't thank you enough for all your help today! You've been an absolute star!!!!!
Hi Nvrenburg,
Thanks for the Rep & Feedback.
punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks