Formula to remove immediate duplicates

[kev_]

Thanks for reading...

Duplicates are allowed within the column but they cannot follow each other.
Hopefuly the image below makes it clear
Duplicate values are correctly eliminated with this formula in B2 copied down
=IF(A2<>A1,A2,"")

But I do not want any empty cells in the results column and do not want to use a helper column.
I would like a formula that takes the numbers in column A and returns column C
thanks

Remove IMMEDIATE duplicate.jpg

[XLent]

using your sample file, and assuming below is to replace your current formula in Column B, you can use:

Please Login or Register  to view this content.

[KOKOSEK]

Put into B1:

Please Login or Register  to view this content.

accept with Ctrl+Shift+Enter
and drag it down

[kvsrinivasamurthy]

In D2 then copy down

=IFERROR(INDEX($A$2:$A$21,AGGREGATE(15,6,ROW($A$2:$A$21)/($A$2:$A$21<> $A$3:$A$22),ROWS($D$2:$D2))-ROW($D$2)+1),"")

[kev_]

3 perfect answers
- thanks to all