sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
I have a huge list. In column A there is a unique code that appears randomly several times. In column b in a number. I want a formula that provides me with the median for that unique code (i.e. without having to autofilter than work it ou manually).
For example:
=median(all numbers on column B that have the same number in column A)
Hope that makes sense?
Thanks!!
For example:
=median(all numbers on column B that have the same number in column A)
Hope that makes sense?
Thanks!!