I'm doing research with a professor at the University of Florida. This is my first time using Excel to any extent, so I need everything from the ground up!
I have the housing values for each of the 50 states from 1975 to 2006. I need to analyze each state individually to see if there were any points during that 26 year span when housing values increased by more than 20%. I need to know when this increase started and when values peaked and began to fall. I could do this manually, but I'm assuming that would take a while.
Is there a simple way to do this in excel? A macro, or a UDF (I have no clue about either of them by the way).
Thanks so much!
The 50 states are listed in a column and the rows next to each state having housing values for the 26 years. ( I don't know if that is relevant).
I have the housing values for each of the 50 states from 1975 to 2006. I need to analyze each state individually to see if there were any points during that 26 year span when housing values increased by more than 20%. I need to know when this increase started and when values peaked and began to fall. I could do this manually, but I'm assuming that would take a while.
Is there a simple way to do this in excel? A macro, or a UDF (I have no clue about either of them by the way).
Thanks so much!
The 50 states are listed in a column and the rows next to each state having housing values for the 26 years. ( I don't know if that is relevant).