Use of Max and Min functions.

[Closed]
Report
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014
-
 taghreed almuhajiri -
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

7 replies

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014

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
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014

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 )
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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.
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014

Good morning sir,

this is my whole work

http://www.megafileupload.com/en/file/507840/SPD-Vacation-Tracker-xlsx.html

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
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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.

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