Results 1 to 2 of 2

Filter with time window (Array function?)

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2023
    Location
    Vienna
    MS-Off Ver
    MS 365 V2302
    Posts
    11

    Filter with time window (Array function?)

    Hello,

    is it possible to summarize a table with time windows? Assumption: There are different time windows of 5 days for each product when sales are happening (otherwise there are a bigger gaps than 5 days between sales).
    Is it possible to filter/summarize this time windows with an excel array formula?

    Example:
    Example.xlsx


    Thank you!

    Best wishes
    Tim
    Last edited by timenewroman; 04-15-2024 at 12:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with filter function and array
    By kvemperor in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-20-2024, 08:02 AM
  2. [SOLVED] Using Filter function with array criterias
    By kohno71 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-23-2022, 01:28 PM
  3. VBA Function to filter data from an array
    By car___ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2014, 04:31 PM
  4. [SOLVED] Filter data using Array Function
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-23-2014, 08:45 AM
  5. [SOLVED] IF function: Early/On Time/Late Time vs. set window of time
    By hclark579 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2014, 05:37 PM
  6. Replies: 6
    Last Post: 11-28-2011, 04:08 AM
  7. Replies: 4
    Last Post: 02-17-2011, 08:29 AM

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