+ Reply to Thread
Results 1 to 6 of 6

How to find and select multiple values at once instead of one by one??

  1. #1
    Registered User
    Join Date
    09-17-2023
    Location
    morocco
    MS-Off Ver
    2016
    Posts
    3

    How to find and select multiple values at once instead of one by one??

    Hi. I have a spreadsheet with a massive amount of data. I've been given a list of values (i.e. U54x, PP32, h9A...) and search for the cells that contain them to change their style and format.
    I can either look for each value individually and select its cell to replace its style or I can use some formula or some other mean to look for all the values at once and replace their style (same style for all cells)
    I hope my question is clear. Thanks!

    Here's an image to help you understand:
    EXCEL.png

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,792

    Re: How to find and select multiple values at once instead of one by one??

    This can only be done with VBA - shall I move the thread for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,429

    Re: How to find and select multiple values at once instead of one by one??

    Attach Excel file

  4. #4
    Registered User
    Join Date
    09-17-2023
    Location
    morocco
    MS-Off Ver
    2016
    Posts
    3

    Re: How to find and select multiple values at once instead of one by one??

    Yes please.

  5. #5
    Registered User
    Join Date
    09-17-2023
    Location
    morocco
    MS-Off Ver
    2016
    Posts
    3

    Re: How to find and select multiple values at once instead of one by one??

    I'm sorry I can't share the file as it's contains some private data. Thanks thou

  6. #6
    Registered User
    Join Date
    11-16-2016
    Location
    NC
    MS-Off Ver
    2007, 2019
    Posts
    86

    Re: How to find and select multiple values at once instead of one by one??

    Use makeup data ... just a sampling ... say twenty or thirty samples.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-15-2021, 08:43 AM
  2. [SOLVED] Find duplicate values with select tow dropdown list
    By Yaghoub61 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2021, 11:46 AM
  3. Select Multiple Values in a Slicer using VBA
    By Ambris in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2019, 10:27 AM
  4. Find&Select&multiple
    By zsseymaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2016, 09:55 AM
  5. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  6. Replies: 5
    Last Post: 04-20-2014, 08:39 PM
  7. find, select, copy paste values
    By gsrai31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2011, 01:59 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1