Multi-row formula if statement

[jenner85]

Hi - 

I need to do the following - if the row above in the File name is different, I need to populate something into another column. 

Input:

File Name	CPC
1-Feb
1-Feb	BC
1-Feb
2-Feb
2-Feb	AH
2-Feb
3-Feb
3-Feb	AA
3-Feb

Output:

File Name	CPC
1-Feb
1-Feb	BC
1-Feb
2-Feb	ALL
2-Feb	AH
2-Feb
3-Feb	ALL
3-Feb	AA
3-Feb

Basically as soon as there is a change in filename, I need the first row to say ALL in the CPC column. 

thanks!

[jdunkerley79 · Accepted solution]

A multi-row formula tool updating the CPC column with an expression of:

IIF([Row-1:File Name]!=[File Name],"ALL",[CPC])

should work.

You will need to make sure the CPC column is of a type which can fit ALL in (hence using a SELECT tool in the example)

[vizAlter · Accepted solution]

Hi @jenner85  — Try this solution:

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.