*How would I write the formula to automatically pull the name of the items from the box of information without getting blanks or duplicates?

JayDee 0 Reputation points
2024-04-28T17:30:54.58+00:00

Hello, I'm trying to create a list of Names and the Number of times they appear from a box of information similar to the picture.

Current data range is B2:AT21

Below the data range I was in putting the Formula

How would I write the formula to automatically pull the name of the items from the box of information without getting blanks or duplicates?** (that way it will auto populate a list)

I inputted in the column next to it "=Countif(B2:AT21;A24)" and reference the cell next to the left as the unique id to get the count.

Thanks in advance

Box of information:

User's image

Main List w/quantity

User's image

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,500 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. JayDee 0 Reputation points
    2024-04-28T18:10:07.7166667+00:00

    ooops wrong spot.

    0 comments
  2. Jiajing Hua-MFST 5,305 Reputation points Microsoft Vendor
    2024-04-29T06:32:10.6466667+00:00

    Hi @JayDee

    I suggest you try to use Tocol and Unique functions.

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.