Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding decreased value PLEASE HELP ASAP!
I have to use 3 quarters of data for various 'districts'. Based on the 3
quarters of data, I have to indicate the district that has best implemented strategies to best reduce their numbers over the 3Q's of time. How can I do this? What formula or function would I use to calcuate the numbers for each district? |
#2
|
|||
|
|||
"grimschris" wrote...
I have to use 3 quarters of data for various 'districts'. Based on the 3 quarters of data, I have to indicate the district that has best implemented strategies to best reduce their numbers over the 3Q's of time. How can I do this? What formula or function would I use to calcuate the numbers for each district? Does 3 quarters of data mean you have data as of the end of those 3 quarters? Anyway, it seems like you want to find either the largest absolute or relative decrease in costs from the earliest period to the latest period. You'd need to start by subtracting latest cost figures from earliest cost figures for each district. Then for relative differences only, divide the differences previous calculated by earliest costs to get percentage decrease. At this point you should have two ranges of calculations, AbsoluteChanges and RelativeChanges. If you had a corresponding range of district IDs, which I'll refer to as DistrictIDs, you can identify the district with the largest decreases using the formulas absolute change: =INDEX(DistrictIDs,MATCH(MIN(AbsoluteChanges),Abso luteChanges,0)) relative change: =INDEX(DistrictIDs,MATCH(MIN(RelativeChanges),Rela tiveChanges,0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding the last value | Excel Discussion (Misc queries) | |||
How can i imput a formula in excel for finding the area of a regu. | Excel Discussion (Misc queries) | |||
Finding Partial Text in a Cell | Excel Worksheet Functions | |||
Finding & Capturing First Occurance | Excel Worksheet Functions | |||
Finding the average by dropping the lowest | Excel Worksheet Functions |