how to list a sequence of invoices expiring the same day

[kghisla]

Please have a look at the file attached.

I cannot figure it out how to list multiple invoices expiring the same day in the financial plan sheet.

I'm stocked when one day has more than one expiring invoices.

In the file example, I would like:

financial plan sheet.
Cell C3: 1 Cell D3: 3
Cell C4: 2
Cell C5: 4 Cell D5: 6 Cell E5: 7
Cell C6: 5

please help.

Carlo

[NBVC]

Can you elaborate? Give an example of the logic. What/where is the criteria? And what would populate? Also specify what sheets you are talking about too...

[royUK]

Sorry but your workbook is very badly designed to do what you want. It ignores all the rules to allow filtering, PivotTables etc that would possibly help

[kghisla]

RoyUK,

Your comment wasn't really helpful, since you didn't explain me how to correct my thread. Now, other than being aware that my workbook is very badly designed, I don't know anything about filtering and pivot table and how to correct it.

I am new in this forum and definitely a beginner in Excel. This doesn't mean I don't want to learn and that's what I am trying to do.

I changed my original file attached and my post as NBVC advised and I am doing the best I can.
Please help!!!

Carlo

[NBVC]

Roy is probably correct in that the workbook could probably be organized better for efficiency, but I am afraid I still don't understand what you are trying to accomplish here.

The attachment doesn't seem any better than the original one.

You need to spell out what exactly you want to do.

[kghisla]

how frustrating!!!

please close this thread for me and I start over with a new one this time very clear.

thanks.

[royUK]

It's frustarting for us that you don't explain when asked