# Use of Max and Min functions.

Closed
taghreed almuhajiri Posts 13 Registration date Saturday March 8, 2014 Status Member Last seen March 19, 2014 - Mar 11, 2014 at 10:22 AM
taghreed almuhajiri - Mar 15, 2014 at 03:57 AM
hello there ,,

I have two column names & numbers

in different cells i need the highest number to display with the name next to it
same with the lowest number

thank you
Related:

## 7 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 11, 2014 at 10:27 AM
taghreed almuhajiri, Good morning.

I did a little example to you to demonstrate the use of MAX, MIN and a VLOOKUP Excel functions.

Take a look at this, as you requested:

Please, tell us if it worked for you.
Have a nice day.

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
taghreed almuhajiri Posts 13 Registration date Saturday March 8, 2014 Status Member Last seen March 19, 2014
Mar 11, 2014 at 12:14 PM
it perfectly worked sir, I'm more than satisfied about this site and I'm learning a lot of things from you but I have to ask

if there's many columns between the two ( name & num )
what to change about the formula?

thank you a lot
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 11, 2014 at 12:52 PM
taghreed almuhajiri, Good Afternoon.

Take a look at formula on G4
=VLOOKUP(MIN(A2:A11),A2:B11,2,FALSE)

A2:B11 is your Range to search a Name.
A - column 1
B - column 2

At formula you can see a bold number 2.
It means that a function will search a MIN at column 1 (A) and pick up a value at column 2 (B).

Suppose you have:
-----A-----|-----B-----|------C------|------D------|-----E-----|

A2:E11 will be your Range to search a Name.
then your formula will point to 5ª column(E)
=VLOOKUP(MIN(A2:A11),A2:E11,5,FALSE)

It means that a function will search a MIN at column 1 (A) and pick up a value at column 5 (E).

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
taghreed almuhajiri Posts 13 Registration date Saturday March 8, 2014 Status Member Last seen March 19, 2014
Mar 11, 2014 at 05:03 PM
Good evening sir,

Idk what I'm doing wrong but its not working on my work sheet
I understood the formula and I did the same based on my cell's number but every time I got this result #N/A
I tried with a new empty sheet , still wrong

the other columns that I have contains numbers also, I thought maybe that's the problem but even when I tried with only the two name & num
still wrong ( I'm doing something wrong & I have no idea what it is )

Didn't find the answer you are looking for?

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 11, 2014 at 09:22 PM
taghreed almuhajiri, Good evening.

First: "...it perfectly worked sir,..."
Now:"... ( I'm doing something wrong & I have no idea what it is )..."

Is totally necessary to see your Excel file to conclude what is happening.

I'm waiting for your excel file.
taghreed almuhajiri Posts 13 Registration date Saturday March 8, 2014 Status Member Last seen March 19, 2014
Mar 12, 2014 at 01:15 AM
Good morning sir,

this is my whole work

i test the formula in the file you send me it worked but i couldn't make it work in my file (that's what i meant)

anyway i want to apply this in the total sheet

thank you
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 12, 2014 at 09:31 AM
taghreed almuhajiri, Good morning.

I took a look at your Excel file.
Now I know what is the problem.

You need starts your search using a column different from your first column of the table.
In this case, you need use a combination of INDEX and MATCH functions to get the desired result.

I implemented at a cell next to your cell a new formula using Index+Match.

Attention:
When using MIN and MAX functions it's necessary to think about cells filled with 0(zero) and tied cases.

I sending you an Excel file, explaining the use of these functions too.