Results 1 to 8 of 8

Help Need with Macro to filter based on a value & to return values

Threaded View

godofwar123 Help Need with Macro to... 02-04-2015, 06:47 AM
JOHN H. DAVIS Re: Help Need with Macro to... 02-04-2015, 07:55 AM
godofwar123 Re: Help Need with Macro to... 02-05-2015, 04:30 AM
excelhelpseeker Re: Help Need with Macro to... 02-04-2015, 08:22 AM
godofwar123 Re: Help Need with Macro to... 02-05-2015, 04:37 AM
JOHN H. DAVIS Re: Help Need with Macro to... 02-05-2015, 08:15 AM
godofwar123 Re: Help Need with Macro to... 02-06-2015, 01:52 AM
JOHN H. DAVIS Re: Help Need with Macro to... 02-06-2015, 07:23 AM
  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    14

    Exclamation Help Need with Macro to filter based on a value & to return values

    Hi Friends,

    Need help in Excel, I really don't know how to solve this problem.

    I have attached a sample worksheet. Input is in Sheet1 & Output expected in Sheet2

    Conditions/Steps:
    1. Filter with column B (Pass)
    2. with the filtered list(Only pass list), check in column C(Comments),
    & Output the following into a new sheet.
    In the comments,
    List the number of rows that contains 90 in column 90 & above
    List the number of rews that contains 95 in column 90 above and so on"

    Any help is really appreciated.. Manually doing this work is really hard for me. it takes a lot of time..
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vba macro filter based on a array of cells with text and number values
    By daviddg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2014, 04:39 AM
  2. Replies: 5
    Last Post: 12-19-2013, 06:58 AM
  3. Replies: 4
    Last Post: 02-10-2013, 01:44 AM
  4. [SOLVED] Edit Recorded Macro to filter column with about 200k rows based on a list of values.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-19-2012, 03:35 AM
  5. Return Unique Text Values without Advanced Filter
    By nicknick5219 in forum Excel General
    Replies: 11
    Last Post: 05-21-2009, 10:15 AM

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