Nov 21 2019 09:39 AM
Hello,
I have a data set that i wish the count the number of distinct text values in a column given certain criteria from another column.
Please see attached "Example data Set". I would like the count of distinct text values from the column "name" given that the Value in Column "rank" is C1.
Thank You!
Nov 21 2019 09:56 AM
As variant
=SUMPRODUCT(($B$2:$B$13="C1")/COUNTIFS($A$2:$A$13,$A$2:$A$13&"",$B$2:$B$13,$B$2:$B$13&""))
Nov 25 2019 05:10 PM
I am using Microsoft Excell on a Mac computer. I have created the attached 4 Week Microsoft Excell Spreadsheet Calendar Template, which includes calendar dates. I use the calendar repetitively. I am looking for a way to place in cell C1 the date for any particular Sunday, and calculate 1st Sun, 2nd Sun, 3rd Sun, 4th Sun, and 5th Sun of the month, in cells C11, C23, C35, and C47 respectively.
Thank you in advance.
Nov 26 2019 12:47 PM
Richard, I guess I've seen that as a separate question.