Calling Excel Experts...
Drifting
Joined: Sep 2004
Posts: 3,474
Likes: 113
From: Seattle, WA
Originally Posted by CGTSX2004
Here you go...
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
Just replace the "B:B" with the actual range of values and Excel will automatically pull the last value in the selected range.
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
Just replace the "B:B" with the actual range of values and Excel will automatically pull the last value in the selected range.
holy schnikes... I thought I was pretty good at excel until this post...
Thread Starter
Joined: Jun 2004
Posts: 35,532
Likes: 1,654
Originally Posted by CGTSX2004
Here you go...
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
Just replace the "B:B" with the actual range of values and Excel will automatically pull the last value in the selected range.
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
Just replace the "B:B" with the actual range of values and Excel will automatically pull the last value in the selected range.
Originally Posted by CGTSX2004
Here you go...
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
Just replace the "B:B" with the actual range of values and Excel will automatically pull the last value in the selected range.
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
Just replace the "B:B" with the actual range of values and Excel will automatically pull the last value in the selected range.
nice, never woulda got that in a million years.
just out of curiosity, wut does 9.99999999999999E+307 do?
Thread Starter
Joined: Jun 2004
Posts: 35,532
Likes: 1,654
Originally Posted by CGTSX2004
Here you go...
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
Just replace the "B:B" with the actual range of values and Excel will automatically pull the last value in the selected range.
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
Just replace the "B:B" with the actual range of values and Excel will automatically pull the last value in the selected range.
Originally Posted by revitupwriteitoff
^ how does that work? never learned that one.
Returns the reference of the cell at the intersection of a particular row and column. If the reference is made up of nonadjacent selections, you can pick the selection to look in.
MATCH function:
Returns the relative position of an item in an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) that matches a specified value in a specified order. Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself.
Basically, you use the match function to provide a reference to the last value in given range and the index function finds the value.
Took me a while to understand what he was trying to do, but the explanation along with the picture cleared it up.
And I have learned much of Excel fairly recently because my job has required a pretty substantial amount of Excel manipulation of data lately. Mostly when I come across something I don't know how to do, the internet has proven quite fruitful in supplying answers.
Thread Starter
Joined: Jun 2004
Posts: 35,532
Likes: 1,654
Originally Posted by CGTSX2004
INDEX function:
Returns the reference of the cell at the intersection of a particular row and column. If the reference is made up of nonadjacent selections, you can pick the selection to look in.
MATCH function:
Returns the relative position of an item in an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) that matches a specified value in a specified order. Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself.
Basically, you use the match function to provide a reference to the last value in given range and the index function finds the value.
Took me a while to understand what he was trying to do, but the explanation along with the picture cleared it up.
And I have learned much of Excel fairly recently because my job has required a pretty substantial amount of Excel manipulation of data lately. Mostly when I come across something I don't know how to do, the internet has proven quite fruitful in supplying answers.
Returns the reference of the cell at the intersection of a particular row and column. If the reference is made up of nonadjacent selections, you can pick the selection to look in.
MATCH function:
Returns the relative position of an item in an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) that matches a specified value in a specified order. Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself.
Basically, you use the match function to provide a reference to the last value in given range and the index function finds the value.
Took me a while to understand what he was trying to do, but the explanation along with the picture cleared it up.
And I have learned much of Excel fairly recently because my job has required a pretty substantial amount of Excel manipulation of data lately. Mostly when I come across something I don't know how to do, the internet has proven quite fruitful in supplying answers.
Originally Posted by gatrhumpy
Nice! What does the 9.9999999^306 do?
Thread
Thread Starter
Forum
Replies
Last Post
08_UA7_Gr33k
Member Cars for Sale
13
Feb 11, 2016 02:17 PM
InFaMouSLink
Car Parts for Sale
6
Oct 27, 2015 06:52 PM
08_UA7_Gr33k
Member Cars for Sale
1
Sep 27, 2015 01:56 PM