Results 1 to 10 of 10

Thread: Number of Order Count

  1. #1
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Arrow Number of Order Count

    Dear Experts
    Asslam-o-Alykum
    Main ne 1 excel ki file upload ki hai jis mei order number likhay hain jis mei se kuch order number duplicate hain or kuch to 3 time repeat huwey hain. mujhe total orders ko count kerna ha but jo duplicate hain wo 1 order count ho... pls koi formula ha to bata dain...
    Attached Files Attached Files

  2. #2
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Default

    Help pls.

  3. #3
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    23rd August 2023 @ 03:59 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,814
    Threads
    73
    Credits
    11,419
    Thanked
    79

    Default

    Quote Rizwan Anjum said: View Post
    Help pls.
    Rizwan bahi, maine apne tariqe se aik sheet banaye hai, umeed hai ke os se apka issue resolve ho gaya hoga
    Order 1 apko samjhne ke lye banye hai or osma data kam rakha hai
    Further jo serial no hai wo apne likhna hai or excel mai duplicate formule se nikala hai, aur actual order No apko answer mai mil jayga
    Attached Files Attached Files
    Desert Rose
    A Simple Person With Complicated Mind

  4. #4
    malateef is offline Senior Member+
    Last Online
    15th September 2023 @ 10:26 AM
    Join Date
    10 Dec 2019
    Location
    Jeddah, KSA
    Gender
    Male
    Posts
    453
    Threads
    33
    Credits
    2,004
    Thanked
    33

    Default

    کنگ خان نے اچھا آئیڈیا دیا ہے۔لیکن اس میں ایک غلطی ہے۔ اس میں ڈپلیکیٹ صرف 2 ہیں، 3 نہیں۔
    Attached Files Attached Files

  5. #5
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    Find and remove duplicates
    Select the cells you want to check for duplicates. ...
    Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
    In the box next to values with, pick the formatting you want to apply to the duplicate values, and then click OK.

  6. #6
    malateef is offline Senior Member+
    Last Online
    15th September 2023 @ 10:26 AM
    Join Date
    10 Dec 2019
    Location
    Jeddah, KSA
    Gender
    Male
    Posts
    453
    Threads
    33
    Credits
    2,004
    Thanked
    33

    Default

    ڈیئر حسیب صاحب۔ اس کے ساتھ شرط یہی ہے کہ ڈپلیکیٹ نکالنے نہیں ہیں بلکہ ان کے ساتھ ہی کیلکولیشن کرنی ہے۔

  7. #7
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    try : Please change range(s) accordingly

    Code:
    =SUMPRODUCT(1/COUNTIF(A3:A6328,A3:A6328))
    or
    Code:
    = SUM(IF(1/COUNTIF(A3:A14,A3:A14)=1,1,0))
    enter with CTRL+SHIFT+ENTER

  8. #8
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    Quote malateef said: View Post
    ڈیئر حسیب صاحب۔ اس کے ساتھ شرط یہی ہے کہ ڈپلیکیٹ نکالنے نہیں ہیں بلکہ ان کے ساتھ ہی کیلکولیشن کرنی ہے۔
    چلیں نیچے برادر سے بہتر رہنمائی کر دی ہے
    ہم تو ایک سے زیادہ رقم کو الگ کر کے دوسری شیٹ پر باقی ڈیٹا کو پیسٹ کر لیتے اور کام چلا لیتے

  9. #9
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    23rd August 2023 @ 03:59 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,814
    Threads
    73
    Credits
    11,419
    Thanked
    79

    Default

    Quote malateef said: View Post
    کنگ خان نے اچھا آئیڈیا دیا ہے۔لیکن اس میں ایک غلطی ہے۔ اس میں ڈپلیکیٹ صرف 2 ہیں، 3 نہیں۔
    mere sheet mai koi ghalti nhi hai.... sirf formula cell mai paste karna bhol gaya tha.... You can check now
    Attached Files Attached Files

  10. #10
    malateef is offline Senior Member+
    Last Online
    15th September 2023 @ 10:26 AM
    Join Date
    10 Dec 2019
    Location
    Jeddah, KSA
    Gender
    Male
    Posts
    453
    Threads
    33
    Credits
    2,004
    Thanked
    33

    Default

    Good work.. ماشاءاللہ

Similar Threads

  1. How to count in excel
    By shehzad_ktk79 in forum Ask an Expert
    Replies: 24
    Last Post: 21st May 2013, 09:14 AM
  2. Solved post count kam ho gyi hai.
    By suraj goyal in forum Tajaweez aur Shikayat
    Replies: 4
    Last Post: 27th December 2010, 11:03 PM
  3. Microsoft Free Cds Order Karo No Charge Will Be In Order
    By Member1 in forum General Discussion
    Replies: 16
    Last Post: 10th April 2007, 10:10 PM

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
  •