Return the unique data with one blank field between data?

[jeffery216]

Hi All,

I am new here! I am wondering if there is any way to make unique to return data like below column C? Thanks all!

 

[JEC]

Try this (close with control+shift+enter, it's a matrix). And pull down

=IF(MOD(ROW(),2)=0,INDEX($A$2:$A$10,MATCH(0,COUNTIF($C$1:C1,$A$2:$A$10),0)),"")

 

[jeffery216]

Try this (close with control+shift+enter, it's a matrix). And pull down

=IF(MOD(ROW(),2)=0,INDEX($A$2:$A$10,MATCH(0,COUNTIF($C$1:C1,$A$2:$A$10),0)),"")

Hi JEC,

Thank you for your help! It's work well! However, I am trying to understand the formula, and modify it to have 4 blank row between each data, but it resulted like column D, the data can not start from D2 : (

=iferror(ArrayFormula(IF(MOD(ROW(),2)=0,INDEX($A$2:$A$20,MATCH(0,COUNTIF($C$1:C1,$A$2:$A$20),0)),"")),"")

 

[JEC]

Try:

MOD(ROW()-2,5)=0

 

[jeffery216]

Try:

MOD(ROW()-2,5)=0

Hi JEC,

Thank you!!! It works brilliantly! One more question, is it possible to control the order by ascending or descending?

BS,
Jeffery Ng

 

[Fluff]

If you need a formula to work on anything other than Excel, then you should clearly state that & post in the General Discussion & Other Applications section of the board.
Whilst Excel & Sheets have a lot in common, they are not the same.

 

[JEC]

About sorting, I prefer VBA. But you use google sheets?

 

[jeffery216]

About sorting, I prefer VBA. But you use google sheets?

Yes, I am using google sheet, and I have totally no idea about VBA : ((