I'm trying to come up with a formula where if 'lease 1' has a variance of 10% or greater then the formula would list ALL the variance reasons. See below column I for what I'm hoping to return with.
Thank you in advance.
Nick
Thank you in advance.
Nick
test.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | |||
1 | 2009RATBudgetvs.Actual(CurrentMonth) | DollarVariance | |||||||||
2 | Region | Market | Budget$ | Actual$ | Variance | Variance% | VarianceRank | Hownotesshouldcomeout | |||
3 | Central | RCHI | 134,320 | 52,866 | 81,454 | 61% | 1 | Lease1hadnoexpenseincurrentmonth,Lease3cameinunderbudget,Lease4hadunbudgeteddollarsof$10k | |||
4 | CentralTotal | 134,320 | 52,866 | 81,454 | 61% | ||||||
5 | |||||||||||
6 | 2009DetailbyLeaseID | ||||||||||
7 | FINALCategory | FINALSubCategory | 2009.Jan | 2009.Jan | Variance | ||||||
8 | RCHI | 1 | 90,022 | - | (90,022) | ($90k) | |||||
9 | RCHI | 2 | 28,344 | 28,344 | - | ||||||
10 | RCHI | 3 | 14,319 | 12,887 | (1,432) | ($1.4k) | |||||
11 | RCHI | 4 | - | 10,000 | 10,000 | $10k | |||||
12 | RCHI | 5 | 1,635 | 1,635 | - | ||||||
13 | RCHI | 6 | - | - | - | ||||||
14 | RCHITotal | 134,320 | 52,866 | (81,454) | |||||||
15 | |||||||||||
16 | VarianceExplanationslist | ||||||||||
17 | hadnoexpenseincurrentmonthgeneratingvarianceof | ||||||||||
18 | cameinunderbudgetby | ||||||||||
19 | hadunbudgeteddollarsof | ||||||||||
Central |