Formula tool

Tim6

Hi There,

I have data where each person can have a different rate each month:

ID Jan Rate Feb Rate March Rate April Rate

Tim 4.75 4.75 4.75 4.75

Cassey 4.75 3.75 4.75 4.75

Yvonne 4.75 4.75

For each person, I would like to know in which months there was a rate change.

I would also like to account for the possibility that the customer discontinues their services (ex. Yvonne - there was no rate in March or April but the same rate was used in Jan and Feb which means there was no rate change).

Would you be able to help me out with this?

Thank you.

Expression

Accepted answers

Blake

Hi Tim, I think we can address both of those questions with 2 tools. I used a multirow formula to create a data point for each of the prior month's rates and then filtered to only include the month's where there was a change.