occurrence

Hi, Dos anyone know a formula to use in conditional formatting to highlight occurrence of values. 1 3 3 3 4 4 1 So for example 1, 3 and 4 would be highlighted. So Basically just one occurrence of each cell. Regards,

I want excel to automatically count a duplicate, show the value (number of duplicates) in another cell and then delete the duplicate while still maintaining that value. Basically the algorithm would be: 1.Excel sees there's a duplicate. 2.Plus 1 to the column B of the first occurrence...

Help with returning adjacent text cell for the maximum occurrence within groups of IDs Data: <tbody> ID (A) CODE (B) SKU Count (C) Code Occurrence (D) Code % Of Occurrence (E) Max Occurrence % (H) Results Needed 1 A 6 4 0.67 0.67 A 1 B 6 2 0.33 0.67 A 1 A 6 4 0.67...

Hello and thank you for any attention my post may receive. My goal is to: find every occurrence of the word "Weekly" in column C e.g. C3,C6; insert 6 lines below (in range A2:C500) each occurrence; fill each occurrence of those 6 blank lines with the data from range A2:C500 where the word...

Hi, How can I achieve the same calculation in Power Query? In Excel I would use: =COUNTIF($A$2:A2,A2) <tbody> Name Occurrence A 1 A 2 B 1 A 3 B 2 </tbody> Regards, Tamir

Hi All, I have a list of unique IDs in column A, I want to check these against the unique IDs in column A of "tab2" and when there is a match I want column B of "tab2" checked for an occurrence of "3(1)". With column B the cells maybe mixed so some will have "3(15), 2(18)" in this occurrence I...

I have an occurrence matrix made from a set of sample data. The data represents a series of stores, and a series of items held at each store. There are over 6000 unique store locations, and around 400 unique items. The occurrence matrix maps whether the item is at the store. In the sample...

Hi! I have been trying to figure out how to do this one thing but cant for the life of me figure it out. I have vastly simplified it below, but essentially I am trying to have one formula that will "hlookup" off the name on the top and give the nth occurrence of a specific date going down. I...

I am having trouble getting my conditional formatting to work. I am trying to highlight the first occurrence of value in a range of D19:I137. I tried condition formatting duplicate value and it changed all occurrences to the same color. I also tried entering a formula but still can't get it...

Hi, I am wanting to find the 2nd occurrence of "Buyer Comments:" on my sheet and have it return the cell below it. I have been using this code: but it catches the first one. Thank you!

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

I need to write a macro that searches a specified column and counts all the cells that contain a specified string, such as character "p" and character "q" then associate this in another column specifying how many occurrence of "p" and how many occurrence of "q" in a different column. Have...

I have some data in non arranged order and I need to rearrange it in different place (see example below). The logic is: - first row below "orange themes" cells look C1:C5 for "orange" and returns first occurrence - second row below "orange themes" cells look C1:C5 for "orange" and returns...

I am sure this might be an easy one as I refer to this site often and helps me out a lot! I have large data that comes in with number of occurrences by date. What I am trying to do is try to find trends faster by counting the number of occurrences within the first 30 days of first...

I have been struggling longer than I expected and would love to get some assistance on this task that I am doing. I want to create a new column (column A), in which identifies the first occurrence of the number 1 in column B. If it is the first occurrence, it would be blank, for the rest it...

Hey there, I have some formulas going in five straight columns, and the results from W1:AA1 result in no, no, yes, yes, yes, which correspond to 1,2,3,4,5 (the column titles, which will never change, it will always be 1-5). I'm trying to find a formula that will identify that the first...

In column A is a Julian date. Column B has a 1 if there was an event and blank if there was not an event. I would like to count the days between the occurrence of the events. The calculation will need to be done on the date column because the data is sometimes missing days. Thanks in advance.

I recently asked about counting "occurrences" and "half-occurrences" in an absence calendar. The premise is that row 1 contains a value indicating an absence (UP = unplanned, T = Tardy, LE - Leave Early) If the absence is .25 of an hour up to 2 hours, it's half an occurrence, if it's 2 hours or...

Hi everyone, Long time reader, first time poster. Sheet1 contains 196 rows that contain the word "ToReplace" as part of larger string. Sheet2 contains 196 rows that contain only the word "ToReplace" in column A and a unique value in column B. I need to replace Sheet1 "ToReplace" with the...