Home |
Search |
Today's Posts |
#1
|
|||
|
|||
offset? match index? sumif? 2way look-up?
the scenario: s/n veh_no status task 0 x123 0 x123 0 x123 op last task 1 x123 1 x123 1 x123 op last task 2 x123 2 x123 workshop over here, the results are in clm A. the status was given to the last task on the vehicle and a s/n was issued to the last task and the previous tasks that were done on the vehicle. in C4 ,if the status is op, A2:A4 will return 0. in C7,if the status is is op , A5:A7 will return 2 . The numbers are incremental. the main thing is that the same s/n is given to the last task and the previous tasks when the input in status <"" hope i am clear. -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=479353 |
#2
|
|||
|
|||
offset? match index? sumif? 2way look-up?
Arent you just looking for a count of "last tasks" or "op"
-- paul remove nospam for email addy! "cjjoo" wrote: the scenario: s/n veh_no status task 0 x123 0 x123 0 x123 op last task 1 x123 1 x123 1 x123 op last task 2 x123 2 x123 workshop over here, the results are in clm A. the status was given to the last task on the vehicle and a s/n was issued to the last task and the previous tasks that were done on the vehicle. in C4 ,if the status is op, A2:A4 will return 0. in C7,if the status is is op , A5:A7 will return 2 . The numbers are incremental. the main thing is that the same s/n is given to the last task and the previous tasks when the input in status <"" hope i am clear. -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=479353 |
#3
|
|||
|
|||
offset? match index? sumif? 2way look-up?
actually yes, but the count criteria will be based on the status which can be "op" or "workshop". I am not sure whether to use countif or sumproduct. pls advise. -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=479353 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index - Offset - Match Issues | Excel Worksheet Functions | |||
Complicated Index Match Offset function | Excel Worksheet Functions | |||
Index, Match, Offset? Not sure which to use | Excel Worksheet Functions | |||
Which to use - if, vlookup, match, index, offset, vba? | Excel Discussion (Misc queries) | |||
lookup, index, match, offset, etc. | Excel Worksheet Functions |