| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two lists
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing two lists | Excel Discussion (Misc queries) | |||
| Comparing Lists | Excel Worksheet Functions | |||
| comparing lists - i think | Excel Discussion (Misc queries) | |||
| comparing lists | Excel Discussion (Misc queries) | |||
| Comparing 2 Lists | Excel Discussion (Misc queries) | |||
Threaded Mode
