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
Bookmarks