+ Reply to Thread
Results 1 to 3 of 3

Command Button for Identifying '1'

Hybrid View

  1. #1
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Command Button for Identifying '1'

    Hi,
    I would suggest to make a trick with our data before filters are applied.
    You could make additional column (probably it can be the last column, after all your data).
    Then write a formula in cell
    Formula: copy to clipboard
    =COUNTIF(C2:F2;1)

    where C2:F2 is range with 1 or 0 and 1 - is criteria for counting.
    Copy this formula down and you will get one, common criteria to filter out all data with 1 or 0.
    As little bonus - you will able to filter out persons, who have more than one broken bone, because formula will count how much '1' there are in one row.
    As far you didn't provide any sample data - check attached file for better understanding of what I'm trying to tell you
    Attached Files Attached Files

+ 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: 2
    Last Post: 02-02-2016, 10:27 PM
  2. Insert Command Button that will Activate Command Button on a Different Sheet
    By realvirtuality1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2016, 02:11 PM
  3. VBA code to create command button. Print all sheets then delete command button.
    By Declamatory in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2015, 05:18 PM
  4. Create a command button with code with a command button
    By jakara in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2013, 01:28 PM
  5. [SOLVED] vba code, command bar, command bar button, one button works but not two
    By amazingg64 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2012, 09:55 AM
  6. Replies: 1
    Last Post: 09-17-2007, 09:57 PM
  7. [SOLVED] command button:Can i use a command button to open diffrrent sheets
    By Hellboy in forum Excel General
    Replies: 0
    Last Post: 11-03-2005, 11:00 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