Skip to main content

Hello,

 

i have the following data set

 

Contractor Invoice #  Amount

A                    1           $100

A                    2           $101

A                    3            $150

A                    4            $200

B                    1           $200

B                    2              $201

 

how can I show for each contractor invoices or amounts where the  values that are within 1% of each other? in this case, invoice 1 and 2 for contractor A are 1% of each other and 1 and 2 for contractor B

 

Thank you!

Marina

7 réponses
  1. 24 juin 2019, 18:40

    You are right

    You are rightI didn't check it before posting. It should be 0.01.

    I didn't check it before posting. It should be 0.01.

    Thanks

    Deepak

0/9000