Excel formulae to tabulate data from 1 table to another

[nicholasccy]

Hi there, does anyone know what formulae I can input on the right table to easily track these data from the left table and input them instantly on the right table based on the various names (especially if the list on the right side names are not in order on the right)

I have included the link here at the bottom as well as a screenshot. Sincerely appreciate every single piece of advice!!


Link: Excel Help.xlsx

 

[arthurbr]

Perhaps in Q6 pulled right and down

=COUNTIF(FILTER($D$16:$L$25,$C$16:$C$25=$P6),Q$5)

(MS says XL 2021 has the FILTER function, but I'm not quite sure)

 

[Peter_SSs]

MS says XL 2021 has the FILTER function, but I'm not quite sure

It does, but MS also says that the first argument of COUNTIF has to be a range.

@nicholasccy
Welcome to the MrExcel board!

You will generally get better/faster results if you can provide your sample data in a form that can easily be copied for testing as helpers generally are not that keen on manually typing sample data.
I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be. We cannot see where your data is in the image.

Anyway, see if you can adapt this.

23 08 18.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3		1	2	3	4					A2	C7	H8	P7	K3	X9
4	Adam	A2	C7	C7	P7				Adam	1	2	0	1	0	0
5	Bryan	K3	K3	K3	X9				Bryan	0	0	0	0	3	1
COUNTIF

Cell Formulas
Range	Formula
K4:P5	K4	=COUNTIF(INDEX($C$4:$F$5,MATCH($J4,$B$4:$B$5,0),0),K$3)