repeated

Hi Guys - I have tried for about 2 hrs to find a solution for this. I'm sure you experts will have a simple solution I have a spreadsheet - row 1 is headers the row 2 to 11 is data for one client (repeated every 10 rows). Column L contains a different value for the 10 row. this is then...

Hello, I have a cloumn with the following values (example) 221 315 565 865 55 323 221 9856 221 589 9744 655 221 As you can see 221 is repeated 4 times so i want the Pie chart to be created for all the values and higher percentage for the repeated value.. Hope it's easy to understand what I wrote.

I have data something like this sr r1 r2 r3 r4 r5 1 12 21 25 33 39 2 14 18 25 33 41 3 12 19 21 32 33 4 8 14 19 25 32 I want color the cell depending how many nos repeated...

I'm working on a data set as displayed below. I need to Index the maintenance and breakdown schedule of few equipment. The screenshot below displays the data for 2 equipment (Column G) with their maintenance schedule. Column A & B lists the Start date and time of maintenance/breakdown, Column...

Hi friends, I have been trying to figure out the solution to find a formula to return a value if a letter or word is repeated 2 times in range. For example : Sheet1 <colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col...

I can't find a way to auto number and repeat numbering according to the repeated values in the other column like this: <tbody> 1 Mike 1 Mike 1 Mike 2 John 2 John 3 Tony 3 Tony 3 Tony </tbody> Please help. Thank you in advance.

Hi I'm working with these kind of repeated codes. Private Sub Cmd1_Click() With Sheets("sheet1") .Activate .Visible = True End With End Sub Private Sub Cmd2_Click() With Sheets("sheet2") .Activate .Visible = True End With End Sub... Private Sub Cmd200_Click() With...

Hi, I am trying to do something that i think is quite simple!! I am trying to copy a range of cells of size 3to7, repeatedly into a specified column/range, until the thirteen destination cells are full. e.g i have range A B C D so the thirteen cells would read: A B C D A B C D A B C D A if...

hi all, i have 2 sheets, one with data and one to lookup something from data sheet. "SalesData" worksheet has repeated row entries (multiple identical orders). i have copied the "itemnum" and "itemname" from SalesData into worksheet "inventory" and removed duplicates, then sorted by itemNum...

actually not a question, more like an Excel trick someone could use. Formula to produce an array of numbers, starting from 1, repeating that number x times. After that, repeating the next integer x times. Until the maximum y is met. From then on, it repeats itself. This description might be...

OK, Im sorry if this question has already been asked but I couldnt find the answer anywhere. I want to apply a particular formula to a column which also takes a variable from the column to the left of it. A B 5 1.5 =A5*2 6 2 =A6*2 etc. This is what I want but there is also...