Hi,
I have data in column G which contains a lot of blanks and was trying to copy the non-blank unique values data in column I. I did an advanced filter but one blank entry is copied over too. Is there a way around this?
Thanks!
I have data in column G which contains a lot of blanks and was trying to copy the non-blank unique values data in column I. I did an advanced filter but one blank entry is copied over too. Is there a way around this?
Thanks!