+ Reply to Thread
Results 1 to 2 of 2

I need to find Consecutive BIG or SMALL or combination of both in a row

  1. 02-21-2024, 10:51 AM #1
    Dinu007
    Dinu007 is offline
    Registered User
    Join Date
    02-21-2024
    Location
    India
    MS-Off Ver
    o365
    Posts
    1

    Post I need to find Consecutive BIG or SMALL or combination of both in a row

    965 SMALL
    966 BIG
    967 SMALL
    968 SMALL
    969 SMALL
    970 SMALL
    971 BIG
    972 BIG
    973 BIG
    974 SMALL
    975 BIG
    976 BIG
    977 BIG
    978 BIG
    979 BIG
    980 BIG
    981 SMALL
    982 BIG
    983 BIG
    984 SMALL
    985 SMALL
    986 BIG
    987 BIG
    988 SMALL
    989 SMALL
    990 SMALL
    991 SMALL
    992 SMALL
    993 SMALL
    994 BIG
    995 SMALL
    996 SMALL
    997 BIG
    998 BIG
    999 BIG
    0 SMALL
    1 BIG
    2 BIG
    3 BIG
    4 BIG
    5 SMALL
    6 BIG
    7 BIG
    8 BIG
    9 SMALL
    10 SMALL
    11 SMALL
    12 SMALL
    13 SMALL
    14 SMALL
    15 BIG
    16 BIG
    17 SMALL
    18 BIG
    19 BIG
    20 SMALL
    21 SMALL
    22 SMALL
    841 SMALL
    842 SMALL
    843 SMALL
    844 BIG
    845 BIG
    846 BIG
    847 SMALL
    848 SMALL
    849 SMALL
    850 SMALL
    851 SMALL
    852 BIG
    853 SMALL
    854 SMALL
    855 BIG
    856 BIG
    857 BIG
    858 SMALL
    859 BIG
    860 BIG

    How to find and highlight consecutive BIG or SMALL or a combination of both in a row.
    Reply With QuoteRegister To Reply
  2. 02-21-2024, 11:08 AM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: I need to find Consecutive BIG or SMALL or combination of both in a row

    Attached is what I got from your post and put into this workbook.
    please review it and fill in the results you are looking for and using the instructions in the yellow banner at the top re upload it so it shows what you want.
    questions for example, does "highlight" mean conditional formatting? When you say consecutive big or small OR A COMBINATION of both in a row (apparently you mean column) how should that be interpreted because you have both consecutive and broken apart (small followed by small then followed by big then small, how does that differ)?
    Attached Files Attached Files
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find sum combination
    By Geo Jul in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2023, 12:22 PM
  2. How to find best combination
    By fargeneral in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-13-2020, 02:43 AM
  3. How to find the most combination?
    By charmaine143 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2018, 05:12 AM
  4. [SOLVED] how to find small value except 0
    By rajjana in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2018, 07:35 AM
  5. [SOLVED] IF(AND(SMALL(LARGE Combination Help
    By chad328 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2016, 07:03 AM
  6. Find combination (consecutive) 6 Zeros (all direction)
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2015, 08:27 AM
  7. Adding combination of non consecutive cells
    By JERRY in forum Excel General
    Replies: 3
    Last Post: 02-27-2006, 02:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1