We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel Query

Options
Hi All,


This code has been giving me problems and I thought I'd try again on here to shed some light on it as the results are not what was expected. What I need to do is search column B (Peer Group) for matching values and compare these with what's in column AJ (2015 Tcomp) and return the median value. Below is the code that is currently being used but the values returned are inaccurate. At present I am not allowed to change the below code but can anyone advise as to what this code means and why it fails? Obviously when I drag down the formula B3 changes to B4 etc etc.


=MEDIAN(IF(peer=$B3,IF(tcomp>0, tcomp)))

Comments

This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.9K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.9K Work, Benefits & Business
  • 598.7K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.