Hi,
Thank you for your response. I tried the formula and it would not change when I entered the formula and used my Data validation (drop down) to change the data selection...
This is how my document is set up. The dates along the top have the drop down all ready... So, if I use the drop down in B1 and choose Jan-Mar 10, I want the entire column to change, not just the date. I do not want column A to change. The idea is to be able to have the most recent quarter date...
Hello,
I am having trouble getting my data to correspond with the data I have validated. My spread sheet is divided into 8 quarters and the data below is a mix of text and numbers.
I want to have it all correspond when I make my selection. For example: When I select quarter 3 I would like...