Announcement

Collapse
No announcement yet.

Excel guru's

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel guru's

    I want to make a spreadsheet that fills one column with numbers from a barcode scanner then takes all of those scans and creates a second column with the unique scans then totals them next to the unique column. I already know how to get the totals and I know how to do advanced filtering but I want/need something automatic. It will be for inventory purposes and doesn't need to be pretty I just want something automatic.

  • #2
    You could enter every scan in one column, and make a pivot table based on what you're looking for, or use an if/sum function or even vlookup, but a better choice would be buying some form of inventory control software that lets you enter a UPC, then edit details and quantity about that UPC.
    ZOMBIE REAGAN FOR PRESIDENT 2016!!! heh

    Comment


    • #3
      You mean column ex. C1 would be =a1+b1 and that would be the sum of both scans?

      Comment


      • #4
        Originally posted by lincolnboy View Post
        You mean column ex. C1 would be =a1+b1 and that would be the sum of both scans?
        Just seeing you use the word "sum" makes me feel like we're being trolled 99% of the time and that you occasionally slip up and forget to be a retard.

        Comment


        • #5
          Originally posted by YALE View Post
          You could enter every scan in one column, and make a pivot table based on what you're looking for, or use an if/sum function or even vlookup, but a better choice would be buying some form of inventory control software that lets you enter a UPC, then edit details and quantity about that UPC.
          Every scan is currently going to column A then in column C I'm doing advanced filtering for uniques and column D is taking the total scans from A and putting the totals next to the unique. My main problem is finding how to automatically populate column C with all uniques from column A.

          Comment


          • #6
            Maybe setup a macro and choose a "hot" key to run it??

            Comment


            • #7
              First, let me explain the difference between unique values and unique distinct values, it is important you know the difference so you can find the informati
              Originally posted by Broncojohnny
              HOORAY ME and FUCK YOU!

              Comment


              • #8
                ive tried a few of them but because i want it to scan the entire column i kept getting errors. though there is a possibility i wasn't doing it right.

                Comment


                • #9
                  What errors?
                  Originally posted by Broncojohnny
                  HOORAY ME and FUCK YOU!

                  Comment


                  • #10
                    ill take a screen shot monday.

                    Comment

                    Working...
                    X