Results 1 to 6 of 6

Thread: Excel Experts----Excel Formula experts

  1. #1
    a_shaheer's Avatar
    a_shaheer is offline Advance Member
    Last Online
    20th November 2021 @ 02:49 PM
    Join Date
    30 Nov 2010
    Location
    Karachi
    Gender
    Male
    Posts
    1,063
    Threads
    128
    Credits
    222
    Thanked
    47

    Default Excel Experts----Excel Formula experts

    Asslaam o Alaikum
    aik excel ki file attached kr raha hoon, isko dekh kr formula sy update krdain, file me hy meny requirement likh de hy, main Excel 2016 use krta hoon agr phir bhi kuch pochna hotu please zaroor pochlijiyega... Jazak Allah
    Attached Files Attached Files
    http://www.itdunya.com/signaturepics/sigpic171665_1.gif

  2. #2
    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 a_shaheer said: View Post
    Asslaam o Alaikum
    aik excel ki file attached kr raha hoon, isko dekh kr formula sy update krdain, file me hy meny requirement likh de hy, main Excel 2016 use krta hoon agr phir bhi kuch pochna hotu please zaroor pochlijiyega... Jazak Allah
    Please check
    Attached Files Attached Files
    Desert Rose
    A Simple Person With Complicated Mind

  3. #3
    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 a_shaheer said: View Post
    Asslaam o Alaikum
    aik excel ki file attached kr raha hoon, isko dekh kr formula sy update krdain, file me hy meny requirement likh de hy, main Excel 2016 use krta hoon agr phir bhi kuch pochna hotu please zaroor pochlijiyega... Jazak Allah
    as per your sheet Try at F4 and drag down

    Code:
    =COUNTIF($B$4:$B$33,"*"&E4&"*")

    Change ranges/references accordingly

  4. #4
    a_shaheer's Avatar
    a_shaheer is offline Advance Member
    Last Online
    20th November 2021 @ 02:49 PM
    Join Date
    30 Nov 2010
    Location
    Karachi
    Gender
    Male
    Posts
    1,063
    Threads
    128
    Credits
    222
    Thanked
    47

    Default

    King Khan bhai apka Bohat Bohat Shukria, bus aik issue rehgaya hy wo conditional formating ka hy, apky formula ko conditional formating me apply kia to hightlight duplicate names, but it does not work properly, file attached ki hy, please please resolved this issue.... Jazaak Allah
    Attached Files Attached Files

  5. #5
    a_shaheer's Avatar
    a_shaheer is offline Advance Member
    Last Online
    20th November 2021 @ 02:49 PM
    Join Date
    30 Nov 2010
    Location
    Karachi
    Gender
    Male
    Posts
    1,063
    Threads
    128
    Credits
    222
    Thanked
    47

    Default

    Quote syar said: View Post
    as per your sheet Try at F4 and drag down

    Code:
    =COUNTIF($B$4:$B$33,"*"&E4&"*")

    Change ranges/references accordingly
    Syar bhai apka formula bohat effective or simply hy
    bus aik issue rehgaya hy wo conditional formating ka hy, apky formula ko conditional formating me apply kia to hightlight duplicate names, but it does not work properly, file attached ki hy, please please resolved this issue.... Jazaak Allah
    Attached Files Attached Files

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

    Please try:
    Remove all conditional rules from range and
    select your range, conditional formatting-->Manager Rules---> New rules and copy this formula, as per your sample sheet formula will work otherwise change ranges and references


    Code:
    =COUNTIF($B$2:$B$31,"*"&B2&"*")>1

Similar Threads

  1. Replies: 5
    Last Post: 9th July 2020, 04:52 PM
  2. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  3. Help from Excel Experts.
    By Rahmatullah Ktk in forum Ask an Expert
    Replies: 9
    Last Post: 12th March 2016, 11:46 AM
  4. Solved EXCEL Experts Please help
    By engr.fahad in forum Solved Problems (IT)
    Replies: 16
    Last Post: 24th June 2012, 01:15 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
  •