+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 22 of 22

one formula need to categorized all the items

  1. #16
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    9,878

    Re: one formula need to categorized all the items

    Regarding the latest upload.

    I am confused. This doesn't resemble what you originally asked, appears to be much more complex now and still hasn't answered my questions.

    Perhaps someone else will join in.
    Dave

  2. #17
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    280

    Re: one formula need to categorized all the items

    Hi,
    i extremely sorry to say you that thread duplication is not my fault. thousand of people are posting there problem in this forum and post title. it is not possible to compare the duplication of thread title. if you have any good suggestion of title posting before post in this forum, kindly tell me.

  3. #18
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    280

    Re: one formula need to categorized all the items

    Hi FlameRetired Boss,
    new one file is same as previous the problem is i dont need column D and E but your formula is not working when i delete these columns so i explain you in column G and H od result. G is main category and H Sub category is showing.

    Thanks.

  4. #19
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    24,763

    Re: one formula need to categorized all the items

    There is currently no sub-forum for PowerQuery. The request is fine staying here.

    I will have a look and see if I can suggest a PQ solution.

    EDIT: I have looked at the latest file and can't make head nor tail of what you are trying to achieve - sorry.
    Last edited by AliGW; 04-16-2019 at 03:03 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #20
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    280

    Re: one formula need to categorized all the items

    Hi AliGW,
    I also mention both category in my new file mention column G and H. please see again. leave it column C,D and E in sheet2 because its old.
    Thanks

  6. #21
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    280

    Re: one formula need to categorized all the items

    Hi,
    Any Help?

  7. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    24,763

    Re: one formula need to categorized all the items

    Not from me, sorry - I still donít get it.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1