I have an excel question.

I have some products in A,B,C warehouses. How Can I compare the numbers in these warehouses and show the warehouse with the highest number?

Here's the Excel example

I tried If function but it didn't work.

CodePudding user response：

Recordig to your table, use =INDEX($B$1:$D$1,MATCH(MAX(B2:D2),B2:D2,0)) to get the name of warehouse with the highest number.

CodePudding user response：

Please try Max Function

Add below in E2 cell output should be 432 ( or highest in 3 coloumns ) =MAX(B2:D2)

CodePudding user response：

Since you want to find Max Value, you just need to use MAX function instead of if function.

you need to put the following in E2, E3, E4 column respectively.

=MAX(B2:D2)          
=MAX(B3:D3)
=MAX(B4:D4)

Refer to this link by microsoft.