Copy filtered data

Hi there,

How can filter this column so I see all the consecutive numbers without the "doubles" so I can just see 10,20,30,40,50,60,70.. the I can add information to it.

10
20
20
30
30
40
50
60
60
60
60
60
60
60
60
60
60
70
70
70
70
70
70
80
80
80
90
90
90
100
100
110
110
110
110
110
110
shuncaAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
You can add a helper formula in free column...

say the numbers start in A2, then you would add a formula in an empty row2 cell

=COUNTIF(A$2:A2,A2)=1

and copy down.

Then filter the table, by this column and filter for TRUE.
0
 
shuncaAuthor Commented:
Thank you. Now, how can I paste information for all the true values filtered. When I try to copy to all "True" values, it copies to all visible data (true) and hidden (False)
Is there a way I can avoid that?

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.