LinkBack URL
About LinkBacks
Hello, how can I find out which is the last number of the column? This code =LOOKUP(9.9E+307,Table1[Row Labels]) works only for tables, but I have a pivot table and this type of a code does not work. What is the formula for pivot table?
Hello, how can I find out which is the last number of the column? This code =LOOKUP(9.9E+307,Table1[Row Labels]) works only for tables, but I have a pivot table and this type of a code does not work. What is the formula for pivot table?
Isn't this just
=LOOKUP(9000000000+307,B1:B2000)
result is 25200.00
25200.00 is the last number in column B
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Does this work for you?
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Okay thanks. I will try this when I get home. Will this work if the pivot table always updates? The reason I ask is because I do logs on daily bases.Originally Posted by sktneer
Does this work for you?
Please Login or Register to view this content.
Okay thanks you gave me an idea for the last resort.
You're welcome!
Yes, it will return the correct value if the pivot table updates.
The formula suggested will return the last sum of price 3,200 (B15) not the Grand Total 25,200.
If you want to get the Grand Total value, try this instead...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks