identify

This sounds like it should be simple, but I am struggling. Thank you in advance I have 2 columns of data similar to the below (but 44,000 rows). First column is an account number, second is an identifier. I need to identify the where an account number has both a 2 and 1...

I've been struggling to find a way to identify pairs of entries for which at least of portion of their time overlaps. To make the challenge more difficult, I need potentially overlapping entries to meet multiple criteria before they are determined to be overlapping. I have two fields for...

I am using the age old loop through the controls ie. For Each cCont1 In Workshop.Frame2.Controls If TypeName(cCont1) = "TextBox" Then etc., etc. My question is "How do I identify the frame that the control resides in?" I have 10...

identify the 3 letter pattern in the draw line http://www.mediafire.com/file/27frtcym6d6ulxx/detectar_os_padroes_das_3_letras_no_sorteio.xlsx/file

Hi all, I have been compain 100 files in one master file using VBA, Sub GetSheets() Path = "C:\Users\dt\Desktop\dt kte" Filename = Dir(Path & "*.xls") Do While Filename <> "" Workbooks.Open Filename:=Path & Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets...

Hello guys, hope somebody can help me :-) I am working now with ActiveX controls and stucked little bit.. on sheet1 I have ActiveX Frame, inside this Frame I have another two frames and inside those frames, I will have textboxes...Do you pls know, how can I identify those textboxes and extract...

Hi, I have set of values in column A, for e.g. 10,20,30,40,50,60,70,80,90 and 100. Now in column B I have below values 33,50,60,90 How to identify, range of values in column A based on values in column B. It should return following values : 30,40,50,60,70,80 and 90(assuming we are taking...

Looking for excel formula(s) to identify major peaks and valleys. I've been using use slope combined with if, sign and vlookup to identify the peaks and troughs. My issue is there are too many peaks and troughs some of which occurring for consecutive y points. Is there a way to only show the...

Hello, I am trying to create some type of formula or VBA script that will look at a series of given numbers and identify which numbers if summed together are closest to another given number. For example if I am given the series of numbers shown below, which numbers if summed together are...

I have a master data workbook which I use to return/update data to different workbooks using a SumProduct function with three criteria every month. Occasionally, a new product type is included in the master workbook, but accountants forget to record the new product to one of the workbooks where...

Ive got a vba script i am writing that I need help with. So I am the stage where after auto filtering the dataset in Excel, I need to copy values down a column from a particular position. So what I have done is to identify the column header I need to copy values from, offset down two cells and...

Hello, The below formulas are copied after 'View formulas' was selected. Apparently there is a circular function but I cannot identify and resolve it. Any help please? []=SUM(Assumptions!D27:D28) =SUM(Assumptions!E27:E28) =SUM(Assumptions!F27:F28) =SUM(Assumptions!G27:G28)...

Hello is there a formula or a VBA code to find the missing Date. i have a column that i need to review every month to identify the dates that are missing. example is below. if the column was small as bellow i can identify that i am missing 12/3, 12,4--12/8 712,9. THANK YOU IN ADVANCE...

I have a file with 1331 account ID's, I can use the count function to identify if an ID is duplicated, is there a way to identify which of the duplicates is the primary duplicate? For the purpose of this, the primary would be defined as appearing first in the order (row number)

Hello All, I would like to have a macro which finds the header "Blogs" in the input sheet --> Then apply the filter to identify "NA" and Blanks --> Then replace the blanks and "NA" with "No" --> then take out the filter. Note: Somtimes Header "Blogs" might not be available in the sheet for...

I have seven day columns, with blanks and entries, I have a formula to identify the last ROW of each day, and use a MAX function to return the row number. so far so good I need to use =COUNTBLANK(M14:S34)+COUNTA(M14:S34) and =COUNTA(M14:S34) to be able to identify the difference between...

Hello all, Please if anyone can help me with this topic. I have an agreement set as a value to be achieved , and billed revenue for each month for a 24 month timing. I have also s start and end date of the agreement. I have found if the target has been achieved or not but cannot identify in...

We have posted a survey and have received many answers. Unfortunately, there is no relationship in our CRM and the questions have all become jumbled. I am wondering if there is a way to process the data in Excel to make the data useful. For instance: Identify shared time stamp (survey is...

Hello, Is it possible to choose one variable and one result cell and graph them automatically? Or can I identify the variable that has the strongest effect among multiple, in a result cell? Thanks!

Hi I need to amend a formula to run sumifs and countifs. My challenge is that I need to identify a product serial number. The serial number contains two parts, the first part is rigid but the second part is variable. Part of the code I need will always be the 5th and/or 6th characters. If I use...