excel function by using match and count

Hi
try this macro

it will search the range InputRange, list unique values in a column begining at cell OutputCell and list the number of occurrences in the cell to the right of that. You will need to set the ranges according to your data

Sub UniqueList()
'returns all the unique words in range InputRange in a list in a column begining at OutputCell, with the number of occurrences to the right

Dim InputRange As Range, OutputCell As Range, cCell As Range, WordArr As Variant, n As Long, z As Long, wrdZ As Variant, x As Long, Addword As Boolean, WordNumz
Set InputRange = Range("A1:A14")
Set OutputCell = Range("D1") 'cell to beging list of unique words
WordArr = Array()
WordNumz = Array()
n = 0
For Each cCell In InputRange.Cells
        wrdZ = Split(cCell.Value, ",")
        
        For z = LBound(wrdZ) To UBound(wrdZ)
        Addword = True
            For x = LBound(WordArr) To UBound(WordArr)
                If Trim(LCase(wrdZ(z))) = Trim(LCase(WordArr(x))) Then
                    Addword = False
                    WordNumz(x) = 1 + WordNumz(x)
                End If
            Next x
            If Addword = True Then
                ReDim Preserve WordArr(n)
                ReDim Preserve WordNumz(n)
                WordArr(n) = Trim(wrdZ(z))
                WordNumz(n) = 1
                n = n + 1
            End If
        Next z
Next cCell
For x = LBound(WordArr) To UBound(WordArr)
    OutputCell.Offset(x, 0).Value = Trim(WordArr(x))
    OutputCell.Offset(x, 1).Value = WordNumz(x)
Next x

End Sub

Hello, thank you for helping me last time! I still have some difficulties with macros. Can U help me please one more time?

This is the current (example) situation

Date FA Task Barcode Jobcard Part Number Qty Part Description
24-01-2009 A06 T0003ABC book 123456 1 PAPER
24-01-2009 A06 T0003JKL seat 456789 2 ARMREST
25-01-2009 A05 T0003FJH seat 456789 30 ARMREST
25-01-2009 A05 T0003VBN plastic 321654 1 TRANSPARANT


Last time U created a macro that sorted all unique part numbers for me. Next to that column there was the ammount of the unique part number.

Now i need to do the following (if possible):
I want the following columns:

1. Unique part numbers (did last time)
2. Ammmount of unique partnumbers (did) last time
3. The Qty of each unique partnumber
4. The dates involved with each unique partnumber
4. The FA involved with each unique partnumber
5. the task barcode involved
6. Part description

so this need to be the result;

Part Number Ammount QTY Dates FA's Barcodes Part description
456789 2 32 24-01-2009, 25-01-2009 A05, A06 T0003JKL, T0003FJC ARMREST
123456 1 1 24-01-2009 A05 T0003ABC PAPER
321654 1 1 25-01-2009 A06 T0003VBN TRANSPARANT


Thanks a lot! if U have the time to help me, otherwise i need to post this in a new thread

Another way using formulas.
See the attached file with formulas in B,C,D columns.