Help!!! (Functions)

[Guest]

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

 

[Andy B]

Hi

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

--
Andy.

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??

 

[Andrew]

Download http://longre.free.fr/downloads/Morefunc.exe from Mr. Longre'
site and use the LASTROW function to get the last value in a column.

This add-in will need to be installed in other computers if they wil
access your file

 

[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
(e-mail address removed)

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??

 

[Don Guillett]

This will ignore blanks (del key)

 

[Andy B]

Don

I was working on the theory that there wouldn't be any!!

Cheers

 

[Don Guillett]

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

 

[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

 

[Don Guillett]

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

 

[Don Guillett]

match(99999999999,3:3) for rows