+ Reply to Thread
Results 1 to 1 of 1

hyperlink to hits from excel formula

  1. #1
    Registered User
    Join Date
    06-06-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2003
    Posts
    1

    hyperlink to hits from excel formula

    I have a spreadsheet where I am doing a bunch pof formulas to display totals from a rax sheet on another formatted summary view sheet.

    Example formulas:
    COUNT=COUNTIFS(USPS_Open!U:U,"Civilian",USPS_Open!K:K,"01 - Understand Customer")
    SUM=SUMIFS(USPS_Open!I:I,USPS_Open!K:K,"01 - Understand Customer",USPS_Open!U:U,"Civilian")

    The summary sheet is a formatted sheet with a bunch of the COUNT and SUM values. The question I have is, is it possible to make the COUNT field a clickable field that will then show the records from sheet (USPS_Open) that where hits?

    Thanks
    Attached Files Attached Files

+ Reply to Thread

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