Results 1 to 4 of 4

Update on multiple query formula please

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Update on multiple query formula please

    I require an additional Data/Formula in Cell Y3 of the attached Result Data Sheet please.

    The criteria is the same as the array formula in Cell X3 with the following variation and addition:
    Date is to be greater than which I have changed to ">" already,

    But I also need additional criteria to include Cell Reference $B$2. That is, it will be looking for any entries with an ST beyond the date shown in P2 of the GOIT907 report. When this is done - (another formula, sorry) -

    Is it also possible to include the same formula shown at Cells X3 and Y3 but also adding the GOIT907!$K$2:$K$10000="SR" criteria in Cell Reference X21 and Y 21 respectively? (Based on the same criteria in X3 and Y3 but with the additionsl query.)

    Seems like a big ask, and I thank anyone in advance who can amend this for me.

    Regards - Chris
    Attached Files Attached Files
    Last edited by Christopherdj; 05-08-2012 at 07:03 PM.

Thread Information

Users Browsing this Thread

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

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