You want the standard deviation of the dates for a given item? That seems odd ...
In any convenient cell, confirmed with Ctrl+Shift+Enter
=STDEV(IF(B2:B31="A", A2:A31)) (returns 92.22)
You want the standard deviation of the dates for a given item? That seems odd ...
In any convenient cell, confirmed with Ctrl+Shift+Enter
=STDEV(IF(B2:B31="A", A2:A31)) (returns 92.22)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks