Array Formula count datas individual.

[asyamonique]

Good Day,
I have huge datas from the column A to K
Is it possible to have formulas for each columns given below to filter datas individual.
Many Thanks

COLUMN E	COLUMN F	COLUMN I
FirstName	LastName	TotalTime
Nicola	Red	50
Franco	Brown	100
Pietro	Yellow	50
Raffele	Black	100
Nicola	Red	100
Franco	Brown	50
Pietro	Yellow	40
Raffele	Black	50
Nicola	Red	70
Franco	Brown	255

<colgroup><col span="3"></colgroup><tbody>
</tbody>

 

[sergioMabres]

Hi Asya
You can create a formula in J2 =F2&", "&E2 copy it down to the end
And filter now by column J that now has Last Name, First name, that is to say one individual
I hope it works for you
Sergio

 

[asyamonique]

Thanks