Page 1 of 2 12 LastLast
Results 1 to 12 of 14

Thread: Help about excel

  1. #1
    SERIOUS_BHAI is offline Member
    Last Online
    4th April 2014 @ 11:55 AM
    Join Date
    09 Mar 2014
    Gender
    Male
    Posts
    445
    Threads
    18
    Thanked
    24

    Default Help about excel

    ASSLAM O ALAIKUM

    mujay excel main kafi data banana hota hai same data main filter kr k count krta hoon jis main kafi time waste hota hai koi mujay aisa formula bata sakta hai k main us data ka name likhoon aur us formula say auto pe same data ki counting ho kr likhi ja'ay????

  2. #2
    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

    Quote SERIOUS_BHAI said: View Post
    ASSLAM O ALAIKUM

    mujay excel main kafi data banana hota hai same data main filter kr k count krta hoon jis main kafi time waste hota hai koi mujay aisa formula bata sakta hai k main us data ka name likhoon aur us formula say auto pe same data ki counting ho kr likhi ja'ay????

    use COUNTIF function of Excel, or share your workbook.
    Please next time post your question in Ask an Expert Section.

    regards

  3. #3
    Join Date
    06 Jan 2014
    Location
    Saudi , Makkah
    Age
    30
    Gender
    Male
    Posts
    3,178
    Threads
    304
    Credits
    2,092
    Thanked
    443

    Default

    Bhai jan ap usko advance filter say hi karain,
    baqi sahe wazahat say samajh nahe aya.
    Ask & expert par hi rujoo karain to behtar ha.

  4. #4
    SERIOUS_BHAI is offline Member
    Last Online
    4th April 2014 @ 11:55 AM
    Join Date
    09 Mar 2014
    Gender
    Male
    Posts
    445
    Threads
    18
    Credits
    0
    Thanked
    24

    Default

    ok brothers

  5. #5
    MUKHLAS is offline Member
    Last Online
    4th April 2014 @ 11:55 AM
    Join Date
    14 Mar 2014
    Gender
    Male
    Posts
    143
    Threads
    18
    Thanked
    18

    Default

    mujay app k sawal ka jawab mil geya hai main share bhi kr dayta hoon

    agr kisi coloum main ap daikhna chatay hain k aik khas lafaz kitni bar aya hai tu us ka forumala yeh hai

    MISAAL K TOOR PE APP DAKIHNA CHATAY HAIN K "P" KITNEY DAFA LIKHA GEYA HAI TU LIKHAIN

    =COUNTIF(I7:I28,"P")

    FORMULA WALAY DUBAY KO GERENAL MAIN FORMATE KRNA HAI
    Attached Images Attached Images  
    Last edited by MUKHLAS; 1st April 2014 at 06:10 PM.

  6. #6
    MUKHLAS is offline Member
    Last Online
    4th April 2014 @ 11:55 AM
    Join Date
    14 Mar 2014
    Gender
    Male
    Posts
    143
    Threads
    18
    Credits
    0
    Thanked
    18

    Default

    i7 row & coloum ko show kr raha hai isi tarah i28 bhi ...

  7. #7
    MUKHLAS is offline Member
    Last Online
    4th April 2014 @ 11:55 AM
    Join Date
    14 Mar 2014
    Gender
    Male
    Posts
    143
    Threads
    18
    Credits
    0
    Thanked
    18

    Default

    Kisi kism ka masal ho tu rabta kr saktay hain sample sheet main upload kr raha hoon daikh saktay hain download kr k

    note pehlay excel ki sheet theek say upload nahi hoi thi lihaza abb excel ki sheet update kr dee hai app excel ki sheet say daikh saktay hain
    Attached Files Attached Files
    Last edited by MUKHLAS; 1st April 2014 at 06:09 PM.

  8. #8
    DIGITAL_PAINDU is offline Senior Member+
    Last Online
    20th April 2015 @ 09:57 PM
    Join Date
    11 Mar 2009
    Age
    38
    Posts
    580
    Threads
    38
    Credits
    965
    Thanked
    34

    Default

    I think Pivot Table Report method is best for this job

  9. #9
    MUKHLAS is offline Member
    Last Online
    4th April 2014 @ 11:55 AM
    Join Date
    14 Mar 2014
    Gender
    Male
    Posts
    143
    Threads
    18
    Credits
    0
    Thanked
    18

    Default

    Quote DIGITAL_PAINDU said: View Post
    I think Pivot Table Report method is best for this job

    app ki baat ki samhaj nahi aaey

  10. #10
    SERIOUS_BHAI is offline Member
    Last Online
    4th April 2014 @ 11:55 AM
    Join Date
    09 Mar 2014
    Gender
    Male
    Posts
    445
    Threads
    18
    Credits
    0
    Thanked
    24

    Default

    Quote mukhlas said: View Post
    mujay app k sawal ka jawab mil geya hai main share bhi kr dayta hoon

    agr kisi coloum main ap daikhna chatay hain k aik khas lafaz kitni bar aya hai tu us ka forumala yeh hai

    misaal k toor pe app dakihna chatay hain k "p" kitney dafa likha geya hai tu likhain

    =countif(i7:i28,"p")

    formula walay dubay ko gerenal main formate krna hai
    Quote mukhlas said: View Post
    i7 row & coloum ko show kr raha hai isi tarah i28 bhi ...
    Quote mukhlas said: View Post
    kisi kism ka masal ho tu rabta kr saktay hain sample sheet main upload kr raha hoon daikh saktay hain download kr k

    note pehlay excel ki sheet theek say upload nahi hoi thi lihaza abb excel ki sheet update kr dee hai app excel ki sheet say daikh saktay hain
    Quote digital_paindu said: View Post
    i think pivot table report method is best for this job
    Quote mukhlas said: View Post

    app ki baat ki samhaj nahi aaey
    Quote faisal_zia said: View Post
    mujay mukhlas bhai k samjhanay ka tareeqa bohat acha laga

    mujay takreeban 5 saal honay walay hain main excel use kr raha hoon mujay excel main data banana bohat hi asaan lagta hai main sooch raha hoon k main yaha excel k formulas class start kr loon daily aik formula app ko parhaoon aur us ka use bataoon agr sab bhai is say mutafiq hain to main excel fourmula class start kr layta hoon

    jo app logoon k leyay bohat hi knowledgeable hoo gee

    mujay zaida english tu nahi atey bas roman urdu main hi samjha sakta hoon


    app sab bahioun k reply ka bohat shukereya mujay formula samhaj aa geya hai



  11. #11
    Join Date
    06 Jan 2014
    Location
    Saudi , Makkah
    Age
    30
    Gender
    Male
    Posts
    3,178
    Threads
    304
    Credits
    2,092
    Thanked
    443

    Default

    Quote mukhlas said: View Post
    mujay app k sawal ka jawab mil geya hai main share bhi kr dayta hoon

    agr kisi coloum main ap daikhna chatay hain k aik khas lafaz kitni bar aya hai tu us ka forumala yeh hai

    misaal k toor pe app dakihna chatay hain k "p" kitney dafa likha geya hai tu likhain

    =countif(i7:i28,"p")

    formula walay dubay ko gerenal main formate krna hai
    thanks bhai

  12. #12
    M HANIF's Avatar
    M HANIF is offline Senior Member+
    Last Online
    22nd February 2019 @ 02:21 PM
    Join Date
    09 May 2009
    Location
    Taunsa sharif
    Age
    33
    Posts
    419
    Threads
    8
    Credits
    78
    Thanked
    11

    Default

    Nice

Page 1 of 2 12 LastLast

Similar Threads

  1. Answered MS Word Ki file ko JPG me kesy convert kru?
    By 1heart2pain in forum Ask an Expert
    Replies: 10
    Last Post: 24th May 2010, 02:34 AM
  2. Excel 2003 for Starters: The Missing Manual
    By oralover2006 in forum English IT Zone
    Replies: 2
    Last Post: 28th May 2009, 11:01 AM
  3. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM
  5. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 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
  •