+ Reply to Thread
Results 1 to 3 of 3

Help with tricky function

  1. #1
    Registered User
    Join Date
    07-16-2009
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2007
    Posts
    1

    Help with tricky function

    I have a set of data in which I am trying to analyze and filter thru some information and not sure of the best way to get started. I apologize I am pretty good at using excel for formatting, etc. but when it comes to functions I am no expert. Basically I want to flag column A if all of column B for a given column A is CLS. This is just a start to the 50,000 rows of data I am looking thru. So out of the data below I want to somehow "flag" column A where column A equals 1006, 1010 and 1015 because all of their column B values are CLS. If this makes no sense I will try to explain better. Please help me at least get going in the right direction. Thank you!

    Col A Col B
    1005 ACT
    1005 ACT
    1005 ACT
    1005 ACT
    1006 CLS
    1006 CLS
    1006 CLS
    1006 CLS
    1006 CLS
    1006 CLS
    1006 CLS
    1007 ACT
    1007 ACT
    1009 ACT
    1009 ACT
    1009 ACT
    1010 CLS
    1011 ACT
    1011 ACT
    1011 ACT
    1013 CLS
    1013 ACT
    1015 CLS
    1015 CLS
    1015 CLS
    1017 ACT
    1017 ACT
    1017 ACT
    1017 ACT
    1017 ACT
    1017 ACT
    Last edited by brodemeyer; 07-16-2009 at 05:06 PM. Reason: Hard to read data.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097

    Re: Help with tricky function

    Hi,

    Welcome to the forum, but......

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Help with tricky function

    deleted
    mod came swooping in lol
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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