Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

Find last number in column and calculate %

Hi,
I am helping someone with a worksheet and he has a column of numbers that add to a total and then calculates a % of the total from the new number.
Right now, he has to change the formula each time to capture the new number he enters.
Here is a sample file.
Your help is appreciated.
Find-last-value-and-subtract---s.xlsx
0
Johnette Connelley
Asked:
Johnette Connelley
1 Solution
 
NBVCCommented:
Try:

=SUM(A2-LOOKUP(10^10,A:A))/A2
0
 
barry houdiniCommented:
....although you don't really need SUM function - try

=1-LOOKUP(10^10,A:A)/A2

regards, barry
0
 
Johnette ConnelleyBudget Analyst / ProjectsAuthor Commented:
That is excellent!  Thanks so much!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now