Hi All,

i'm looking to hide rows based on the following

in Column C i have numbers that have a gap in between rows for the next set , my request is how do i hide when in a set (like 1 to 5 in the first set) i want to hide 1234 and show the row showing 5 only ....next set is 12 so hide row with 1 and show the 2 etc ....the 1's on their own stay....any clues would be greatly appreciated


1
2
3
4
5

1
2

1

1
2
3