flag

I've got two lists of names on two tabs. One is from payroll and one is from the email system we use. People have left but their email accounts have not been deleted. I want to run a check and flag all the names that have email addresses but are not on the payroll so they can be removed...

Hi, I need a little help if possible I am trying to retrieve a calculated variable from withinanother module, and use globally until the session of excel is closed. I need to pass a 1 or 0 back SubProductLookupBVC(ByVal control As IRibbonControl) Dim Common AsNew cCommon Dim InputCellAs Range...

Hi guys! I need your help once again. I would like to know if it's possible to create a Macro that is going to search a certain value (let's say it that this value is on cell E2). The value that i'm searching is in the middle of a text field (Imagine that I need to find the service order in...

Row4 contains a flag 1 or 0. Row7 contains my dates I am trying to do a dropdown validation for only the dates which have 1 as the flag in their column. =OFFSET(LEDGER!$M$7,0,COUNTIF(LEDGER!$M$4:$CV$4,"=1"),0) My formula evaluates to an error though. is this possible? thanks in advance Andrew

I'm getting lots of help from the Forum with trying to help a friend with his data (imported into Excel, and messy). Many thanks. The main elements have been dealt with, but I need to flag up the cells where problems may still exist. The 'cleaned up so far data' is in col C, mainly text based...

Hi, Thinking of ways I can trigger a macro hourly without using application.ontime application.ontime can cause issues and I don't find it too reliable. My idea was to have a cell containing current time =Now()-Today() Then cells with a 1/0 flag for each hour Worksheet_Change event with if...

I'm trying to create a warning formula to tell me if C2 is within 2.25 of the value of A2 divided by 2. I think it will be an IF AND combination but could be wrong. To explain further here is an example; if A2 is 110 and C2 is any number equal to or between 52.75 and 57.25; basically if C2...

Hello - I am not sure how I can add the below if statement into what I already have below. Any ideas? =IF(AND(H9="USD",E9="USD"),"No FX Trade Needed",IF(OR(H9="",E9=""),"",IF(H9=E9,"BUY","SELL")))) What I want to add is IF cell A1 and B1 start with "US" then cell H1 needs to be USD, "flag...

Hi everyone, this is my first post so I just wanted to say thanks for all the help in the past. I've been using this forum for a while and have always been able to find the answer to my questions until now. I performed an extraction of the data that I needed for a project and it came out as...

Hi peoples; – I have a mental block every time I endeavour to process conditional counters where "next" count may be preceded by undefined row strings. I have stated (as precisely as I'm able) the requirement below and posted an example with manual part- fill via dropbox link. Please could...

Hi I want to insert Conditional Formatting icons in a cell depends on the value of the cell. So I created big cell using merge and center then I create CF rule. Everything is fine but these icons i.e. red flag, green flag etc goes to the left side of the cell! How can I force excel to put them...

Sheet1 <tbody> 2019 2020 1234 54 66 5678 14 44 </tbody> Sheet2 <tbody> 2019 2019 2019 Result Flag Result 1234 54 51 77 5678 14 28 101 </tbody> =HLOOKUP(B$1,Sheet2!$A$1:$Y$4,MATCH($A2,Sheet2!$A$1:$A$4,FALSE),FALSE) Hi, Above you can see a shortened...

hi guys, I have got the code of If Not IsEmpty(UserForm1.Fillin1) Then flag = False i = 0 ID = UserForm1.Fillin1 Do While Cells(i + 1, 1).Value <> "" If Cells(i + 1, 1).Value = ID Then flag = True For j = 2 To 17...

How would I word a formula to flag if a cell is greater than or less than 90? I want to search 2 columns (Z and AA) and tell me if any of the values are greater than or less than 90 and exclude zero's and text by putting "BRACKET" the cell the formula is in. How would I word that in a formula?

Hello i am new this is my first post, had a look and the site seems very helpful like it so far! What i want to achieve? Use patients name and retrieve 2 fields ( got it working but works with Integers only ) - this fields should not be editable After locating the patient to add in the row in...

I have set up a sheet with automatic numbering based on formula based on “flag” field. Flag “h” is for headings Flag “”m” and “s” are for Sl. No. field If flag is “m”, then the Sl. No corresponding to that item is incremented by 1 If flag is “s”, then the Sl. No is corresponding to that item...

I have two different queries being pulled from SharePoint. Table 1 has a column which references the unique ID from Table 2. The caveat is the unique ID cell can have multiple IDs separated by spaces (3). Table 1 example: <tbody> Number Name Phone Number Zip Code Story ID(s) 14A Paul...

Hi everyone, Is it possible to "flag" a row everytime a a cell in it has a specific value or had the same specific value once? For exemple, I need to flag row 2 if cell B2=1 or B2 is 1 then gets changed to 0 (or other value). Also, values in B2 are set by a formula, not manually by the user.

I have a data tab, in which i need to flag if a postcode has been excluded, this will be in a column next to the postcode I have a Tab with all the UK Postcode areas, in which I then have a column next to it where I type the post code if it is to be excluded. Ideally I need a formula or VBA...

Hi i have the code below where it does a search but it will only let me enter numbers in the textbox and not letters, but i want to be able to input both numbers and letters can you help please, i am very new to VBA and still learning, i have searched for the answer alot on internet with no...