Hi,
I'm looking for help to get a formula to receive all matching results. So far I get just the first one.
In worksheet "IWKA" I need to get list of values in column Zlecenie (column A). As you can see I have formula in cell A3 and do not know how to get next results for A4, A5 etc as far as there are matching results.
Values should be from worksheet "zrzut" and the criteria is that it gets all values with IWKA in column I (WC).
The thing is that data in worksheet are about to be updated/changed every day nad there may be different amount of those - sometimes 1000, sometimes 1500.
If there is an option I would also like to find out how to add another criteria - take a column C (status) and get only values between 20 and 40.
http://asset-b.soup.io/asset/6619/7177_b5e5.xlsx
Thank you for any help
I'm looking for help to get a formula to receive all matching results. So far I get just the first one.
In worksheet "IWKA" I need to get list of values in column Zlecenie (column A). As you can see I have formula in cell A3 and do not know how to get next results for A4, A5 etc as far as there are matching results.
Values should be from worksheet "zrzut" and the criteria is that it gets all values with IWKA in column I (WC).
The thing is that data in worksheet are about to be updated/changed every day nad there may be different amount of those - sometimes 1000, sometimes 1500.
If there is an option I would also like to find out how to add another criteria - take a column C (status) and get only values between 20 and 40.
http://asset-b.soup.io/asset/6619/7177_b5e5.xlsx
Thank you for any help