Hi guys,
Im trying to figure out a way to create a template so that it pulls data from the original report under the criteria I set for it.
I've attached how my raw data looks like, and I basically need to create a formula on a separate sheet to pull data that took longer than 3 days to be received than the estimate. I know it can be done much simpler with a pivot table but I am trying to create a template that requires minimal amount of work just copying and pasting the raw data and having the numbers get calculated under that criteria.
Can this be done using a formula or is a pivot table the only way?
Thanks
Bookmarks