Hi,
I am new to this forum. Having been an Excel user for many years I have decided to dig deeper into the functionality etc not least as I have requirement that Excel perfectly fits.
However, I am stumped by one requirement and have attached a sheet as an example.
Basically, I have a range of data over four columns - column 1 is the row number, column 2 the company name, column 3 the number of offices that company has and column 4 is the cumulative number of offices. This is referenced by a VLOOKUP calculation which uses the number from a separate field for the look_up value and this number is not fixed.
((VLOOKUP(C3,I3:L52,3,TRUE)))
Initially, I was taking the result of the above and then dividing it to return the average number offices for the range, ((VLOOKUP(C3,I3:L52,3,TRUE))/C3).
However, I would like to use MEDIAN as it is more representative. I then tried MEDIAN(((VLOOKUP(C3,I3:L52,3,TRUE)))). This returns a number each time the variable number in cell C3 is changed.
When I have manually checked this MEDIAN in a separate cell the results are different.
I have no doubt I am not using MEDIAN correctly but have a mental block on how to acheive my objective.
All and any help appreciated.
Thanks.
Best Wishes
Gary
Bookmarks