flag

Hi, I have a large holiday spreadsheet for my staff. The dates are in columns and their names are in the rows. I want to highlight if two or more people from the same work area are on holiday at the same time. Ideally this will flag when their holiday is added and warn them that they may not...

Hello, I am trying to find a way to identify updates in a column using a Conditional Formula. I have 3 columns, WO ID, WO Flag and Package Counter. The counter is counting the number of common WO IDs. Next, I would like to create a conditional formula to highlight (in red) when text in the...

Dear All, Pls help me re-design / minimize this formula, if any possibility.. This is one.. This is second.. And, last one.. Additionally, appreciate you all in advance, if you can suggest me how to down / reduce excel workbook size...methods.. Please suggest, that will be great...

Hi, I'd like to create a Duplicate Check column in my spreadsheet, but am wondering how to tweak it to ignore blank cells? Ex: =IF(E2=H2=K2=N2=Q2=T2,"Duplicate","") will flag duplicates, but it will also flag row 2 as having duplicates if Q2 and T2 are both blank. How can I alter the formula...

Hello my peers, I have the below code that works on my windows machine however fails to run on my mac machine. can i get your guidance on how i can amend this to work on my mac machine as well as windows. [code Sub listFiles() Dim varDirectory As Variant, flag As Boolean, i As Integer...

Hi all, I'm having a tough time flagging rows that match the values within a list and also have dates that are greater or equal to those dates that correspond to the names in the list. See example below: List: <tbody> U V 1 Name Date 2 A 10/01/15 3 B 10/02/15 4 C 10/03/15 5 D...

Hi, I have a worksheet which has 10 columns and I want to add an 11th column which will contain a formula to show me if any of the 1st 10 columns have been changed. I have searched all over for something that will show me how to do this, can anyone help please Thank you, Simon

When my userform initializes i fill several comboboxes, list boxes, etc. which triggers a _Change event for these objects invoking their _Change routines. Is there a flag that indicates the userform is being initialized? If so, it could be used to skip the _Change event routines while...

Hello I'm trying to flag unique values in an extremely large dataset with about 498,000 rows however every formula combination i've used (sumproduct and countif functions) always lock up my excel sheet. Does anyone know if there is a simpler way that doesn't use a large amount of system...

I have seven columns of names. Within each row, a name only appears one time. For each row, I would like to be run a search across all seven columns for a specific name, and flag that row if the name appears. For example, with 4 columns: John Smith | Jane Doe | Amy Jones | Jude Law Jane Doe...

I have a cell of data for example 'lean beef' - but I want to tag it with something that I can calculate later say '1 oz of lean beef' - since I figure I can't calculate 'lean beef' but I could calculate '1 oz' how do I attach this descriptor? Also, let's say I want to tag it as 'Dinner' as well...

I have a column of data now (Col A) - Currently there are 3351 rows, but this can vary by week. I am trying to write a macro now that will flag duplicate values in the next column over (Col B) Example Col A Col B ABC ABC Dupe DEF DEF...

Hi All, I've spent hours messing around with this now and just cant work it out and google is not getting me any closer :-( I've got an excel module which saves my workbook exports it to a pdf and then generates an email with the pdf attached. Where I'm stuck is setting a follow up reminder...

I have multiple computers in my lab, all of them are running Win7 Pro, and Office 2010... I have one that I use the most where the Excel Resents flyout on the Start Menu has stopped working all together. The rest of the flyouts work... Word, OneNote, LabView... any program that I open files...

Does anyone know how to create a formula that will fill a shape with a specific color is a specific event happens? For my issue, I have created a Bar Chart to serve as a Gantt Chart to keep track of timeline events. Right now, each bar represents an event in time, and they end and begin one...

The basic problem I am working with is... "Here is a list in excel of everyone in the company (empl id in column A, supervisor id in column B)... Determine the Vice President that each person rolls up to." Everyone has ids and I have the list of VP's; the quirk is that while some may have a VP...