Results 1 to 12 of 12

Thread: Excel sheet Data Formula Required

  1. #1
    rufiirfan is offline Junior Member
    Last Online
    18th April 2021 @ 05:42 PM
    Join Date
    21 Nov 2015
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    16
    Threads
    3
    Credits
    1,170
    Thanked
    0

    Default Excel sheet Data Formula Required

    Assalam-0-Alaikum Dooston , mere pass ek excel ki file hai jis mein sheet 1 mein mene kuch logo kay naam likhay hain or agay sab coloums mein dates likhi hain ,, ab sheet 2 mein mere pass kuch data hai jis mein wohi logo kay naam bhi hain or dates bhi hain ,, ab mujhe sheet 1 mein her date kay box kay nechay jo box hai us mein formula lagana hai kay is banday ka naam is date mein itni dafa aaya ,, wo formula 2 din se try ker raha hon mujh se lag nahi raha or na searching mein mujhe kuch samajh aa raha hai ,, plz koi expery meri help ker day , mujhe formula bata day kis tarah lage ga ,, screen shot sath de raha hon
    Attached Files Attached Files

  2. #2
    khan3795 is offline Member
    Last Online
    28th March 2019 @ 01:46 PM
    Join Date
    19 Mar 2012
    Location
    Layyah
    Age
    34
    Gender
    Male
    Posts
    997
    Threads
    146
    Thanked
    44

    Default

    smj ni i apko kia chahye

  3. #3
    M Anas's Avatar
    M Anas is offline Senior Member+
    Last Online
    23rd December 2018 @ 11:44 PM
    Join Date
    23 Mar 2015
    Location
    Pakistan
    Gender
    Male
    Posts
    466
    Threads
    31
    Credits
    1,165
    Thanked
    20

    Default

    Wait krain
    ٹوئٹرپر آپکا منتظر

  4. #4
    rufiirfan is offline Junior Member
    Last Online
    18th April 2021 @ 05:42 PM
    Join Date
    21 Nov 2015
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    16
    Threads
    3
    Credits
    1,170
    Thanked
    0

    Default

    bhai mujhe dates kay box mein formula lagana hai sheet 1 or wo formula sheet 2 se uthay ga ,, for example sheet 1 mein muhammad kamran likha hai ,, or agay us ki dates likhi hain 2 april , 3 april ,, ab sheet 2 kay data se yeh uthana hai kay muhammad kamran ka naam 2 april mein kitni dafa aaya , ager 2 dafa aaya hai tu sheet 1 kay dates mein 2 april kay nechay box mein 2 likha aa jaye or ager 5 dafa naam aaya hai tu 5 likha aa jaye ,, is tarah her banday kay naam kay agay date wise box banay hain ab mujhe un boxes mein formula lagana hai ,, plz yaar koi expert help ker day

  5. #5
    ramkhans's Avatar
    ramkhans is offline Senior Member+
    Last Online
    17th February 2023 @ 12:13 AM
    Join Date
    23 Oct 2009
    Location
    Hyderabad
    Gender
    Male
    Posts
    77
    Threads
    8
    Credits
    1,674
    Thanked
    3

    Default

    Quote rufiirfan said: View Post
    Assalam-0-Alaikum Dooston , mere pass ek excel ki file hai jis mein sheet 1 mein mene kuch logo kay naam likhay hain or agay sab coloums mein dates likhi hain ,, ab sheet 2 mein mere pass kuch data hai jis mein wohi logo kay naam bhi hain or dates bhi hain ,, ab mujhe sheet 1 mein her date kay box kay nechay jo box hai us mein formula lagana hai kay is banday ka naam is date mein itni dafa aaya ,, wo formula 2 din se try ker raha hon mujh se lag nahi raha or na searching mein mujhe kuch samajh aa raha hai ,, plz koi expery meri help ker day , mujhe formula bata day kis tarah lage ga ,, screen shot sath de raha hon
    sheet send karen plz jis mn formula chahiye ap ko

  6. #6
    rufiirfan is offline Junior Member
    Last Online
    18th April 2021 @ 05:42 PM
    Join Date
    21 Nov 2015
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    16
    Threads
    3
    Credits
    1,170
    Thanked
    0

    Default

    www dot scribd dot com/document/377001077/Ro-Mtd-Mis-April-2018

  7. #7
    Join Date
    21 Dec 2008
    Location
    Faisalabad
    Age
    41
    Gender
    Male
    Posts
    2,588
    Threads
    104
    Credits
    4,372
    Thanked
    173

    Default

    count wala formula lagao

  8. #8
    rufiirfan is offline Junior Member
    Last Online
    18th April 2021 @ 05:42 PM
    Join Date
    21 Nov 2015
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    16
    Threads
    3
    Credits
    1,170
    Thanked
    0

    Default

    aray bhai count wala formula ager mujh se lag raha hota tu mein yahan post na kerta ,, mujhe formula de do mene link bhi post kia hai is mein excel file attached hai ,, us mein formula laga do ya phir yahan mujhe formula de do kay kis tarah lagay ga ,, dost excel pe formula mujhe lagane aata hai or maximum files mein office kay data0 mein formula laga raha hota hon ,, is file mein formula nahi lag raha mujhe tabhi yahan aaya hon help mangne

  9. #9
    rufiirfan is offline Junior Member
    Last Online
    18th April 2021 @ 05:42 PM
    Join Date
    21 Nov 2015
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    16
    Threads
    3
    Credits
    1,170
    Thanked
    0

    Default

    excel sheet is link kay andar hai ,, www kay baad mene dot likha hai wahan aap dot ki jageh normal . lagaiye ga , link open hote he excel ki file samne hogi ......
    www dot scribd dot com/document/377001077/Ro-Mtd-Mis-April-2018

  10. #10
    ramkhans's Avatar
    ramkhans is offline Senior Member+
    Last Online
    17th February 2023 @ 12:13 AM
    Join Date
    23 Oct 2009
    Location
    Hyderabad
    Gender
    Male
    Posts
    77
    Threads
    8
    Credits
    1,674
    Thanked
    3

    Default

    Quote rufiirfan said: View Post
    Assalam-0-Alaikum Dooston , mere pass ek excel ki file hai jis mein sheet 1 mein mene kuch logo kay naam likhay hain or agay sab coloums mein dates likhi hain ,, ab sheet 2 mein mere pass kuch data hai jis mein wohi logo kay naam bhi hain or dates bhi hain ,, ab mujhe sheet 1 mein her date kay box kay nechay jo box hai us mein formula lagana hai kay is banday ka naam is date mein itni dafa aaya ,, wo formula 2 din se try ker raha hon mujh se lag nahi raha or na searching mein mujhe kuch samajh aa raha hai ,, plz koi expery meri help ker day , mujhe formula bata day kis tarah lage ga ,, screen shot sath de raha hon
    mere khayal main ap is tarah chah rhy hain link check karen
    https:// www scribd com/document/377383779/377001077-Ro-Mtd-Mis-April-2018

  11. #11
    rufiirfan is offline Junior Member
    Last Online
    18th April 2021 @ 05:42 PM
    Join Date
    21 Nov 2015
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    16
    Threads
    3
    Credits
    1,170
    Thanked
    0

    Default

    Thankyou

  12. #12
    rufiirfan is offline Junior Member
    Last Online
    18th April 2021 @ 05:42 PM
    Join Date
    21 Nov 2015
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    16
    Threads
    3
    Credits
    1,170
    Thanked
    0

    Default

    Thanx Bro but 95% sahi banai hai aap ne isi tarah chahiye thi mujhe lekin same foumula copy paste ker raha hon next date mein tu error aa raha hai ,, aap ne 2 april mein formula lagaya ,, ab jab wohi formula copy paste ker raha hon 3 april mein tu error aa raha hai data nahi utha raha

Similar Threads

  1. Formula in Excel Sheet
    By zahid4942 in forum Ask an Expert
    Replies: 4
    Last Post: 6th September 2014, 05:41 PM
  2. Excel aik Sheet se dosri sheet mein data up date kerna
    By riazanjum09 in forum General Discussion
    Replies: 2
    Last Post: 16th January 2014, 01:15 AM
  3. Excel sheet formula problem...
    By Sarfraz Hussain in forum Ask an Expert
    Replies: 3
    Last Post: 19th June 2012, 09:59 AM
  4. Solved Excel Sheet Formula
    By Shireen Shari in forum Solved Problems (IT)
    Replies: 44
    Last Post: 1st June 2012, 09:36 PM
  5. Aik Excel Sheet Say Data Dosri Sheet Main Daikhna !!!
    By sannan in forum General Discussion
    Replies: 13
    Last Post: 29th January 2010, 11:16 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
  •