Results 1 to 6 of 6

Using Vlookup and Randomly selected values

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2020
    Location
    NOVA
    MS-Off Ver
    Excel for Microsoft 365 MSO (Version 2303 Build 16.0.16227.20202) 32-bit
    Posts
    34

    Using Vlookup and Randomly selected values

    I'm working on an audit that will randomly select pieces of equipment and have engineers verify the electronic reading vs the local reading.
    I've put together a sample table in the tab "Source List" that will randomly choose which pieces of equipment have to be examined, as well as the points to verify. Like cooling units have to have Supply and Return air temperatures, as well as underfloor pressure. While power panels are phase voltage/current, and power.

    My struggle is in the "Report Page." Experience has shown that I have to let the randomization go on in the background, with the engineers just getting a list of what to fill out or verify. I'd like the Report Page to find every piece of equipment which fits the randomizer criteria (currently it's just a 10% chance), but not have empty gaps in it. At that point, they can print out the sheet which just has a list of what to examine, and start their inspections. There's a potential list of like 5000 pieces of equipment, so it's not feasible to have this print out with 4900 blank lines on it.

    I should honestly probably be doing this with a macro, but they're currently beyond my skill level.
    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. [SOLVED] match randomly selected rows of data
    By mikeh1978 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-18-2021, 04:02 PM
  2. [SOLVED] switch values randomly based on selected range
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2021, 05:25 AM
  3. Pressing enter and selected cell changes randomly
    By Big_Kev in forum Excel General
    Replies: 3
    Last Post: 09-12-2017, 10:09 AM
  4. No randomly selected values/VBA?
    By ruben0525 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2016, 07:39 AM
  5. [SOLVED] Highlight (grey) a randomly selected cell
    By drwhophd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2014, 10:17 AM
  6. [SOLVED] getting #value! using a randomly selected string
    By DvDj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-19-2013, 02:10 PM
  7. Randomly selected numbers
    By Keith Robinson in forum Excel General
    Replies: 5
    Last Post: 04-14-2005, 12:06 PM

Tags for this Thread

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