Think this requires the IF function?
I have a table (table1) of the list of members with attributes in cells.
member idcarcountry1fordunited states2chryslerukraine3rolls royceukraine4porcheukraine
I also have another table (table2) with the list of members and when they visit a cafe which is only open for 3 days a week.
member idMonThuSat1YYN2YYY3NNN4NYN
Question is “how many Ukrainians have visited the cafe at least once this week? (Answer is 2)
What’s the best way to do this?
I have a table (table1) of the list of members with attributes in cells. member idcarcountry1fordunited states2chryslerukraine3rolls royceukraine4porcheukraine I also have another table (table2) with the list of members and when they visit a cafe which is only open for 3 days a week. member idMonThuSat1YYN2YYY3NNN4NYN Question is “how many Ukrainians have visited the cafe at least once this week? (Answer is 2) What’s the best way to do this? Read More