Hello,
Ive been trying to work out how to stop some duplicates where a date and a drop down combine.
There are two columns, one with a date, the other is a drop down list, in the third a concatenation of the two.
When the list grows its easy to enter the date and drop down not reading that for the same date the drop down list option was already previously chosen, this results in an output in a summary sheet being incorrect, or a repeated value, and or an incorrect calculation.
I'm hoping to (based on advice) to be able to upon entry of either first date and then list choice or vice versa to check the concatenated row and if a duplicate exists to produce either an error, a message, or to disallow the entry.
I've attached an example spreadsheet as I know this is a bit of a long winded explanation.
Thank you in advance for your taking a look,
Kind regards AI
Bookmarks