Jul 03 2019 07:20 AM
Hi,
I am trying to create a a count if with the below criteria:
1) Customer name (column A) is a duplicate,
2) The value in column B is greater than 90% of the original entries value in column B,
3) The value in column B is less than 110% of the original entries value in column B.
Thanks in advance for any help,
Jul 03 2019 08:41 AM
Jul 03 2019 08:44 AM
@Twifoo thanks for your help.
I have uploaded an example workbook to try and illustrate this.
I am looking to compare the value in column B on the original line with the value in column B on the duplicate line.