jondavis1987
Active Member
- Joined
- Dec 31, 2015
- Messages
- 443
- Office Version
- 2019
- Platform
- Windows
I have a table that is thousands of rows long. There's seven repeating values in a column with the header Sieve. These values repeat in the same order after each other. Through a pivot table linked to this table i know there are two instances where insted of going No. 40 to No. 200 it goes from No. 40 to 1 1/2". Is there a quick way to find this without going through the thousands and thousands of rows looking for this?
Sieve |
1 1/2" |
3/4" |
3/8" |
No. 4 |
No. 10 |
No. 40 |
No. 200 |