Results 1 to 3 of 3

Formula that look up high and low random numbers

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2018
    Location
    Namibia
    MS-Off Ver
    Office 2016
    Posts
    1

    Formula that look up high and low random numbers

    Hi

    Just want to know if there is a formula that look at random numbers in column C and gives the high number in D19 and the low number in D20 and the formula in conditional formatting that high light the high number and the low number.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filtering random numbers without regenerating random numbers
    By ptack in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2022, 04:03 PM
  2. Random Numbers between 0-50 Each that Will Sum Up to A Value: Formula
    By NorthvsSouth in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2015, 09:57 AM
  3. [SOLVED] How to fix generated random numbers in this formula?
    By omid020 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2013, 03:20 AM
  4. Random Selection Macro by Location and Ranking (High/Med/Low)
    By mamajacks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2013, 10:52 PM
  5. Non-random numbers generated by excel's data analysis random gener
    By Allie in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-17-2005, 02:05 AM
  6. Replies: 2
    Last Post: 09-13-2005, 12:05 PM
  7. [SOLVED] How to create a formula where high and low numbers are excluded
    By rodeoratt@discussions.microsoft.com in forum Excel General
    Replies: 2
    Last Post: 03-06-2005, 08:06 PM

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