LinkBack URL
About LinkBacks
Hi,
I need to lookup and order dates from earliest till latest based on a company name and a month number.
please see attachment
Hi,
I need to lookup and order dates from earliest till latest based on a company name and a month number.
please see attachment
Try this in I6:
=IFERROR(SMALL(IF(I$3&J$3=D$3:D$16&B$3:B$16,C$3:C$16),ROWS($1:1)),"") Ctrl Shift Enter
Hi,
this formula doesn't work
i got a error: too many arguments in this if function.
have you tried it and if possible can you share with me the file
I also tried this one but not get the result.
I guess you mean that you can't get it to work on your end. It works fine on my end.this formula doesn't work
Try this instead:
=IFERROR(SMALL(IF((D$3:D$16=I$3)*(B$3:B$16=J$3),C$3:C$16),ROWS($1:1)),"") Ctrl Shift Enter
I have inputted both formulas into the sample that you shared in post #1 and attached it here for you to see.
The formula works fine for me.
double check if your seperation key is a comma or a semicolon
Formula:
Please Login or Register to view this content.
And make sure you enter it as an Array Formula, that means that you need to confirm it with CTRL+SHIFT+ENTER, instead of just enter.
You will see if this worked when you see these "{" "}" brackets around the formula. (adding these manually doesn't work)
Remember to mark as Solved and give out rep.
Here's a non-array (just enter...) alternative:
=IFERROR(AGGREGATE(15,6,$C$3:$C$16/(($B$3:$B$16=$J$3)*($D$3:$D$16=$I$3)),ROWS($1:1)),"")
Please amend your location to show us,in general terms, where you are in the world. lulu may mean Honolulu, but might also mean....????
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks