Formula to get unique data

Hi,
I managed to do that only with a helper though I'm sure it is possible without (with frequency function or something like that).

So the helper in U5 and down would retrieve unique values, and leave blank cells for the duplicate lines (I couldnt find a way to overcome the blank cells):

=IF(OR(COUNTIF($U$4:U4,INDEX($Q$1:$Q$14,SMALL(IF(Q5=$Q$1:$Q$14,ROW($Q$1:$Q$14),ROW(Q5)),1),1))>0,U4=INDEX($Q$1:$Q$14,SMALL(IF(Q5=$Q$1:$Q$14,ROW($Q$1:$Q$14),ROW(Q5)),1),1)),"",INDEX($Q$1:$Q$14,SMALL(IF(Q5=$Q$1:$Q$14,ROW($Q$1:$Q$14),ROW(Q5)),1),1))

Then you can apply in Q15 and down the following formula that skips the blanks:

=IFERROR(INDEX($Q$1:$Q$14,SMALL(IF($U$5:$U$13<>"",ROW($U$5:$U$13)),ROWS($U$5:U5)),1),"")

Let me know if this what you need.
Thanks.

Hi Belinda,

Thank you for your help on this, your formula given above works like charm.. taking helper is challenging, i am not sure how can i manage in future expenses or files. I may request you to check below formula which i have gathered over internet bits and pieces.. this will work without helper i guess, but i am not sure how to validate it properly. This formula works to some extent only. If i wanted to apply this formula in same excel sheet, say from Q23:Q30 for "Expenses of Hotel" for various months, results in blank cells. See whether you can help on this!

Formula:

=IFERROR(INDEX(Q$5:Q$14,SMALL(IF(MATCH(Q$5:Q$14,Q$5:Q$14,)=ROW(Q$5:Q$14)-4,ROW(Q$5:Q$14)-4),ROW(A1))),"")