Hi
Description of problem:
On worksheet 1 I have multiple columns/rows
Id, Category, Code, Install, Units, Cost
01, C , Z1 , 1 , 50 , 7.25
02, P , Q2 , 0 , 10 , 5.00
03, C , Z3 , 7 , 20 , 2.00
04, C , Z1 , 0 , 10 , 8.90
05, P , Z3 , 2 , 25, , 10.00
06, C , Z1 , 9 , 15 , 6.00
On worksheet 2 I want to be able to retrieve certain data from worksheet 1 where it matches certain criteria. eg.
Category = C and Code = Z1 and Install > 0
Would return the following data into separate columns
Id, Category, Code, Install, Units, Cost
01, C , Z1 , 1 , 50 , 7.25
06, C , Z1 , 9 , 15 , 6.00
I can count the number of occurrences of the match using an array formula, but I can't figure out how to loop round the data to return all occurrences of the match.
Any help would be gratefully received, thanks in advance