Checking For Recurring Data That Only Appears In All Columns
I have an excel spreadsheet with 4 columns. Each column contains the names of members who purchased ticket at an event, making four events in total. I am trying to expedite my process of looking for members who attended all four events. Is there a forumula or way to narrow these 4 events down to members who only went to all 4? Any help would be much appreciated.
Sounds doable.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Re: Checking For Recurring Data That Only Appears In All Columns
Ok I think that i've properly attached the workbook. So as stated, there are four events which comprise the four separate columns. Below the headers are the names of patrons who have attended these events. I want to highlight or distinguish in some way the patrons who bought tickets to all four events. For example, no patron except for "Mike" purchased tickets to all four events. So I want to someway be able to distinguish him from the rest of the data set.
Maybe like so:
Data Range
Maybe conditionally format by formula?
Formula:
Please Login or Register to view this content.
Row\Col Event 1 Event 2 Event 3 Event 4 John Beth Mike George George Mike Beth John Mike Bob John Mike
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks