+ Reply to Thread
Results 1 to 5 of 5

Results with consecutive x in the list

  1. #1
    Spammer
    Join Date
    06-29-2020
    Location
    Vietnam
    MS-Off Ver
    2013
    Posts
    95

    Results with consecutive x in the list

    Results with consecutive x in the list
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: Results with consecutive x in the list

    What is your question?

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Results with consecutive x in the list

    Xin chào đến forum.

    Do you expect to get list of colour in column A with corresponding "X" in column B?

    Try in C2:

    Please Login or Register  to view this content.

    **Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
    Quang PT

  4. #4
    Forum Contributor
    Join Date
    03-18-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2016 / 2019
    Posts
    251

    Re: Results with consecutive x in the list

    Hi,

    C2 and copy down

    Please Login or Register  to view this content.
    Press CTRL-SHIFT-ENTER

    is this what you want ?
    Attached Files Attached Files
    Christopher Yap

  5. #5
    Spammer
    Join Date
    06-29-2020
    Location
    Vietnam
    MS-Off Ver
    2013
    Posts
    95

    Re: Results with consecutive x in the list

    thank you Bluesky63 and Bebo021999, your formula is good

+ 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: 12
    Last Post: 02-11-2018, 05:31 AM
  2. Calculate the number of consecutive results
    By Panifran in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-08-2016, 03:07 PM
  3. Highlghting 2 Consecutive Results By Group
    By Rob Murphy in forum Excel General
    Replies: 16
    Last Post: 11-09-2014, 04:51 PM
  4. IF command resetting after 3 consecutive negative results
    By chachie22 in forum Excel General
    Replies: 2
    Last Post: 02-28-2011, 12:32 PM
  5. Paste Issue when AutoFilter Results are Consecutive
    By daddio_gone in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-02-2009, 09:24 AM
  6. Excel macro to "fill in" consecutive numbers in non-consecutive list?
    By Tomkat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2009, 01:13 PM
  7. Returning Numeric Results across a Single Row in Consecutive Cells
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-15-2006, 08:55 PM

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