Hello all!
I have an advanced Excel certification, so usually I can tackle most things in Excel. However, I was just thrown a project that I'm not sure how to approach. I have several (as in dozens) of workbooks that I need to analyze data across. Is there a way to include several workbooks in one formula? I am searching for cells that contain a value greater than 0. I would appreciate any and all recommendations. Thank you!
I have an advanced Excel certification, so usually I can tackle most things in Excel. However, I was just thrown a project that I'm not sure how to approach. I have several (as in dozens) of workbooks that I need to analyze data across. Is there a way to include several workbooks in one formula? I am searching for cells that contain a value greater than 0. I would appreciate any and all recommendations. Thank you!
