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
taghreed almuhajiri - Mar 15, 2014 at 03:57 AM
Related:
- Use of Max and Min functions.
- Free fire max download - Download - Battle royale
- Free fire max email id - Guide
- Hbo max download pc - Download - Movies, series and TV
- Max repel cheat code fire red - Guide
- Qbittorrent max number of downloads - Guide
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
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:
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
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
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014
Mar 11, 2014 at 12:14 PM
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
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
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-----|
-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
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
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014
Mar 11, 2014 at 05:03 PM
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 )
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
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 11, 2014 at 09:22 PM
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 )..."
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.
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.
taghreed almuhajiri
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014
Mar 12, 2014 at 01:15 AM
Mar 12, 2014 at 01:15 AM
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 12, 2014 at 09:31 AM
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.
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.
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.
