checking data
 

I have two columns:
H J
Date Quarter

The both columns have a validation: Date is checking that entries should be
in the date format; Quarter is linked to a list of quarters and checking that
the entry is from that list.

However, I'd like to have some checking between these columns as well for
the dates matching with quarters. E.g., if Date is 1/1/2005 in H2 the user
should choose only Q1 from the list in J2.

How could I do it?

Thanks

checking data
 

Alex wrote:
I have two columns:
H J
Date Quarter

The both columns have a validation: Date is checking that entries
should be in the date format; Quarter is linked to a list of quarters
and checking that the entry is from that list.

However, I'd like to have some checking between these columns as well
for the dates matching with quarters. E.g., if Date is 1/1/2005 in H2
the user should choose only Q1 from the list in J2.


Alex:

Don't let them choose if there's only one choice. Put a formula in J to
calculate the quarter:

="Q"&CHOOSE(MONTH(H1),1,1,1,2,2,2,3,3,3,4,4,4)


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com