Yesterday, for the first time in my life I ran 5 kilometers. That is 5000 meters. I am so excited, so happy for this result.
Even though I am not a fitness fanatic I do workout quite often. But most of the times when the momentum is building up I had to go on one of my business trips and everything goes for a toss. Before leaving for Hongkong / Bangalore trips I was almost there, running upto 3.5/3.8 km everyday, then I had to go and when I got back I found myself at 3km per day again. Then I moved to US and things went out of rhythm once again. But once I started going to gym here I wanted to build my stamina all the way up to 5km per day. Yesterday, I finally broke the barrier and ran 3.3 miles (5.31 km) in about 40 minutes. I think this is an indicator of things to come. One day I will run a marathon… 🙂
One Response to “How to compare two Excel sheets using VLOOKUP? [FREE Template]”
Maybe I missed it, but this method doesn't include data from James that isn't contained in Sara's data.
I added a new sheet, and named the ranges for Sara and James.
Maybe something like:
B2: =SORT(UNIQUE(VSTACK(SaraCust, JamesCust)))
C2: =XLOOKUP(B2#,SaraCust,SaraPaid,"Missing")
D2: =XLOOKUP(B2#,JamesCust, JamesPaid,"Missing")
E2: =IF(ISERROR(C2#+D2#),"Missing",IF(C2#=D2#,"Yes","No"))
Then we can still do similar conditional formatting. But this will pull in data missing from Sara's sheet as well.