Results 1 to 8 of 8

Thread: excel problem

  1. #1
    iamaraza is offline Senior Member+
    Last Online
    14th April 2024 @ 05:50 PM
    Join Date
    03 Feb 2013
    Location
    Karachi
    Gender
    Male
    Posts
    177
    Threads
    20
    Credits
    2
    Thanked
    6

    Default excel problem

    salam
    mere data range hai e10 to e394
    meri range sirf text hai 2 words se le kar 5 words tak
    mujhe karna yeh hai mujhe aisa filter ya search karna hai jis se ke meri range me se sirf 3 words wale cells show hon
    kisi bhai ko is hawale maloom ho to bataein

    thank in advence

  2. #2
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,362
    Threads
    419
    Credits
    39,820
    Thanked
    1813

    Default

    Quote iamaraza said: View Post
    salam
    mere data range hai e10 to e394
    meri range sirf text hai 2 words se le kar 5 words tak
    mujhe karna yeh hai mujhe aisa filter ya search karna hai jis se ke meri range me se sirf 3 words wale cells show hon
    kisi bhai ko is hawale maloom ho to bataein

    thank in advence
    وعلیکم السلام
    اگر فائل منسلک کر دیتے تو اچھا ہوتا
    خیر
    آپ کے ڈیٹا کی رینج کچھ بھی ہو آپ ایسا کرو کہ ایک ہیلپر کالم بناو
    اور اُس میں اس طرح لکھو
    =len(cell No) like =len(e10)
    اور انٹرکر دیں گے تو اس کالم میں آپ کے پاس ای ٹین کی ویلو آجائے گی
    اب آپ نے فلڑ کی کمانڈ لگا کر جس بھی لمبائی کا ڈیٹا آپ کو درکار ہے منتخب کر لیں 100 فیصد جواب درست آئے گا

  3. #3
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,362
    Threads
    419
    Credits
    39,820
    Thanked
    1813

    Default

    Name:  3chr.jpg
Views: 15
Size:  47.0 KB

  4. #4
    iamaraza is offline Senior Member+
    Last Online
    14th April 2024 @ 05:50 PM
    Join Date
    03 Feb 2013
    Location
    Karachi
    Gender
    Male
    Posts
    177
    Threads
    20
    Credits
    2
    Thanked
    6

    Default

    aap image mein dekhe sakte hein range mein kahi 4 words ka sentence hai kahi 5 ka aur kahi 3 words ka
    mujhe sort out karne 3 words wale sentence ab shayad aapko samajh aaya hoga ke mein kia kehna chah raha hun
    Attached Images Attached Images  

  5. #5
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,362
    Threads
    419
    Credits
    39,820
    Thanked
    1813

    Default

    Quote iamaraza said: View Post
    aap image mein dekhe sakte hein range mein kahi 4 words ka sentence hai kahi 5 ka aur kahi 3 words ka
    mujhe sort out karne 3 words wale sentence ab shayad aapko samajh aaya hoga ke mein kia kehna chah raha hun
    please copy this formula
    =TEXTJOIN(" ", TRUE, IF(LEN(TRIM(MID(SUBSTITUTE(A1, " ", REPT(" ", LEN(A1))), (ROW(INDIRECT("1:" & LEN(A1)))) * LEN(A1) - (LEN(A1) - 1), LEN(A1))))=3, TRIM(MID(SUBSTITUTE(A1, " ", REPT(" ", LEN(A1))), (ROW(INDIRECT("1:" & LEN(A1)))) * LEN(A1) - (LEN(A1) - 1), LEN(A1))), ""))
    and past it in desire column
    میں نے فرض کیا ہے کہ آپ کا ڈیٹا کالم اے ون میں لکھا ہوا ہے

  6. #6
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,362
    Threads
    419
    Credits
    39,820
    Thanked
    1813

    Default

    Name:  itd.jpg
Views: 15
Size:  21.9 KB

  7. #7
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,362
    Threads
    419
    Credits
    39,820
    Thanked
    1813

    Default

    کہاں رہ گئے؟

  8. #8
    iamaraza is offline Senior Member+
    Last Online
    14th April 2024 @ 05:50 PM
    Join Date
    03 Feb 2013
    Location
    Karachi
    Gender
    Male
    Posts
    177
    Threads
    20
    Credits
    2
    Thanked
    6

    Default

    ho gaya hal masla
    thanks

Similar Threads

  1. excel problem
    By shayan111132 in forum Ask an Expert
    Replies: 22
    Last Post: 23rd February 2016, 04:07 PM
  2. Excel PDF Problem
    By rafiquey in forum Ask an Expert
    Replies: 7
    Last Post: 1st September 2015, 08:49 PM
  3. Excel Problem
    By imran khan85 in forum Ask an Expert
    Replies: 1
    Last Post: 29th August 2014, 01:58 AM
  4. Excel Problem
    By Qutab in forum Ask an Expert
    Replies: 17
    Last Post: 18th July 2012, 09:01 PM
  5. Solved ~*Excel Problem*~
    By usman ali in forum Solved Problems (IT)
    Replies: 14
    Last Post: 10th July 2011, 11:10 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
  •