+ Reply to Thread
Results 1 to 3 of 3

Reflexive access to corresponding names and addresses

  1. #1
    Registered User
    Join Date
    11-07-2019
    Location
    Main Street, California, United States, North America, Earth
    MS-Off Ver
    2013
    Posts
    3

    Reflexive access to corresponding names and addresses

    Hello all -

    I have a data bank that is organized primarily by a list of addresses. Each address has a patch of various types of files (word documents, pdf printouts, separate picture caches). Information among the patches will include one or more names for correspondence. There may be multiple addresses that share names.

    My most preferable goal is to create an interface that, upon bringing up a name, will display any addresses that are associated with the name and/or correspondence established with the person. I have started an Excel file that has the addresses in each row the first column, and am planning to put each name associated into each following column.

    Basically speaking, if someone calls, then I'd like the name to bring up each address and account of correspondence. Preferably, being able to access the information by address is helpful to.

    I was going to post this in the Excel forum, but I think the ultimate interface is going to be a query in Access, so here I am.

    Thanks so much.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2003, 2010, 2016 (Windows)
    Posts
    4,299

    Re: Reflexive access to corresponding names and addresses

    I would insert a column of formulas, all linked to a key value cell, along the lines of this:

    In A1, enter a name of interest - let's pick a good name like "Bernie"

    In A2, use the formula

    =COUNTIF(B2:ZZ2,"*" & $A$1 & "*")>0

    Then copy that down to match your dataset.

    The formula will flag any row that contains Bernie in any form in any cell of that row with a TRUE, and FALSE if Bernie does not appear.

    Then use data filters to filter your data set to show TRUE values in column A, and only row with the name or term of interest will be visible.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    11-07-2019
    Location
    Main Street, California, United States, North America, Earth
    MS-Off Ver
    2013
    Posts
    3

    Re: Reflexive access to corresponding names and addresses

    Quote Originally Posted by Bernie Deitrick View Post
    I would insert a column of formulas, all linked to a key value cell, along the lines of this:

    In A1, enter a name of interest - let's pick a good name like "Bernie"

    In A2, use the formula

    =COUNTIF(B2:ZZ2,"*" & $A$1 & "*")>0

    Then copy that down to match your dataset.

    The formula will flag any row that contains Bernie in any form in any cell of that row with a TRUE, and FALSE if Bernie does not appear.

    Then use data filters to filter your data set to show TRUE values in column A, and only row with the name or term of interest will be visible.
    Hmm. I could set this as its own sheet, have A1 be autofilled when typing in a form from somewhere else, then copy all the addresses that ring true into a different sheet.

    Thank you for the idea!

+ 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