With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, May 11, 2015
yogi_Compute For DashBoard Number Of Unique Persons Who Visited Designated Cities In Specified Year
Basically, my goal is to create an interactive graph that works off of countifs from Sheet1. You can see in Sheet1 there are six people (Abby, Bobby, Cindy, Danny, Eddy, and Frankie) who have visited Paris, New York, and London a number of times between 2007-2008.
I'm trying to figure out a countif formula for the interactive graph that counts how many INDIVIDUAL people have visited these cities (in 2007, 2008, or both). So even if Abby visited Paris in 2007 three times, she only gets counted once because she's only one person.