"sumproduct" ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I got an problem....
I wanna compare cell a1 with b2:e2 (if any of those cells are equal) then
find minimun value in cell b4:e4

of do I do that.......?
 
=Min(if(B2:E2=A1,B4:E4))

entered with ctrl+Shift+enter rather than just enter since this is an array
formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Condition 4
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Very strange behaviour of VLOOKUP in Excel 2010 4
Excel Need Countifs Formula Help 0
Another SumProduct Question 3
How to do this with macro? 2
How do I write a select case statement for range 5
Copy and Paste Macro 5

Back
Top