+ Reply to Thread
Results 1 to 5 of 5

Formula to see if something in a row matches something in the first column

  1. #1
    Registered User
    Join Date
    07-19-2013
    Location
    Oxford
    MS-Off Ver
    Excel 2010
    Posts
    11

    Formula to see if something in a row matches something in the first column

    Hi all,

    I have a spreadsheet with a lot of data which tracks website usage. It's linked to another sheet which I use as a database. What I need is for Excel to look for a specific username in the first column and to return a "Yes" if a certain page name appears in the corresponding row, i.e. has username seen X page.

    The problem I have is that each time a person looks at the website, another row is recorded so my dataset has multiple rows for the same user. It's something like this:
    Username Page Page Page
    Bob Pageone Pagethree Finalpage
    Bob Finalpage Pagefive Pageone
    Bob Pageone Pagefour Pagethree
    Bill Pageone Pagefour Pagethree

    So I need a formula to (for instance) look for Bob and tell me "Yes" if he's seen 'pagefive' and "No" if he hasn't. I've tried various match and index and vloopkup formulae but no joy.
    Any help much appreciated.
    Thanks,
    Adele

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,279

    Re: Formula to see if something in a row matches something in the first column

    I'm sure there must be a neater way but, for the moment, try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,279

    Re: Formula to see if something in a row matches something in the first column

    Is this issue resolved?

  4. #4
    Registered User
    Join Date
    07-19-2013
    Location
    Oxford
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Formula to see if something in a row matches something in the first column

    It is, thank you. I used a couple of other sheets to get there. Countif wouldn't count in multiple columns and there are a lot of columns in the dataset. It would have been ideal to get a one fomula solution but I've managed with a few instead. Thank you for your help

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,279

    Re: Formula to see if something in a row matches something in the first column

    OK, good ... and thanks for the rep.

    You could probably do it with a Helper column, say, column H. In cell H1, you would have, say: "Pagefive" (no quotes) and, in cell H2 down, you would have:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    With "Bob" (no quotes) in cell G1, you could then use:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Obviously, move the Helper column over as far as necessary and adjust the range from B2:D2 to say, B2:Z2 and adjust the location of the search elements as required.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDEX on a cell in Column H if field $A4 matches Column D *OR* Matches Column E?
    By StevenCranford in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2017, 09:05 PM
  2. [SOLVED] Summing the matches of one column only if its corresponding description matches a list
    By bishop-jese-erl in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-19-2015, 04:26 PM
  3. [SOLVED] Array Formula: Countif row and column matches.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2014, 08:51 PM
  4. [SOLVED] Count Formula for Matches in One Column and Mismatches in Another
    By xcel-noob in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2014, 03:46 PM
  5. [SOLVED] Formula for multiple matches to sum result from another column into another sheet
    By justmeok in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-13-2013, 06:30 PM
  6. Replies: 1
    Last Post: 09-26-2013, 12:16 PM
  7. Formula to find all matches in column A and return cells from column C
    By GenericPat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2012, 04:56 PM

Tags for this Thread

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