Based on my example, I like to find a function that when I use the word Spring on F4, lines F6 to F9 will have those part numbers tied to the Spring word. By the way the table is located on columns B, C, and D. That's not the end of it.
If you look at the result, you'll see that the part numbers are listed from the highest to the lowest cost.
I was wondering if you guys can help me with this.
Thank you.
Please see attached file with formulas.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks for replying quickly. I just have a quick question. When I change cell D12, then, I get two of the same part numbers on cells H5 and H6. I used your sheet.
If you change value in D2 to create a duplicate, then yes. You will get two of the same part numbers as you should.Originally Posted by managingcrap
AlKey, I think mc wants to return both part numbers with duplicate amounts.
Dave
I meant when I have two values for the same seasons, I will still get those two different part numbers to show. Thanks.
This is one way.
Array-enter this formula in F3 and fill down.Then in H3 this array formula.Formula:
=IFERROR(INDEX($B$3:$B$15,SMALL(IF(G3=$D$3:$D$15,ROW($B$3:$B$15)-MIN(ROW($B$3:$B$15))+1),COUNTIF($G$3:G3,G3))),"")and fill down.Formula:=IFERROR(INDEX($B$3:$B$15,SMALL(IF(I3=$D$3:$D$15,ROW($B$3:$B$15)-MIN(ROW($B$3:$B$15))+1),COUNTIF($I$3:I3,I3))),"")
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks