Jun 27 2022 07:22 AM
I got a huge data sheet from SQL but I only want to show those rows that were created since 1st January 2022 (UK date 01/01/2022), what formula or conditional formatting can i use if i make the data refreshable?
Thanks
Jun 27 2022 09:12 AM
Take a look at the relatively new FILTER function. Here's a YouTube video that explains it. As I understand your situation, this would be perfect. Set whatever criteria you want for those derivative spreadsheets, and FILTER will deliver the relevant rows from your master database. (You will need a new version of Excel)
https://www.youtube.com/watch?v=9I9DtFOVPIg