needhelpalwa
08-24-2018, 06:26 AM
I have a data-set like this which keeps adding every week-
22773
The actual table has 44 columns and every week I make a summary from it for the data that week I tried Vlookup by date (taking 20th Aug as key) but that stops just at the first instance of finding 20th August. Is there an effective way to do this with VBA or any other excel formula which I am missing? This is the sample output-
This is the output (sorted) date wise (https://i.stack.imgur.com/PVJCA.jpg)
22772
22773
The actual table has 44 columns and every week I make a summary from it for the data that week I tried Vlookup by date (taking 20th Aug as key) but that stops just at the first instance of finding 20th August. Is there an effective way to do this with VBA or any other excel formula which I am missing? This is the sample output-
This is the output (sorted) date wise (https://i.stack.imgur.com/PVJCA.jpg)
22772