Results 1 to 3 of 3

extract data from multiple columns and rows to make a single list - REVISION

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2012
    Location
    Australia
    MS-Off Ver
    OFFICE 365
    Posts
    34

    extract data from multiple columns and rows to make a single list - REVISION

    Hi All, I previously sought assistance in setting up a "Meal Register-Catering" list by extracting only the dietary requirements detailed on another worksheet (Ward List).

    A number of people offered some great assistance awhihc allowed me to cplete that task - I thank you all for that, especially Pete_UK.

    Q1. I now need to add a new worksheet to the same file that will allow me to list only the CAT3 category entries on a new worksheet (see CAT3 worksheet). I have tried to modifiy the previously advised formulas to meet the new sheet to no avail and so am seeking your assistance once again.

    Q2. Additionally, I written a formula that will insert a date in WARD LIST cell K4 that calculates the date from the number of days entered in cell I4 and the date entered in J4. This formula works well, but I would like to make cell K4 not show any dates if nothing has been entered into cell J5 yet. I'm not sure it can be done or not.

    Thanks in advance

    Paul
    Attached Files Attached Files
    Last edited by pvwebster; 05-04-2020 at 01:00 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] extract data from multiple columns and rows to make a single list
    By pvwebster in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-11-2020, 07:48 AM
  2. [SOLVED] how to extract multiple rows of data based on a single row value?
    By resiexfor in forum Excel General
    Replies: 10
    Last Post: 02-07-2020, 05:56 AM
  3. Replies: 3
    Last Post: 04-28-2017, 03:21 PM
  4. Replies: 1
    Last Post: 04-06-2016, 07:02 AM
  5. Replies: 6
    Last Post: 02-19-2014, 10:25 AM
  6. Replies: 9
    Last Post: 12-15-2013, 10:05 PM
  7. Replies: 1
    Last Post: 03-18-2009, 04:18 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