+ Reply to Thread
Results 1 to 2 of 2

Random item from a conditionally filtered array

  1. #1
    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

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,592

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1