Forum Discussion

Nicholasccy's avatar
Nicholasccy
Copper Contributor
Aug 17, 2023
Solved

Need a formulae to tabulate data from left table to be populated onto right table seamlessly

Hi all, hope you guys are well. Have an important question here!   As you can see in the picture attached, I want to create a formula that could tabulate the number of times a particular label (A2 ...
excel
  • OliverScheurich's avatar
    OliverScheurich
    Aug 18, 2023

    Nicholasccy 

    SUMPRODUCT returns the expected results in your file on my computer.

Nicholasccy's avatar
Nicholasccy
Copper Contributor
Aug 18, 2023

 

Hi there, I truly appreciate your help but unfortunately it does not work... 

I have attached the file here, truly appreciate your help! OliverScheurich 

 

Would actually need the name list on the right side to be longer/more extensive and not the same as the one on the left. Could you assist me in this? Truly appreciate it!!

Here is the link to the draft

https://1drv.ms/x/s!AuMmWVVhP42_hJF-QNRMlx8pFNJ8Yw?e=Wc9OqS&nav=MTVfe0VFODRCNEUzLTczMjctNDA5MC1BQkY4LTYyMDgxOTRCODQxM30

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Aug 18, 2023

Nicholasccy 

SUMPRODUCT returns the expected results in your file on my computer.

  • Nicholasccy's avatar
    Nicholasccy
    Copper Contributor
    Aug 18, 2023
    Thank you so much!!!

Resources