Incremental String (Excel Formula) based on Location

Mert

Hi,

Here is my dummy data:

Location	Category	Qty	Budget
Los Angeles	Rev	4	100
Los Angeles	Exp	6	170
New York	Rev	2	200
New York	Exp	4	250
London	Rev	7	325
London	Exp	6	325

What I would like to achieve is to add a field and add string (Excel formula) to every cell starting as C5*D5, incrementing based on Location. Please see below:

Location	Category	Qty	Budget	Formula
Los Angeles	Rev	4	100	C5*D5
Los Angeles	Exp	6	170	C6*D6
Los Angeles	Exp	6	120	C7*D7
New York	Rev	2	200	C5*D5
New York	Exp	4	250	C6*D6
London	Rev	7	325	C5*D5
London	Exp	6	325	C6*D6

Any suggestions please? Thanks!

philipmannering

HI @Mert 

Not sure exactly what you're going for here, but does the following help?

add-formula.yxmd