Results 1 to 9 of 9

shift range of values if criteria is matched

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2013
    Location
    Michigan, USA
    MS-Off Ver
    O365 Insider (Beta Channel)
    Posts
    8

    shift range of values if criteria is matched

    Hello,
    I'm yet again taking a stab at new things that are challenging me at 2am in the morning

    I have a range of constant $ values from L5 to L205. ($5, $10, $15, ... (just an example they're not in any increments, random values))
    Data to be matched is on $B$3 (always end of month)
    Date range is B5:B365(always end of month with increments of 1 month: 7/31/2020, 8/31/2020, etc..) thus unique.

    if any date value in B5-B365 matches B3, I'd like matched row to start filling/spilling the L5-L205 in column G.

    example: if $B19 matched $B$3, then G19 would start with $5, $10, $15, ... end at D219.

    I'm using indirect and offset right now, but I'm unable to move the range properly.. I believe I can use a name range to offset, but can't quite figure that out right now either..
    Looking for sharp minded people to save me from hours for tinkering on the web.

    I'll take any help please

    TIA!
    Attached Files Attached Files
    Last edited by XtremeMaC; 07-04-2020 at 02:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Criteria Matched Convert Signs for Values
    By jagadeesh.rt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2019, 07:05 PM
  2. [SOLVED] how to sum values based on matched values as criteria
    By MyStix01 in forum Excel General
    Replies: 6
    Last Post: 01-18-2019, 10:52 AM
  3. [SOLVED] Extract subarray from table column based on criteria matched - text values
    By jaryszek in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-31-2018, 03:35 AM
  4. [SOLVED] Input result if a criteria is not matched from range
    By jamewoong in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2015, 02:15 AM
  5. [SOLVED] Shift all values in a range until ≤ range of values in array table
    By rtcwlomax in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-25-2015, 08:16 AM
  6. [SOLVED] If criteria met: delete cell and shift to the left but shift only over a certain range
    By olivierpbeland in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2013, 07:44 AM
  7. Macro to loop through all worksheets, pulling a range of cells if criteria matched.
    By strictlydiesel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2009, 12:37 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