Forum Discussion
Help Needed copy and pasting values only when a condition is met
Hi Everyone, I have an excel table that tracks the % of items that are within SLA for a team. This is live data so when the dataset changes, so does the table. I want to be able to copy and past...
.PNG){kind=link}
Hi Sergei,
Sorry, the screenshot was out of context. The first table in the screenshot tells me how many are inside/ outside of SLA today. This Table pulls from a live data set.
I want to create a second table where I get a snapshot of this data every Friday but it is a static view. i.e. the following week once the data has changed it will not affect the data from the previous week.
The formulas both you and I mentioned work for a live view but they are not static, they will change as the data changes.
What I am looking for is essentially a "paste values" whenever the if statement criteria is true. In this case, it is a certain date.
Do you think this is something you could help me with?
updated screenshot attached
Thanks
Ian