Webhosting in Pakistan
Results 1 to 7 of 7

Thread: Excel Experts

  1. #1
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    26th February 2020 @ 12:51 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,270
    Threads
    370
    Credits
    253
    Thanked
    153

    Thumbs up Excel Experts

    Webhosting in Pakistan
    Asslam-o-Alaykum
    Dear All,
    Main 1 excel ki file attach ker raha hon, us mei mujhe Item wise Qty ka total chahye, SKU wise qty ka total to ho jata ha, Pivot Table ya Sumif Function k through... Lakin item wise nehi ho raha because Same item per SKU ki tarteeb change ha. please help k item wise qty ka total ho jaye.. jese k Item ha Pintuck king charcoal. ab pintuck king charcoal jaha b likha ha us ka sum ajaye tarteeb chahye kuch b ho...
    Attached Files Attached Files

  2. #2
    Join Date
    09 Apr 2009
    Location
    کر&
    Gender
    Male
    Posts
    16,054
    Threads
    255
    Credits
    22,829
    Thanked
    1793

    Default

    وعلیکم السلام برادر چیک کرتے ہیں آپ کی فائل کو
    باقی ایکسپرٹس کا انتظار فرمائیں
    تحریر گزار بروز پیر والے دن آپ کی اس فائل کو چیک کرے گا

  3. #3
    amirkhan0's Avatar
    amirkhan0 is offline Advance Member
    Last Online
    22nd March 2020 @ 07:14 PM
    Join Date
    21 Dec 2011
    Location
    Kohat
    Gender
    Male
    Posts
    1,068
    Threads
    49
    Credits
    1,319
    Thanked
    84

    Default

    bhai ap filter use kr len na.. filter me pintuck type krin search me jitne pintuck text ke sari search a jaye ge qty me sum ka formula use kr k count kr len

  4. #4
    amirkhan0's Avatar
    amirkhan0 is offline Advance Member
    Last Online
    22nd March 2020 @ 07:14 PM
    Join Date
    21 Dec 2011
    Location
    Kohat
    Gender
    Male
    Posts
    1,068
    Threads
    49
    Credits
    1,319
    Thanked
    84

    Default

    dosra method find wala Ctrl+F press krin Pintuck type krin sari search a jaye ge ab usy highlight krne k replace ka option use krin. replace with k samny format per click krin or fill me koi color select krin or replace all kr len. jitne pe pintuck text hoge wo cells colored ho jaye ge ab us color ko filter kr k count kr len.

  5. #5
    amirkhan0's Avatar
    amirkhan0 is offline Advance Member
    Last Online
    22nd March 2020 @ 07:14 PM
    Join Date
    21 Dec 2011
    Location
    Kohat
    Gender
    Male
    Posts
    1,068
    Threads
    49
    Credits
    1,319
    Thanked
    84

    Default

    3rd methud phr column to text wala hai. or ap ke de gai file me SKU wala column jo hai us me "Dash" hua hai text k between me to is sari text line ko ap separate columns me change kr skte hain just select the whole column and go to Data > and then click on text to column>. select option Delimited and press Next and then Others me Dash (-) type krin aur phr Next > general select kr k finish kr den. sheet me ap ko hr text ka separate column mel jaye ga ab ap ko asan hoge koi b text filter kr len and then count.

  6. #6
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    26th February 2020 @ 12:51 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,270
    Threads
    370
    Credits
    253
    Thanked
    153

    Default

    Thanks but Text to Column se sequence same nei ati

  7. #7
    sikanderarshad90 is offline Member
    Last Online
    30th January 2020 @ 04:34 PM
    Join Date
    23 Jan 2020
    Age
    24
    Gender
    Male
    Posts
    55
    Threads
    0
    Credits
    264
    Thanked
    2

    Default

    Webhosting in Pakistan
    Agree with Ahmed

Similar Threads

  1. Help from Excel Experts.
    By Rahmatullah Ktk in forum Ask an Expert
    Replies: 9
    Last Post: 12th March 2016, 10:46 AM
  2. Only for excel experts....
    By Rizwan Anjum in forum Ask an Expert
    Replies: 3
    Last Post: 2nd February 2014, 04:32 PM
  3. only for excel experts
    By sweetmani123 in forum Ask an Expert
    Replies: 1
    Last Post: 10th March 2012, 10:35 AM
  4. Excel Experts Plz Help Me.....................
    By Stanha1989 in forum Ask an Expert
    Replies: 6
    Last Post: 12th January 2012, 09:53 PM
  5. To ms excel experts
    By usman_mohammad2 in forum Ask an Expert
    Replies: 10
    Last Post: 9th October 2009, 12:17 AM

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
  •