P
pgarcia
I have to list that change daily.
A B C D E F G
info info $ C1-D1 $ info info
When D1 brings back a negative amount, I write "down" in that cell and then
shift the date to the right of it down. Redo the formula to cell-cell. When
it comes back with positive amount, I write "up" in that cell and then shift
the date to the left of it down.
I need the up and downs to compare from yesterdays data.
This is taking way to long. How can I shorten the process?
Example:
A B C(formula) D E
185027 $6.40 $- $6.40 CIRCOR ENERGY PRODUCTS
down $6.40 MONTAPLAST OF NORTH AMERICA
down $6.35 MONARCH HYDRAULICS
down $6.35 SONUS NETWORKS
93247 $6.34 $(0.01) $6.35 UNITED REFRIGERATION
1465 $6.30 $(0.04) $6.34 ACME CRYOGENICS
499512 $6.23 $(0.09) $6.32 WOOD GROUP TURBO POWER
A B C D E F G
info info $ C1-D1 $ info info
When D1 brings back a negative amount, I write "down" in that cell and then
shift the date to the right of it down. Redo the formula to cell-cell. When
it comes back with positive amount, I write "up" in that cell and then shift
the date to the left of it down.
I need the up and downs to compare from yesterdays data.
This is taking way to long. How can I shorten the process?
Example:
A B C(formula) D E
185027 $6.40 $- $6.40 CIRCOR ENERGY PRODUCTS
down $6.40 MONTAPLAST OF NORTH AMERICA
down $6.35 MONARCH HYDRAULICS
down $6.35 SONUS NETWORKS
93247 $6.34 $(0.01) $6.35 UNITED REFRIGERATION
1465 $6.30 $(0.04) $6.34 ACME CRYOGENICS
499512 $6.23 $(0.09) $6.32 WOOD GROUP TURBO POWER