Results 1 to 11 of 11

How can anagrams be searched then highlighted in an Excel file?

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2019
    Location
    Cebu
    MS-Off Ver
    2007
    Posts
    36

    How can anagrams be searched then highlighted in an Excel file?

    I have this Excel file with numbers in them (see the photo). The file has “anagrams” of a certain number sequence - as in this photo: Untitled_zpsgpoc7yfo.jpg

    Say, I know that the number sequence “4 1 2 4 0 2” has "anagrams" of it in the said file.

    Is there a way to search for those anagrams and highlight them all? (As I manually depicted those in the attached photo…) Here it is again if you want to refer to it:

    Untitled_zpsgpoc7yfo.jpg

    Pardon that I’m not very much of a programmer. I know that there are related topics on “anagrams” in this forum but I can’t make much out of the code to modify for this concern.
    I hope that the programmers here can help for people with the same problem as I have…
    Last edited by angExcel-entflea; 01-18-2020 at 10:35 PM. Reason: How can anagrams be searched then highlighted in an Excel file?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Scoring anagrams of different lengths
    By Johnegee in forum Excel General
    Replies: 1
    Last Post: 02-20-2019, 02:41 PM
  2. VBA highlighted issue in excel file
    By juniorhaven in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2017, 04:21 PM
  3. [SOLVED] Any Faster Way to Copy/Paste this range? (I have searched and searched and searched)
    By liquidmettle in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-12-2015, 02:33 PM
  4. Need to search inside each highlighted PDF in the same folder as the Excel 2010 file
    By ExcelVBAguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2014, 01:52 PM
  5. [SOLVED] Finding a file in sub folders and taking you to the location of searched file
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-09-2013, 01:25 PM
  6. Finding anagrams in a word list
    By Hitch75 in forum Excel General
    Replies: 10
    Last Post: 08-06-2009, 02:29 PM
  7. Anagrams
    By cradino in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 09-06-2005, 03:05 AM

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