[Solved] How to extract all unique values from a column based on multiple criterion in Excel
You would not be able to do this only with excel formulas and you would need a VBA solution. If your Sheet1 contains data like below, and Sheet2, Try this simple VBA code , Sub uniqueList() Dim i As Long, j As Long, str As String For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row For j … Read more