Get product code and quantity based on date

Hello BRISBANEBOB,

Well, technically, the easiest way to do this without VBA is to copy paste the entire unique name list on the J column and use a formula like this:

Please Login or Register  to view this content.

Which will simply return the value on the corresponding column, and afterward you can copy paste value, filter / sort it I guess.

If you want to sorten it even further in the steps you need to do, you can probably make use of Array Formula, but it will take a toll on the performance if you have a large amount of data.

Also, are you fine with an VBA approach? It will be a neater approach in my opinion.

Here is your sample with the formula, just change the date in E21 and you will see it change.

Another way using array formula in E23 and filling down.

Formula:

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Then this formula in F23 and filled down.

Formula:

Please Login or Register  to view this content.

It does not have to be array entered.

You're welcome. Thanks for the feedback.