Recently I was working on an excel sheet that needed to compare the current value to the start value. The list is updated monthly so the column is constantly expanding. After some searching I came up with the following formula:
=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))/A#
Replace the red letter A's with the column you are working with.
Example, if the data is in column E, the formula would look like this:
=INDEX(E:E,MATCH(9.99999999999999E+307,E:E))
Replace the green A# with the static reference cell.
The way I had this setup was to have the original data along with the % up at the top of my page, the cells below would have the running data.
this creates a dynamic formula that can replace:
= (cell1) / (cell2).
Subscribe to:
Post Comments (Atom)
Samsung refrigerator not making ice
How I got my stupid fridge to work again. Normally, I press/hold the blue button till it chimes. Well that didn’t work this time. Darn. I re...
-
Situation: Vizio sound bar works. But all of a sudden, no sound. The movie is playing fine, but no sound. On the sound bar itself, two ind...
-
I have a customer that would like 3 monitors, for whatever reason. The Dell 9020 is capable of this, and this is how I got it to work. No ...
No comments:
Post a Comment