I want to check a column that may contain duplicate values. If any value is duplicate then that may check the corresponding date of that column with another sheet’s date column. If both of the values(amount) and corresponding date both then it will check another corresponding column (assignment number) to make sure about which entry this is.
I am uploading two separate sheets for better understanding.
If this can be solved with a nested loop solution then what will be the easiest way? It would be really helpful if any relevant or similar .xaml is available. Or at least some idea.
These are the two sheets for my value crosscheck.