Hello everyone,
My first post here, I hope I explain everything well.
I have a large spread sheet, 1500 rows and 18 columns(DataSheet). On a seperate work sheet(View) in B1 and C1 I have two values, I want to extract the rows of data where B1(View) = column B(DataSheet) and C1(View) = Column G(DataSheet).
So I have gone to AA and put in a simple If function with an AND, and copied this down, where I get a match it copies the row of data and if not it remains blank.
I would now like to go back to the View sheet and take the relevent data there through a vlookup. To do this I would need to enter a number in column Z next to a row that only contains data in AA, if(AA1<>"",NUMBER,"").
The problem is what to enter to get NUMBER. I want the number to be sequential, the first row with data to be 1, the second row to be 2 etc. Of course the first row might be row 172 and the second one row 844.
This is probably a scrappy way of doing it, but with my limited knolwedge it's the best I can come up with.
Thank you in advance to everyone who views this, it's probably hard to get your head around and I've explained it as best I can.
Wally
My first post here, I hope I explain everything well.
I have a large spread sheet, 1500 rows and 18 columns(DataSheet). On a seperate work sheet(View) in B1 and C1 I have two values, I want to extract the rows of data where B1(View) = column B(DataSheet) and C1(View) = Column G(DataSheet).
So I have gone to AA and put in a simple If function with an AND, and copied this down, where I get a match it copies the row of data and if not it remains blank.
I would now like to go back to the View sheet and take the relevent data there through a vlookup. To do this I would need to enter a number in column Z next to a row that only contains data in AA, if(AA1<>"",NUMBER,"").
The problem is what to enter to get NUMBER. I want the number to be sequential, the first row with data to be 1, the second row to be 2 etc. Of course the first row might be row 172 and the second one row 844.
This is probably a scrappy way of doing it, but with my limited knolwedge it's the best I can come up with.
Thank you in advance to everyone who views this, it's probably hard to get your head around and I've explained it as best I can.
Wally