instance

I have a workbook that has about 500 sheets (all different names, but end with the same letter) , I want to create 9 buttons to clear the same cells in each sheet but choose only certain ones for each button. For instance, button 1 will clear about 80 sheets, button 2 will clear about 40 and so...

In column A I have a distinct part number. In two other columns, i have that same list of parts, but it is not unique in the lookup table. each instance will have a different value in the 2nd column. One part in Column A may exist 3 times (or more) in the look up table. In column B, i want the...

In column A I have a distinct part number. In two other columns, i have that same list of parts, but it is not unique in the lookup table. each instance will have a different value in the 2nd column. One part in Column A may exist 3 times (or more) in the look up table. In column B, i want the...

Hey guys, I need a formula that will sum data based on rows and columns. For instance - see my image attached. What I need is to lookup "NFLApparel" in column A and then sum up all of the values that correspond with row 40 = 1. So in this instance it would sum cells J50 and K50. I've tried...

I'm trying to look at data and each time it finds the word "TYPE" in column G, it does some formatting and copy/paste stuff, then moves on to the next instance. I figured a DO LOOP would work best, and it works for what I need until it reaches the last "TYPE", then crashes. I'm not very...

Dear All, Hi! I have a Master Sheet which records daily entries of calls, contacts, appointments etc, of around four staff. For instance: Calls Cont App Int ... Wed, 6-Mar-19 0 0 0 2 Thu, 7-Mar-19 9 3 1 0 Fri, 8-Mar-19 6 3 0 1 Mon, 11-Mar-19 10 2 0 1 Tue, 12-Mar-19 12 5 0 2 Wed, 13-Mar-19 18...

Hello, I am trying to count the number of instances a certain value (Company) is listed in a conditional formatted cell, where the conditions are as follows: if cell value for # of Days <4, highlight cell green; if cell value is between 4 and 9, highlight cell yellow; and if cell value >9...

Hello In a column with multiple names that has some names repeating, I would like to find the third instance of a particular name and then refer to a value two columns over. For instance if below Name is column A, CS844 is column B, Drift Correct is column C. Lets suppose Rows 1-20. Currently...

I run some analysis that's fairly heavy. And one part involves getting unique instances of a customer where distinct data field would help. However Data Model seems to be really CPU time consuming. Since I know there are never really more than about 50 unique instance per customer per daily...

Hi, I am currently working on a template to be shared among several people within the organization. It is suppose to be stored in a sharepoint using the web. The idea was to generate a backlog where you could see all changes that people have been doing. The purpose for tracking the changes is...

How can I lookup the highest number in a range of cells and find out information associated with that number, if the number was issued on a specific date for instance how can I look up that date?

I am looking for a formula expression that will let me extract from a cell that contains multiple parentheses to another cell ,specifically in the 2nd instance of parentheses. The cell content looks like this; OC (77G201)(A4T201) OC (ITPN)(GTHS) As you can see the cell content length can vary...

<tbody> A B C 1 Reference Eligible 2 ABC Yes 3 123 Yes 4 DEF No 5 123 6 123 7 GHI </tbody> Hiya Can anyone help me with the following problem. If a value in Col A is repeated elsewhere in Col A I'd like its corresponding cell in Col B to be...

got a formula that looks up a cell in another tab to bring in a time =IFERROR(LOOKUP(2,1/(ALILO!$A$2:$A$15940=DataView!$C$1)/(ALILO!$B$2:$B$15940=DataView!B28),(ALILO!$E$2:$E$15940))," ") ALILO is the tab the data is located and is in column E basically this looks up the date first from the...

A userform is loaded when a certain condition is met. When the same condition is met again, an instance of the same userform is loaded. What I need, is to add a timer after loading every userform to unload automatically after x seconds, so after x seconds this specific instance is unloaded...

Hi, Without me posting a full working example of the sheet / workbook, can anyone point me in a direction of how to speed up this formula? When I use this, it is across 16 columns x approx. 3,000 rows (this is variable but not by much) It will effectively be doing 48,000 calculations x how...

the basic formula I use is this: =SUMIF(A:A,$A$10,B:B) in this example, $A$10 returns "Total Net Sales" and there is a dollar amount in column B but...I need to sum all instances of $A$10 only if the cell 3 spots above each instance = "Saturday" I hope this is clear. the first instance of...

I've read a lot about highlighting duplicates, or all values that appear x times - but my problem is a little more complex than that. I want to only highlight cells that appear 3+ times (excluding the first two occurrences). For example: <tbody> Jim Bob Bill Mark Jane Jim Bill...

Hi-- I have a list of values in columns, organized by date. I'm trying to return the first instance of a specific value no matter the column it's in: <tbody> Date Box1 Box2 Box3 Box4 Box5 10/31/17 31 53 6 28 52 11/03/17 69 10 61 42 22 11/07/17 1 68 69 60 54 11/10/17 6 38 42 23 69...

I have a sheet that has I13 to contain a month and year for instance July 2018 and sheet names for instance July 2018 and i AM trying to copy the first 4 columns of July 2018 and paste them into a new workbook. What is wrong with this code? Private Sub cmdCopySheet_Click() Dim CopyMonth As...