Use of Max and Min functions.Closed

Question

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

Mazzaropi · Answer

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:
http://www.megafileupload.com/en/file/507556/11-03-2014-en-Kioskea-Searching-limits-xlsx.html

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 · Answer

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 · Answer

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-----|
-Number-|---City----|--Country-|--Address--|---Name--|

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 · Answer

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 )

Mazzaropi · Answer

taghreed almuhajiri, Good evening. 

First: "...it perfectly worked sir,..."
Now:"... ( I'm doing something wrong & I have no idea what it is )..."

Then, in this case, you must save your file at a free site, www.megafileupload.com, and put a link to download here.
 
Is totally necessary to see your Excel file to conclude what is happening.

I'm waiting for your excel file.

Mazzaropi · Answer

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.
http://www.megafileupload.com/en/file/507980/12-03-2014-SPD-Vacation-Tracker-xlsx.html

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.
http://www.megafileupload.com/en/file/507974/12-03-2014-en-Kioskea-Searching-limits-2-0-OK-xlsx.html

I hope it helps.
Have a nice day.

taghreed almuhajiri · Answer

Good morning

thank you, you helped me a lot
& if i had any other problem in the future with Excel i'll absolutely come & ask you

have a nice day

Use of Max and Min functions.

7 responses

Subscribe To Our Newsletter!