+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Find Multiple Variables

  1. #1
    Registered User
    Join Date
    12-09-2009
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Find Multiple Variables

    Hi

    Im programming in VBA Excel 2007 :

    Example :
    a: x
    b: 1
    c: 1

    a: x
    b: 2
    c: 2

    a: y
    b: 1
    c: 2

    The values a-c are in Column A and values "x,y,1,2" are in Column B

    What I want to do is find "x", if x's found i want b.value to be 2 for it to continue with the rest of the function. If not, keep looking for the next x

    I've tried working with the method .find which finds "x" and then i use a do - statement which searches for the next "x" while b.value <> 2

    But that doesn't seem to work

    Any suggestions?

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Find Multiple Variables

    What are you wanting to do when it's found ?

    Is this a VBA question ?
    (sounds like it given the do statement)

    you can for ex. sum c by using

    =SUMIFS(B3:B102,B1:B100,"x",B2:B101,2)

    I'm heading offline but others will help if you can provide more info... for ex. is your data always listed as a,b,c sequentially etc etc...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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