Double spotting

Status
Not open for further replies.

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
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
 

Reji Rajan

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server 2010
Yes, this is all in excel, will try that forum, anyways, thanks for the suggestion
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
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
Z double calendar Using Outlook 1
E Double Tasks in Outlook 2010 Pro Using Outlook 2
L calendar delegate updates meeting with resource mailbox involved = double meeting Using Outlook 6
M Legacy OWA double login after messing with HTTP redirects in IIS Exchange Server Administration 6
J Opening webmail requiers double logging on. Using Outlook 1
K Too much vertical space between folders in Navigation Pane (like double spacing) Using Outlook 2
B I am know recieving double email after the first fix. My case number is: # 1140252913. I rep tried to call me tonight but could not get the nubmer. Using Outlook 3
B two users double book meeting room but no conflict message sent to the user Using Outlook 1
M Suddenly Outlook will not stay open when I double click on the shortcut. It opens for a few seconds but then it shuts down Using Outlook 1
D Outlook 2003 double spacing Using Outlook 1
J Outlook crashes 80% of the time I double click or even press enter to open a mail. Why? I run Windows 7 Using Outlook 4
E Double clicking on from email address does no longer open corresponding contact in Outlook 2007 Using Outlook 7
F Double presentation of Tasks in Outlook. Using Outlook 2
C Double-spaced replies Using Outlook 1
J In Outlook e-mail double spacing between paragraphs in the body of the message Using Outlook 2
R Double inboxes Using Outlook 1
A Double Tasks Listed on Outlook Using Outlook 1
M why does Outlook 2010 crash whenever I double click an email __ Using Outlook 1
B When I type single space emails they are sent double spaced. Using Outlook 2
F Seeing Double tasks Using Outlook 4
J Macro to open email (like double click) in Outlook Outlook VBA and Custom Forms 4
Similar threads





























Top