Results 1 to 13 of 13

Shifting cells whilst ignoring certain columns?

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2024
    Location
    Midlands
    MS-Off Ver
    365
    Posts
    7

    Shifting cells whilst ignoring certain columns?

    Hi all,

    I'm creating a rather basic spreadsheet to track 'daily hours' across various people - See attached image. However, I've created the spreadsheet with multiple merged cells to showcase the 'weekend' and every other Friday is a 'catch up' day; something where no time will be pencilled in and will always be kept blank.

    My question is, is it possible to highlight multiple cells (see attached image) and shift them to the right, all whilst skipping/ignoring the Friday 'catch up' day and weekend cells?

    For example. I have highlighted person two's hours from the first Monday through to the second Thursday, all whilst not selecting the 'weekend' or 'catch up' cells. Now, I wanted to shift all those to the right so that the first Monday becomes free and the third Monday is taken from the previous Thursdays date.

    I'm unsure if this is even possible, so please let me know if so or if I need to make amendments to the cell to showcase the above in a separate way.

    Thanks in advance, all!!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Joshpep96; 05-11-2024 at 11:37 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Average Text Values Whilst Ignoring N/As
    By SkyCap720 in forum Excel General
    Replies: 5
    Last Post: 02-17-2023, 05:56 PM
  2. [SOLVED] IF/AND Multiple Boolean Check whilst ignoring blank cells
    By Barking_Mad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2020, 11:56 AM
  3. Counting three columns whilst ignoring duplicates in one of the columns
    By GrimGriefer in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-25-2020, 06:04 AM
  4. [SOLVED] Find 5 Lowest Values whilst ignoring certain value
    By ScabbyDog in forum Excel General
    Replies: 4
    Last Post: 08-26-2020, 08:32 AM
  5. [SOLVED] Count duplicate text values in columns whilst ignoring/excluding certain values
    By adamwestwell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2017, 05:34 AM
  6. Excel 2007 : Sort data whilst ignoring blank cells
    By Klara in forum Excel General
    Replies: 1
    Last Post: 10-06-2011, 07:21 AM
  7. LEN whilst ignoring decimal places
    By bd528 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2011, 05:50 PM

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