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; December 6th, 2018, 23:19.

  • #2
    thanks in advance...
    Last edited by Rmrekoj; December 6th, 2018, 23:20.

    Comment


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

      Comment


      • #4


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

        Comment

        Working...
        X