I have a single column of values in Column A.
I want to identify specific growth patterns in this column of Cells.
Ex: I want to see when the value of cell A2 (518.5) reaches 101% (or just about). I multiplied A2*101% and it returns the cell value in C2 "523.685". In the following column I the same thing, but with 99%, with this one returning "513.315" in D2.
The values that reach this percentage in are highlighted respectively. A2 reached 101% in cell A16 (highlighted yellow). A2 reached 99% in cell A6. I would like this to be as precise as possible, +/-.03
IE:
523.685(C2) - 523.389(A16) = 0.296
513.315(D2) - 513.08(A6) = 0.235.
Bookmarks