Forum

If I may, I would recommend that you forget about the check boxes all together. They may look nice but the are not easy to work with if you have many....

Perhaps the attached workbook is helpful. With a few helper columns (just to make it easier to follow) it will put a TRUE or FALSE on every date in th...

Good point! Thx. @Velouria

Hi Amy, Hopefully you have unique ID's in both tables so that you can match records that should be the same across all columns. Unpivot both tables...

Hi Sam, As you have noticed, VSTACK (as does HSTACK) doesn't keep the formulas. It merely stacks the arrays as they are. You'd have to add a few ex...

The calendar didn't come through. Please try again and don't forget to press the "Start upload" button before you submit your reply.

Ah, I see. The data wasn't as I thought it would be. It requires a few more steps the create separate columns for Country and Product. I've added a qu...

Please try adding the file again as it didn't come across. This time, don't forget to press "Start upload" before submitting your reply. But perhap...

Glad I could help!

Hi John, I played around with your data a bit and believe the attached file now contains the basis for further analysis. See if you can follow the ...

I've been doing this many years and do not recall that you could ever select a table. Mailmerge looks at a single sheet to get the data from. I use PQ...

Hi Alistair, Did a quick-and-dirty query that does what you need, I believe. I made no attempts to make it look nice, but the steps aren't difficul...

Thanks for the file. Just wondering how you would know which month we are dealing with. Obviously, your example relates to January as that is what is ...

Tried to replicate your data with spilled arrays and constructed a single (rather ugly) formula that spills columns Y:Z, based on columns V, W and AD....

You attached a csv. Please attach the workbook (xlsx) that you describe in your question