Announcement

Collapse
No announcement yet.

Need help to get count of the value

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

  • Need help to get count of the value



    Hi Sir,

    I have a data in column A:A which I need to result other sheet

    data is like...
    Product 1 Product 2
    101 102
    102 189
    101 101
    102 102
    107 101
    101 189
    101 101
    189 102

    and the result should get of that like below...
    Data Product1 Product2
    101 4 3
    102 2 3
    107 1
    189 1 2

    plz help regarding this query
    Last edited by Rmrekoj; 5 days ago.

  • #2
    thanks in advance...
    Last edited by Rmrekoj; 5 days ago.

    Comment


    • #3
      Hello,

      Attached is your Test file ...

      Hope this will help
      Attached Files
      If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

      Comment


      • #4
        I think you have forgot to convert the excel into xlsm

        Comment


        • #5
          Originally posted by Rmrekoj View Post
          I think you have forgot to convert the excel into xlsm
          Sorry ...

          I do not understand ... there are no macros at all ...

          The formulas in Sheet 2 are generating the results automatically ...
          If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

          Comment


          • #6
            thanks for the help , but sir I really need the same working to be on Macros. isn't it possible ,

            Comment


            • #7
              Hello again,

              Yes it can easily be done with a macro ...

              It is a shame you did not mention you needed a macro in your first message ...

              it is also a shame you did not attach a sample file ... which would make everything easier ...

              Edit :

              Just noticed you have created a New thread ... with the same question ... and still no sample file ...
              If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

              Comment


              • #8


                Link posted for Future Readers :

                https://www.ozgrid.com/forum/forum/h...25#post1212625
                If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

                Comment

                Working...
                X