+ Reply to Thread
Results 1 to 3 of 3

How to remove unnecessary cells?

  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
    Please Login or Register  to view this content.
    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