pam5cashfan
New Member
- Joined
- Dec 31, 2018
- Messages
- 5
First time posting...advanced beginner level skills. Currently working on data set of 5000 lines/month and I'll need to aggregate at least 4 months in each file.
Here's what i'm trying to flag with as simple a formula as possible:
If there is no change in column A in consecutive rows, and there is a change in column B in consecutive rows - that's what I want to know.
The data in these columns is in text.
I'm getting three outputs - FALSE, TRUE, and what I thought I had proposed as value-if-true "Switch"."Switch" appears when the first condition has not been met (A2<>A3), but I want it to appear when both conditions have been met (A2=A3, B2<>B3)
How can three outputs exist? Should I be using nested If's instead of If(And ?
Thanks.
Here's what i'm trying to flag with as simple a formula as possible:
If there is no change in column A in consecutive rows, and there is a change in column B in consecutive rows - that's what I want to know.
The data in these columns is in text.
I'm getting three outputs - FALSE, TRUE, and what I thought I had proposed as value-if-true "Switch"."Switch" appears when the first condition has not been met (A2<>A3), but I want it to appear when both conditions have been met (A2=A3, B2<>B3)
How can three outputs exist? Should I be using nested If's instead of If(And ?
Thanks.