COUNT IF Formula help

Copper Contributor

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,

2 Replies
You are comparing the value of Column B with the original values in the same Column B. How do you determine those original values?

@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.