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

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

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