Formula to get Unique list from a column based on a criteria in another column

[manift]

Good Day All,

may i have your assistant to get solution for the "Formula to get Unique list from a column based on a criteria in another column"

herewith i have attached an excel sample with formula (at column E), where i can get unique list without criteria.

but the formula am looking for is to get the unique list based on a criteria, which is cell E2 should result only if cell "A2=D2"

kindly help me to get an solution to fix this issue.

Note: am not having an "Unique / Filter Function" in my excel 2016 account.

[RChad]

Hello,

I thought maybe fill the dates based on the unique list instead.

Please Login or Register  to view this content.

CTRL+SHIFT+ENTER to make it an array

Please Login or Register  to view this content.

I hope this helps

[Sunny18pc]

Hi, Kindly check the attached file, see it helps or not!!

[manift]

Hi Sunny,

sorry am unable to find the attachment, could you please upload once again.

[manift]

Dear RChad,

herewith find the attached file, kindly help me out to get the expected output

[RChad]

Hello,

Maybe like this:

Please Login or Register  to view this content.

Press CTRL+SHIFT+ENTER to make it an array

Please Login or Register  to view this content.

[CARACALLA]

E3=IFERROR(INDEX($B$3:$B$26,SMALL(IF(FREQUENCY(IF($A$3:$A$26=$D3,MATCH($B$3:$B$26,$B$3:$B$26,0)),ROW($B$3:$B$26)-ROW($B$3)+1),ROW($B$3:$B$26)-ROW($B$3)+1),COUNTIF($D$3:$D3,$D3))),"")

control+shift+enter

copy down

[manift]

Hi RChad,

Thanks for the formula and sample workbook.

But the formula is not working for the new entries, could you please guide me on this to fix.

herewith find the updated excel sheet for the new entries.

[manift]

Dear Caracalla,

Thanks for the solution, yes fine it's working well.