L
llong3316
i have a spreadsheet that has the following information: Column A is Employee
and Column B is location captured, L = Upper level, A= Lower Level, and the
location is captured in sequential order, Column C indicates upper or lower
level. How can create an if statement that will count the round trip for each
employee. I.e if Jack goes from L to L then A should be 1 round trip for me.
Please help.
Column A Column B Column C
Jack L233 1
Jack L234 1
Jack A211 0
Jack A654 0
Jack L251 1
Jill L296 1
Jill L441 1
Jill L298 1
Jill A217 0
Jill L221 1
and Column B is location captured, L = Upper level, A= Lower Level, and the
location is captured in sequential order, Column C indicates upper or lower
level. How can create an if statement that will count the round trip for each
employee. I.e if Jack goes from L to L then A should be 1 round trip for me.
Please help.
Column A Column B Column C
Jack L233 1
Jack L234 1
Jack A211 0
Jack A654 0
Jack L251 1
Jill L296 1
Jill L441 1
Jill L298 1
Jill A217 0
Jill L221 1