s_samira_21
07-01-2015, 06:24 AM
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
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