Results 1 to 2 of 2

retrieve filled cells and their date

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2008
    Posts
    5

    retrieve filled cells and their date

    I have attached a spreadsheet that needs a formula.

    I need the formula in the summary page that will go to the scores page and look at the grid next to agent 1(C2:E32), find the cells that have a score in them and return that score along with the date of the score.

    example: for agent 1 find and return 2nd 91% and in the next row 9th 91% and in the next row 16th 100%

    and just to complicate it some, if there are multiple scores for a date I need al of those scores in consecutive rows (see agent 9)

    I would prefer to avoid using macros if possible.

    any ideas?
    Attached Files Attached Files

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