Hi again,
i have a range of data in sheet1 like below:
Code Year City status
1 2010 A 1
2 2011 B 2
3 2015 A 1
4 2013 C 2
5 2009 B 1
6 2010 A 2
7 2001 C 1
I want to find number of the row with this conditions:
year is between 2011 T0 2014
city is C
Status is 2
I know how to find the row using For Loop or filtering range
But is there another way, like using match and index or something like that?
I want to do this in vba
what is the fastest way?
thankyou for your help
what do you want to do once you find the row... also what if there is more than one match?
You could make a column next to the table something like this:
=AND(C3="C",AND(B3<=2014,B3>=2011),D3=2)
That would give you column of "true" and "false" values - true meet the three conditions
Last edited by GeneralDisarray; 07-01-2015 at 09:48 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
use a helper column
in d2 use the formula
Formula:
Please Login or Register to view this content.
Then in vba
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks