Count and Lookup - based

tamiz.vedachalam

Experts,

I need to count the values of each column excluding Today Value. Rest of the Yesterday and Blank values of respective columns like #New Hires, and drop the values in the 2 Yesterday Metrics.

It is pretty easy to do a vlookup for Today, but if I need to cumulate the Yesterday and Previous day values. How do i do that ?

I need to lookup the values form Master sheet and accumulate the count into 2 Yesterday Metrics.

LeelaLodhi03

Hi,

Could you please share a screenshot of your Master sheet and how you’re calculating the Today values in 2 Yesterday Metrics? That will help understand your setup better.