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!
@binuacs and @DataNath thank you both for your prompt and working replies.
@PhilipManneringthank you for your time as well however I need a workflow that approaches the new field incrementally per location.
No worries @Mert. As long as the community as a whole has provided you with a working solution, that's the main thing!