• 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.

Display Value from Cells Down Column Based Off Existence

Adam1245

New Member
Hello,

I have a column with cells containing the same concatenate formula. I've set a condition with these formulas where concatenate will not occur unless "Best" shows in the column to the left.

I want to be able to display the only concatenate result (which could appear in any of the 300 rows found in the column) in one of my cells.

I would like to stick away from macros or VBA if possible.


Thanks!
 
Hello,

See attached for what I've started. As you can see cell I3 is the result of the site that is closest to the Lat and Lon placed in B3 and C3. Sites are already preloaded so that as the tool is used different coordinates will be entered to find the closest site. Column P will only show a result if it is the best/closest of all sites. The problem in this scenario is trying to get I3 to only show whatever appears in any of the rows down column P.

Let me know if you have any questions.


Thanks!
 

Attachments

  • Location Correlator.xlsx
    97.8 KB · Views: 5
Back
Top