Hello
I'm trying to do what I think is a complex condition in Excel.
In the below spreadsheet example:
In simple terms every time a User enters data into a row I want it do the following logic:
I'm trying to do what I think is a complex condition in Excel.
In the below spreadsheet example:
- I want the user to be able to enter a Buying Style Ref (Column A) multiples times based on certain conditions.
- If the user enters a duplicate Buying Style Ref multiple times. Then the data must match the data in Columns E, F and G of the previously entered Buying Style Ref: for example:
- Row 5 and Row 6 = correct
- Row 7 = incorrect, as it does not match the original data in the first instance (Row 5) (E7 does not match E5)
In simple terms every time a User enters data into a row I want it do the following logic:
- Does Buying Style Ref already exist.
- If 'yes'
- Does the data in Column E match with the first instance?
- Yes - leave white
- No - highlight red
- Does the data in Column F match with the first instance?
- Yes - leave white
- No - highlight red
- Does the data in Column G match with the first instance?
- yes - leave white
- No - highlight red
- Does the data in Column E match with the first instance?
- If 'yes'