• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    Using large function, and pulling adjacent data

    Thanks I almost have it working. Only problem is the way I have it set up it does the following: A,7 B,5 C,9 D,7 E,3 If in separate cells I use the LARGE function to create a list of the top three values from column B, and then the MATCH,INDEX function to pull the corresponding data...
  2. P

    Using large function, and pulling adjacent data

    I am using the LARGE function to pull the highest number from a range...pretty simple. What I want to do is also pull the adjacent data from whatever was selected in the LARGE equation. Example: Alpha,3 Delta,2 Beta,1 If column 2 is the number range, the LARGE equation =LARGE(B1:B3,1)...
Back
Top