Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tough formula problem
I have a spreadsheet which tracks employee transactions and times. In column
L, I have the following formula. =IF($D2=13328000,$J3-$J2,IF($D2=13328100,$J3-$J2,IF($D2=13328200,$J3-$J2,IF($D2=13280300,$J3-$J2,IF($D2=13280800,$J3-$J2,IF($D2=13288100,$J3-$J2,IF($D2=13286500,$J3-$J2,""))))))) In column D are different codes like 13286500 or 10051202. Sometimes some of the codes get out of sequence which skews my results. The last part of the formula is where this is happening IF($D2=13286500,$J3-J2,""). If everything is done in the right sequence, it works fine, but sometimes they get out of sequence. For it to work correctly, for example, cell D2 would be 13286500, cell D3 would be 10051202 and cell D4 would be 10026100. When it gets out of sequence, the value that should be in cell D3 would be before cell D2 in cell D1 and cell D3 is now in D2. Is there something that I could add to my existing formula that would calculate $J1-$J2 if 10051202 is the cell above 13286500 instead of below it? I know this is confusing and I hope I explained it okay. A solution to this problem would be greatly appreciated. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
formula percentage problem | New Users to Excel | |||
problem with Array Formula | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) |