smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In columns A, B and C (A2:C600) I have a lists of different towns (column A), customer names (column B) and buying price for each customer in column C.
In columns D and E I'm receiving new list (towns and customers).
I'm monitoring top 3 customers from each town (top 3 buying prices) and I would like to mark cells for those top 3 cutomer names (column B) IF those names do not appear on new list (columns D and E).
*note: same name could appear in two different towns
example.
<tbody>
</tbody>
explanation:
- top 3 customers from Town1 are Name4 (25), Name3 (12) and Name1 (9), in new list (columns D and E) customer from top 3 Name3 does not appear so highlight cell containing Name3 in column B (bold text)
- top 3 customers from Town2 are Name11 (28), Name9 (19) and Name6 (11), in new list (columns D and E) customers from top 3 Name11 and Name9 both does not appear so higlight both cells in column B (bold text)
In columns A, B and C (A2:C600) I have a lists of different towns (column A), customer names (column B) and buying price for each customer in column C.
In columns D and E I'm receiving new list (towns and customers).
I'm monitoring top 3 customers from each town (top 3 buying prices) and I would like to mark cells for those top 3 cutomer names (column B) IF those names do not appear on new list (columns D and E).
*note: same name could appear in two different towns
example.
A | B | C | D | E | F | |
1 | ||||||
2 | Town1 | Name1 | 9 | Town1 | Name1 | |
3 | Town1 | Name2 | 5 | Town1 | Name2 | |
4 | Town1 | Name3 | 12 | Town1 | Name4 | |
5 | Town1 | Name4 | 25 | Town1 | Name5 | |
6 | Town1 | Name5 | 0 | Town2 | Name15 | |
7 | Town2 | Name6 | 11 | Town2 | Name8 | |
8 | Town2 | Name7 | 4 | Town2 | Name6 | |
9 | Town2 | Name8 | 2 | Town3 | .... | |
10 | Town2 | Name9 | 19 | .... | ||
11 | Town2 | Name10 | 7 | |||
12 | Town2 | Name11 | 28 | |||
13 | Town3 | ... | ||||
14 | .... | .... |
<tbody>
</tbody>
explanation:
- top 3 customers from Town1 are Name4 (25), Name3 (12) and Name1 (9), in new list (columns D and E) customer from top 3 Name3 does not appear so highlight cell containing Name3 in column B (bold text)
- top 3 customers from Town2 are Name11 (28), Name9 (19) and Name6 (11), in new list (columns D and E) customers from top 3 Name11 and Name9 both does not appear so higlight both cells in column B (bold text)
Last edited: