Results 1 to 16 of 16

arrangement of different Cells, which need to be filtered out first

Threaded View

  1. #1
    Registered User
    Join Date
    04-12-2021
    Location
    Vienna
    MS-Off Ver
    2016
    Posts
    10

    arrangement of different Cells, which need to be filtered out first

    Hello Forum, i am very new and i would like to get a Problem solved with your help... so lets go for it: (please note, english is not my native language,)

    in every Cell in one given Line i either have the cell filled with the number 1 or the number 2. Example below

    A B C D E F G H I J K L M N..... till 100 (CV)
    4. 1 2 1 2 2 1 2 1 2 1 1 2 1 1..... till 100 (CV)
    5. 2 1 2 1 2 2 2 1 1 1 2 2 1 2..... till 100 (CV)

    now, i would like to give a command to filter line 4, from left to right, and find a pattern, that appears first! (in the filled Cells (1 or 2))

    for example.: Excel, should now look in 4th line from "A" to "C V" and mark the pattern that appears first. For example mark it red. if the 2nd pattern appears first, mark the second pattern for example yellow. ( i will upload an xls. doc with a small example so to make things more clear.)

    so i need a function that tells Excel... to look in line 4 --> From file "A" till file "C V" which pattern appears first, and mark it either red or yellow.

    Patterns:
    First Pattern Formation to search in line : 1 2 1 2
    Seco. Pattern Formation to search in line: 2 2 2 2

    the pattern that appears first should be marked, so that it is clear which appeared first.

    HOPE you can help me


    Kind regards branko

    note: basically its not important how to mark it, it just should recognize which "searched" pattern appears first, in the looked line (from left to right), and give a sign which one it was, doesnt matter if it marks red or yellow, its important to find it.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 09-27-2019, 04:32 PM
  2. Google Sheets - How to create graph from cells referencing other cells sorted/filtered dif
    By ergalthema in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-05-2018, 02:35 PM
  3. Replies: 0
    Last Post: 03-05-2018, 02:35 PM
  4. [SOLVED] Filtered Cells To Automatically Move Visible Cells To Top Of Table..?
    By Ourkid123uk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2017, 05:55 AM
  5. Replies: 3
    Last Post: 02-02-2017, 03:04 AM
  6. [SOLVED] Count cells containing Dates (greater than 2014) based on Filtered Cells
    By sam99 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-26-2014, 10:30 AM
  7. Replies: 7
    Last Post: 08-16-2010, 05:40 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