+ Reply to Thread
Results 1 to 2 of 2

Random item from a conditionally filtered array

  1. 05-18-2020, 09:13 AM #1
    bugsibugs
    bugsibugs is offline
    Registered User
    Join Date
    05-18-2020
    Location
    Italy
    MS-Off Ver
    Office 365 MSO (16.0) 64-bit
    Posts
    1

    Question Random item from a conditionally filtered array

    Hello,
    I need to create a mock Sales dataset with some random product IDs, chosen from a list of products that could be sold at the Sale date.
    I am not experienced with array formulas and I ask for some help.

    Basically I need to populate output cells highlighted in green.

    output.PNG

    Thanks a lot in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-18-2020, 05:48 PM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Random item from a conditionally filtered array

    Hello bugsibugs. Welcome to the forum.

    I do not understand what you are wanting from what you are starting with. I am not able to connect the narrative to the upload.

    Please explain in some detail the logic of the source to output in your sample. Also what is the function of the blue cells in columns J:U?
    Dave
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Deleting item in filtered Listbox
    By DelfinT in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2019, 11:34 AM
  2. [SOLVED] Filter Array 1 with Array 2 as criteria, returning filtered data to source sheet
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-31-2019, 01:08 PM
  3. Sharing out an array of random numbers between a group of a random 2-7 people?
    By Cheshire in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-24-2018, 03:47 AM
  4. proplem when i delete some filtered item
    By sterio in forum Excel General
    Replies: 4
    Last Post: 10-05-2015, 04:52 PM
  5. [SOLVED] If dictionary key exists add new item to existing item array
    By strud in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-25-2014, 01:54 PM
  6. Random Item
    By capnsean in forum Excel General
    Replies: 8
    Last Post: 02-06-2006, 08:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1