Hi i got a problem where I need to calculate median of a table having two columns i.e..task and count..
Task–count
A1—-23
A1—-20
A2—-15
A2—-10
A2—-
A3—-5
A3—-7
A3—-12
Can someone one please help me ..The formula should be array so that if the row count increased it should calculate the median by taking first unique task first and then for the second unique task and soo on..
New contributor
Praveen Panthagani is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.