| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statements going to next record 5 times
Please help.
I would like to compare information in A1 to AA1 if = I would like to then compare to the next record A2 If this is = I would like to compare to the next record A3 If this is = I would like to compare to the next record A4 If not = I would like to get information from AA2. I can get this to work with just 1 comparison but how do I get it to look at the next record? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Macro to Record Lap Times | Excel Discussion (Misc queries) | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| reducing the number of times an IF statement needs to be calculated in embedded IF statements | Excel Discussion (Misc queries) | |||
| Repeat statements "x" number of times... | Excel Discussion (Misc queries) | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Threaded Mode
