Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have many sets of percentages (can over 20) for six month periods that I
analyzed. When I get a new set of percentages, I want to compare it to the old sets and see which old set it is most similar to. I have been doing this by lines graph but is there an easier way because I have alot of old sets. See below MON DATA 1 DATA 2 DATA 3 €¦DATA 20 NEW DATA 6 7.16% 5.94% 11.89% 8.08% 5 11.86% 7.52% 11.36% 11.56% 4 20.15% 13.27% 14.91% 25.01% 3 25.89% 23.25% 21.03% 26.73% 2 6.59% 24.01% 8.70% 13.41% 1 28.34% 26.03% 32.12% 15.21% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
comparing columns of data | Excel Worksheet Functions | |||
Comparing 2 years of data on a monthly basis | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Comparing data in two similar worksheets | Excel Discussion (Misc queries) |