Results 1 to 4 of 4

Formula populates correct info on original sheet & incorrect info on duplicate 2nd sheet.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-28-2013
    Location
    grand rapids, michigan
    MS-Off Ver
    Excel 2010
    Posts
    163

    Formula populates correct info on original sheet & incorrect info on duplicate 2nd sheet.

    if you click on sequoia and look in the formula starting in column "W" you can see it is simply a formula for populated names alphabetized by last name. This has worked for me countless times before however now it seems to mess up if there are not enough values to fill the entire array I have specified - for picking up all names associated with the letter "S" in column "R" on the "Census Sheet", and it works perfectly...as long as there are six names to fill in the array that I specify in the formula - "U2:U9" and "V2:V9". I need the formula to cover those 8 cells because that station "Sequoia" can have up to 8 patients, and I want them to always be alphabetized. You can see there are not 8 patients so the formula decides to populate "Car Bumper" twice. How can I get it to not do this?

    round2forum3.xlsm
    Last edited by opusarlo; 04-11-2015 at 01:31 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Searching TEXT in formulae, rather than results of formulae
    By Niek Otten in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 03:05 PM
  2. Searching TEXT in formulae, rather than results of formulae
    By Niek Otten in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  3. [SOLVED] Searching TEXT in formulae, rather than results of formulae
    By AndyE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. Searching TEXT in formulae, rather than results of formulae
    By AndyE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  5. [SOLVED] Searching TEXT in formulae, rather than results of formulae
    By AndyE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2005, 06:05 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