drewmedic23
New Member
Hello all,
I am trying to figure out a function to give me the sum of all unique values (dates) in my table.
In column A, I have the dates. Some days have multiple entries. I am trying to get a function which will tell me the number of unique dates. So if the entries in A1:A4 contain 4/1/14, 4/2/14, 4/2/14, 4/3/14, respectivelly, I would want the formula to output "3". I'm fairly new to excel and have looked around but really haven't fount anything.
Thanks!!
I am trying to figure out a function to give me the sum of all unique values (dates) in my table.
In column A, I have the dates. Some days have multiple entries. I am trying to get a function which will tell me the number of unique dates. So if the entries in A1:A4 contain 4/1/14, 4/2/14, 4/2/14, 4/3/14, respectivelly, I would want the formula to output "3". I'm fairly new to excel and have looked around but really haven't fount anything.
Thanks!!