Hi Pavel,

Can you try uploading the file again, it's not attached.

Thanks,

Mynda

Hi Mynda,

It is there now.

Pavel

Hi Pavel,

Thanks for uploading the file. I have a few questions.

1. Is the 'result' sheet the result you managed to get, or the result you're trying to get? If it's the result you're trying to get, then can you please provide a mock up of the result you're wanting?

2. Where is your query? It looks like the table on the 'result' sheet comes from a query, so I'm wondering where it is so I can see where you're up to.

3. Will there only ever be 3 frequencies; 1, 4 or 12? or could there be others?

Mynda

Hi Mynda,

I enclosed a new files. I hope it better describes the puzzle. 

Input file/table represents the manual input, that is supposed to be used as a source for the query.

Result tab represents what I want to achieve.

Then green tabs are represents my current solution. I use parameter and calendar tab to create myResult tab, however I dont know how to reclect the frequency in to the myResult. Invoice that is paid once a year has 12 rows.

To your questions

1) that is the result I am trying to get

2) input and result are manually created in this sample

3) I quess there might be 1,2,4, 6 and 12

Thanks, Pavel

Hi Pavel,

Thanks, much clearer now. See solution attached in query called 'input' on sheet called 'Solution' .

Mynda

Hi Mynda,

Thanks for the solution with list function using a parameter. I did a little clumsy adjustment, so that the quaterly invoices are expected to come in respective quarters, file is in the attachment.  

Br, Pavel

Ah, yes, I didn't spread the quarterly payments, but your solution is perfect. Glad we got there together in the end 🙂