ExcelBanter - "sumproduct" ??

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - "sumproduct" ?? (https://www.excelbanter.com/excel-programming/396176-sumproduct.html)

fiur

"sumproduct" ??

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.......?

Tom Ogilvy

"sumproduct" ??

=Min(if(B2:E2=A1,B4:E4))

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

--
Regards,
Tom Ogilvy

"fiur" wrote:

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.......?

fiur

"sumproduct" ??

thans alot Tom you're the man!! (Btw my name is also Tom + Ole :) )

"Tom Ogilvy" wrote:

=Min(if(B2:E2=A1,B4:E4))

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

--
Regards,
Tom Ogilvy

"fiur" wrote:

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.......?

All times are GMT +1. The time now is 03:35 PM.