Hello,
I have a simple project that I am working on
In Column A there is a list composed of cities that appear multiple times
In Column B there are temperature readings.
so its like this
Cities------------Temperature
New York---------10
Los Angeles ------30
Tampa -----------70
New York---------100
New York---------90
Los Angeles-------80
etc
I would like to calculate in Column C, the median value of the group of temperature readings associated to the city in that row.
i.e. the output should look like this
Column A-----Column B--Column C
New York----------10-------------90
Los Angeles--------30-------------60
Tampa---------------70-------------- 70
New York----------100------------90
New York----------90-------------90
Los Angeles--------80------------ 60
Thanks, I would appreciate your help
Bookmarks