ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 843
- Office Version
- 365
- 2019
- Platform
- Windows
I am trying to find a way to easily know if any price changes from a very large dataset. Over 100k rows. Currently I am filtering by frequency, then using pivot tables and its cumbersome. I am looking if I can just have a column called "changes" so I only have to focus on any duplicates that have changes. There could be a lot of duplicates with the same price but I don't really care about those. The unique Identifier column A is what sets them apart. I did a snipbit below using XLBB to give a frame of reference what I am dealing with. In the future I will probably looking for a way to give me the changes but for right now babysteps and just looking for changes "Yes or No". Thank you as always for helping look at this.
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
5 | Not really needed if I have column J working | HELP | ||||||||||
6 | Identifier | Unique Identifier | Group | Group Class | Price | SKU | File | File Name | Frequency | Any Change? | ||
7 | AAA | 123456789 | Team1 | 1 | $ 10.00 | SKUAAA | NonF | XXXXXXX1 | 2 | |||
8 | BBB | 987654321 | Team1 | 2 | $ 10.50 | SKUBBB | NonF | XXXXXXX1 | 1 | |||
9 | CCC | 112233446 | Team2 | 1 | $ 75.00 | SKUCCC | NonF | XXXXXXX1 | 1 | |||
10 | DDD | 124512566 | Team2 | 2 | $ 69.80 | SKUDDD | NonF | XXXXXXX1 | 1 | |||
11 | EEE | 122456789 | Team2 | 3 | $ 100.25 | SKUEEE | NonF | XXXXXXX1 | 2 | |||
12 | FFF | 324512566 | Team3 | 4 | $ 100.00 | SKUFFF | NonF | XXXXXXX1 | 2 | |||
13 | GGG | 924512566 | Team3 | 5 | $ 74.00 | SKUGGG | NonF | XXXXXXX1 | 2 | |||
14 | HHH | 712233446 | Team4 | 98 | $ 9.00 | SKUHHH | NonF | XXXXXXX1 | 4 | |||
15 | III | 522456789 | Team5 | 98 | $ 5.60 | SKUIII | NonF | XXXXXXX1 | 3 | |||
16 | LLL | 624512566 | Team6 | 98 | $ 7.50 | SKULLL | NonF | XXXXXXX1 | 3 | |||
17 | AAA | 123456789 | Team1 | 1 | $ 9.00 | SKUAAA | NonF | XXXXXXX1 | 2 | |||
18 | EEE | 122456789 | Team2 | 3 | $ 5.00 | SKUEEE | NonF | XXXXXXX1 | 2 | |||
19 | FFF | 324512566 | Team3 | 4 | $ 7.00 | SKUFFF | NonF | XXXXXXX1 | 2 | |||
20 | GGG | 924512566 | Team3 | 5 | $ 74.00 | SKUGGG | NonF | XXXXXXX1 | 2 | |||
21 | HHH | 712233446 | Team4 | 98 | $ 9.00 | SKUHHH | NonF | XXXXXXX1 | 4 | |||
22 | III | 522456789 | Team5 | 98 | $ 5.60 | SKUIII | NonF | XXXXXXX1 | 3 | |||
23 | LLL | 624512566 | Team6 | 98 | $ 4.00 | SKULLL | NonF | XXXXXXX1 | 3 | |||
24 | HHH | 712233446 | Team4 | 98 | $ 9.00 | SKUHHH | NonF | XXXXXXX1 | 4 | |||
25 | III | 522456789 | Team5 | 98 | $ 5.60 | SKUIII | NonF | XXXXXXX1 | 3 | |||
26 | LLL | 624512566 | Team6 | 98 | $ 7.50 | SKULLL | NonF | XXXXXXX1 | 3 | |||
27 | HHH | 712233446 | Team4 | 98 | $ 10.00 | SKUHHH | NonF | XXXXXXX1 | 4 | |||
28 | III | 522456789 | Team5 | 98 | $ 5.60 | SKUIII | NonF | XXXXXXX1 | 3 | |||
29 | LLL | 624512566 | Team6 | 98 | $ 111.00 | SKULLL | NonF | XXXXXXX1 | 3 | |||
30 | LLL | 624512566 | Team6 | 98 | $ 123.00 | SKULLL | NonF | XXXXXXX1 | 3 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F7:F30 | F7 | ="SKU"&A7 |
I7:I30 | I7 | =COUNTIF($A$7:$A$27,A7) |