Hello All;
How are you guys doing? I posted a question yesterday regarding COUNTIF function, but I dont think I addressed my examples comprehensibly.
I have the following where "CHECK" columns are the answers that I am trying to get to. Basically I have dynamic ranges and from these ranges I want to see if there are same "rates" associated within these ranges.
the logic behind the first "Yes" is...
IF names are "apples", how many rate are duplicate? replcad anything other than 1 as "Yes"
Could someone please help me on this? I need this to complete my macr.
Thank you all.
How are you guys doing? I posted a question yesterday regarding COUNTIF function, but I dont think I addressed my examples comprehensibly.
I have the following where "CHECK" columns are the answers that I am trying to get to. Basically I have dynamic ranges and from these ranges I want to see if there are same "rates" associated within these ranges.
the logic behind the first "Yes" is...
IF names are "apples", how many rate are duplicate? replcad anything other than 1 as "Yes"
Could someone please help me on this? I need this to complete my macr.
Thank you all.
| Book1 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Seller | name | rate | CHECK | ||
| 2 | Tom | Apple | $1.50 | Yes | ||
| 3 | John | Apple | $1.50 | Yes | ||
| 4 | James | Apple | $1.65 | |||
| 5 | Jane | Apple | $1.85 | |||
| 6 | Tom | Beef | $2.00 | |||
| 7 | John | Beef | $4.00 | |||
| 8 | James | Beef | $5.00 | Yes | ||
| 9 | Jane | Beef | $5.00 | Yes | ||
| 10 | Juan | Beef | $7.00 | |||
| 11 | Tom | Pear | $2.00 | |||
| 12 | John | Pear | $4.00 | |||
| 13 | James | Pear | $5.00 | |||
| 14 | Tom | chicken | $3.00 | Yes | ||
| 15 | John | chicken | $3.00 | Yes | ||
Sheet2 | ||||||
