Results 1 to 3 of 3

Crossing points in two columns of data

Threaded View

  1. #3
    Registered User
    Join Date
    09-08-2011
    Location
    BOLTON
    MS-Off Ver
    Excel 2003
    Posts
    66

    Re: Crossing points in two columns of data

    Hi Marcol,

    May I thank you for your help with the “Crossing points in two columns of data spreadsheet”

    That is great.

    The use of nested “If “ & “And” & conditional colour formatting very helpful.

    To identify the Maximum & Minimum values (which I have labelled “ Peak” & “Through”)
    I have adapted your formulas and used them in Columns E & F

    See my attached modified Spreadsheet “Crossing Points”.
    Are my attempts at Maximum & Minimum formula in columns E & F correct?

    Thank you again
    Best regards,

    Derek
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1