vba advanced filter data analysis
vba advanced filter data analysis
In this case study, I use the Excel Advanced Filter and VBA to transform some weather data with over 100 thousand data points to 365 data points i.e. one for each day.
✅ Excel VBA Programming for Dummies (affiliate) with reviews https://amzn.to/3lhnWOy
✅ O'Reilly writing Excel Macros With VBA https://amzn.to/3tmPm8M
✅ Link to download the Macro workbook, coming soon...
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson
☕
Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum
Microphones
-----------
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm : https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b
Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh
Note Taking
-----------
Rocketbook reusable notebook https://amzn.to/3sSK3xg
#ExcelVBA #AdvancedFilter #Excel #Cheltenham #vba
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
If you do use one of the links, thanks I appreciate it.
