+ Reply to Thread
Results 1 to 3 of 3

How to remove unnecessary cells?

Hybrid View

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    12

    How to remove unnecessary cells?

    Hello,

    I'm wondering if someone can help me with this problem.
    Attached document is here: ones.xlsx

    There is a table with 4 rows.
    First row are numbers from 1 to 20.
    Second row is frequency of each number.
    Third row is a "filter" that marks which numbers appear 3 or more times (Yes) and which numbers appeared less then 3 times (No).
    Fourth row is here to highlight numbers that are marked with "Yes" .

    The problem is that I want these numbers that are marked with "Yes" to be ordered like shown in the document from A8:F8.
    I don't want any empty cells between these numbers or cells that contain "-" ...


    Is this possible to do automatically with functions because I dont want to use clicks (to filter) and macros??

  2. #2
    Registered User
    Join Date
    09-08-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    12

    Re: How to remove unnecessary cells?

    sorry for double threads, something blocked me when I tried to post the thread ...

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,333

    Re: How to remove unnecessary cells?

    Try this
    =SMALL($A$4:$T$4,COLUMN())
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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. [SOLVED] Remove unnecessary spaces from column c
    By aviatecar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2013, 01:28 PM
  2. Remove unnecessary code in macro
    By rileyp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2013, 11:19 PM
  3. [SOLVED] Ignoring unnecessary blank cells
    By mvg688 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2012, 09:08 AM
  4. [SOLVED] removing unnecessary spaces from multiple cells
    By sflady in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-15-2005, 08:10 AM
  5. Code / Add In to remove unnecessary white space
    By Gazza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2005, 06:05 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