Help!!! (Functions)

C

Christen

In a report i have I was using the MAX function, which i thought was pulling the last value in a column. Instead that function just picks the highest value. Is there a function in Excel, that pulls the last value it sees in a range of cells to use to make a total??
HELP!!!!
Christen
 
A

Andy B

Hi

Try this:
=INDEX(G:G,COUNTIF(G:G,"<>"),1)

--
Andy.


Christen said:
In a report i have I was using the MAX function, which i thought was
Click to expand...
pulling the last value in a column. Instead that function just picks the
highest value. Is there a function in Excel, that pulls the last value it
sees in a range of cells to use to make a total??
 
D

Don Guillett

Try using match to find a number larger than is possible for the row and
index to get the info.
=INDEX(B:B,MATCH(999999999,B:B))
--
Don Guillett
SalesAid Software
[email protected]
Christen said:
In a report i have I was using the MAX function, which i thought was
Click to expand...
pulling the last value in a column. Instead that function just picks the
highest value. Is there a function in Excel, that pulls the last value it
sees in a range of cells to use to make a total??
 
D

Don Guillett

findS a number larger than is possible
ie: It is looking to MATCH the number which is not there.
 
A

Andrew

=INDEX(G:G,MATCH(999999999,G:G))

Works like a wonder Mr. Guillett. I like how it can also be used fo
rows.

Andy B's formulas works with text if there are no blanks
 
D

Don Guillett

Yes, but sometimes those pesky end users touch the delete key by mistake. Me
too. <G>
 
Top