Excel formula: XLOOKUP

I had to tweak this article as I was only using 2 columns (email and login date)… Here’s what my formula looked like (I used excel tables), pasted in column F XLOOKUP(MAX(Table2[Login Date/Time (UTC)]),(Table2[Email]=E2)*Table2[Login Date/Time (UTC)], Table2[Login Date/Time (UTC)],,-1) the E column listed unique email addresses. The source table which had multiple date/times per email …

Excel formula: XLOOKUP Read More »

How to setup a firewall around your home network

Why would you do this? if you take online security seriously… if you have children who use laptops and tablets at home… if the many articles regarding the problems with social media concern you… if you are concerned with how your children are developing… if you want to reduce the miriad of negative imagery and negative messaging… …

How to setup a firewall around your home network Read More »