My title probably doesn't explain very well what I need to do.
Basically it is not just to identify duplicates based on multiple criteria, but also then to return a value for all of the entries, if another criteria is met by any one of the duplicate records.
I have a table listing all payments made iro people on a course, the columns to compare / analyze are the Client ref, the start date and the Registration fee, which may be at a reduced rate.
There are a number of other columns re different payments such as Child Care and Travel and each payment is listed separately. Therefore the Registration fee will not always be completed, but will appear against one different start date per client and a client may have a number of entries.
I can identify the duplicates across the client ref and start date, however I need to return "Reduced" for all incidences if the client had a reduced registration fee in order to identify all payments made based on a reduced registration fee.
I have attached a sample workbook, the formula I am using (Column A) is returning "Reduced" for those duplicate client refs and start dates, but only if the Registration fee column is completed with the rate of 200, whereas I need it to return "Reduced" in column A against those rows highlighted in yellow as they are relevant to the course in question.
The Client reference will not necessarily be in numerical order.
Any help would be hugely appreciated as I really am just going round in circles.