thread Sorting and Formatting date and Countif

[MHD]

Hello everyone

Please help solve this problem!

I have this data as an example, how can I get results using VBA or matrix functions, to save time and effort in manually analyzing it.

Knowing that the data is larger than that, this is just an example.

test.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Table of data							table of results
2									sort oldest to newest then put the uniqe dates for each student as this format	sort ِ A to Z with levels: states, city, school, student then sort the date oldest to newest and format it
3		#	Date	states	City	school	student		Dates	States	City	school	student	# of visites
4		1	21/02/2021	Virginia	Alexandria	Thomas Jefferson	Liam		07.02.2021	Arizona	Gilbert	Gilbert Classical	William	1
5		2	11/02/2021	Texas	Houston	Carnegie Vanguard	Noah		08.02.2021	Arizona	Tucson	Liberal Arts and Science	Lucas	1
6		3	10/02/2021	Texas	Houston	Carnegie Vanguard	Noah		09.02.2021	Florida	Riviera Beach	Carnegie Vanguard	James	1
7		4	07/02/2021	Arizona	Gilbert	Gilbert Classical	William		(10,11).02.2021	Texas	Houston	Carnegie Vanguard	Noah	2
8		5	09/02/2021	Florida	Riviera Beach	Carnegie Vanguard	James		(02,19).02.2021	Virginia	Alexandria	Thomas Jefferson	Liam	3
9		6	02/02/2021	Virginia	Alexandria	Thomas Jefferson	Liam
10		7	08/02/2021	Virginia	Alexandria	Thomas Jefferson	Lucas
11		8	02/02/2021	Virginia	Alexandria	Thomas Jefferson	Liam
12
Sheet3

Cell Formulas
Range	Formula
N4:N8	N4	=COUNTIF(Table1[student],[@student])