I'm trying to find the lowest price for any product in a group of substitutable products. My thought was to use an array formula but it doesn't seem to work.
The formula in B8 is:
Please Login or Register to view this content.
It's working for Site 2, but only because the MATCH part of the formula only picks up the first item from the list of valid items, rather than the whole array as I had expected.Please Login or Register to view this content.
Is there another way to approach this?
Last edited by oCoCarbon; 04-28-2017 at 04:45 AM.
Hi
Try, for ex., this array formula:
=MIN(IF(COUNTIF($E$2:$E$4,$A$2:$A$6),IF(ISNUMBER(B2:B6),B2:B6)))
I cross-posted this at SuperUser here and got an answer that works. Here it is for future searchers:
Where:Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks, @lecxe. I now have a couple of options to try out and see which is faster.
Withdrawn by FR.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks