Double spotting

Status
Not open for further replies.
Reji Rajan

Reji Rajan

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server 2010
Hi All,

Got a weird one this time, the software that I work on, gives me an excel sheet that we use to check commercial placements.( advertisements). The sheet is made of different shows that are played throughout the day with each event having a corresponding time & duration. Now this sheet also has name of the commercials that are booked. Each show has 3 breaks & every break may have 1 to 20 commercials of different brands. Wanted to know if there's a way to highlight duplicate commercials in the same break & same show, Or is this doable in the first place????

Regards
RJ
 
This is all within Excel? Is each commercial in a separate cell in the same row? Excel is not our specialty, but you should be able to do something with conditional formatting or a macro. vlookup or a pivot table might work too - it really depends on how the sheet is laid out. I recommend the forums at Mr Excel for help with Excel-specific programming.
 
Yes, this is all in excel, will try that forum, anyways, thanks for the suggestion
 
Status
Not open for further replies.
< VBA Script to Send Automatic Emails from Outlook 2010 | Add Hyperlink to Task >
Similar threads
Thread starter Title Forum Replies Date
O VBA - Regex - remove double line spacing Outlook VBA and Custom Forms 1
M Outlook 2016 IOS recipients receive my paragraph double space as quadruple space Using Outlook 2
O Double line spacing - solved with minor drawback Using Outlook 0
T Double clik behavior on agenda open a new meeting request Using Outlook 1
S Changing Double-Space Default When Replying To Emails Using Outlook 2
Y How do you stop double booking? Using Outlook 1
P double emails Using Outlook 1
F Public calander double booking Using Outlook 1
T drag drop/opening drop down/single click acts like double/highlighting Using Outlook 7
R Stop Double Booking Rooms Using Outlook 3
E Double clicking on from email address does no longer open corresponding contact in Outlook 2007 Using Outlook 7
J Macro to open email (like double click) in Outlook Outlook VBA and Custom Forms 4

Similar threads

Back
Top