Generate Unique List Meeting Criteria

Hi,

I have 2 columns of data in one sheet that list dates (say Master Dates) and transactions (say Master Transactions).

In another sheet i would like a formula that can choose the correct transactions that fall between certain dates (call Date Beginning and Date End) and generate a list.

i have tried this array:

If((Master Dates>=Date Beginning)*(Master Dates<Date End),Master Transactions,"")

Problem with this is when used in different columns for different date ranges there are large gaps in the generated list...

I hope this makes sense to someone!

Thanks in advance.

Todd

Not sure without seeing your sample workbook, try to upload it at the forum....

Cheers

Thanks for your responses. I attach an example.

I would like to automatically generate the green shaded lists near the bottom.

Please ignore that the dates dont match the payee description. I had to make random dates for this example! Also please dont laugh at my expense(s) hah.

Todd

Maybe something like this? please check the file

Precisely something like that. Youre a genius!!

Could you please explain what the formula does bit by bit so i can learn and understand :D thank you!

Im using date criteria as criteria which the data fall in the date range in (sorry for ";" sign because my system in Indonesia using that sign):

(('Bank Dump'!$A$2:$A$29>=$E$2)*('Bank Dump'!$A$2:$A$29<$I$2), that will populate TRUE OR FALSE as a result, and I need TRUE results.

IF(('Bank Dump'!$A$2:$A$29>=$E$2)*('Bank Dump'!$A$2:$A$29<$I$2);ROW('Bank Dump'!B$2:B$29)-MIN(ROW('Bank Dump'!B$2))+1)

is populate row numbers that meet the criteria

SMALL(IF(('Bank Dump'!$A$2:$A$29>=$E$2)*('Bank Dump'!$A$2:$A$29<$I$2);ROW('Bank Dump'!B$2:B$29)-MIN(ROW('Bank Dump'!B$2))+1);ROWS($A$1:A1))

is return the smallest k-th smallest row number

and then combine with INDEX function to return value in range...

Sorry I am bad in explanation....

Regards

Wow.

I kind of get it. Thanks for explaining

You're welcome, thanks for the nicefeedback.....