No Repeat Numbers
Nov 26, 2009I'm trying to pick 10 random numbers from a list of 23, with no repeat numbers. I'm using the formula "=INDEX($A$1:$A$23,RANDBETWEEN(1,23))"
This will give me 10 random numbers with repeat numbers most of the time.
ADVERTISEMENT
Sorting Repeat Numbers
Apr 14, 2008I'm trying to develop this formula for days now.
how can I not list repeated nums from a array example:
675 863 765 982 856
no repeat nums: 675, 863, 982, 856
as 765 was repeat of 675 it should not be used.
keep in mind same goes of 3-4-5... repeats,
Generate Repeat Numbers When Compared To Previous Row?
Apr 16, 2012How do I generate repeat numbers when compared to previous row?
E.g.
Column No A2, B1, C1, D1, E1
Row no... A1 5 12 23 50 3
Row no... A2 10 21 5 25 6
Repeat number for above is 5
Given:
1) 5 cells only. All numbers are integers, no fractions
2) In a row same number is not repeated.
3) It is possible to repeat all numbers in a new run.
Repeat Data Based On Adjacent Numbers?
Dec 28, 2013I would like to copy rows based on the value of another cell.
For example turn this
code qty
apple 3
banana 4
orange 2
into this
apple
apple
apple
banana
banana
banana
banana
orange
orange
Conditional Formula: If Text, Repeat As Number To Sum, Else Sum Numbers.
Dec 29, 2008I can get only so far, then stumped:3 columns (Hours, Rate, Amount). "Hours" is a 'List' with data from from another sheet. Data is named 'Worked'. 'Worked' is all 2 decimal numeric (represents total time worked), except first item called "Live In"
IF 'Hours' is "Live In", I can use: =IF(A1="Live In", SUM(B1*1))
How can I make it conditional so that if it's not "Live In", then it will SUM(A1*B1)?. SideNote: 'Worked' LIST has total time with minutes expressed as 1/4 of hour (i.e., 1.25 = 1 hour, 15 minutes).
Add Numbers From 2 Rows,then Move To Next 2 Rows & Repeat
May 24, 2007I have 3 columns and 200 rows. The first column is for Name of product. 2nd column for number and 3rd for $value of number of products. Have 200 rows. Have done a sort and checked. 2 sets of rows are for the same product name. I want to know if it is possible to add up values in 2nd and 3rd column, 2 rows at a time , then 4th and 5th column and so forth, by some formula rather than doing it manually?
View 4 Replies View RelatedRepeat Macro To Last Row
Mar 20, 2012I am trying to repeat this macro until the last row of data present in column "D".
Sub inserttext()
'
' inserttext Macro
'
'
Range("D2").Select
ActiveCell = "Test Description:" & Chr(10) & "" & Chr(10) & "Expected Results: ERROR level fires stating " & ActiveCell
Range("D3").Select
End Sub
Repeat Last Two Actions - Cannot Use F4 Key
Jan 18, 2014I need to repeat the following two actions one after another therefore I cannot use F4 key
The actions are :
1) select some cells in two rows and colour them yellow.
2) select the last two cells of the rows ans merge them.
these are one after another where F4 will repeat only the 2nd step but I need the 1st step of colouring.
Are there any short cut keys or method or recording to repeat the above steps when necessary.
Macro To Repeat
Feb 5, 2008I have a workbook with 4 worksheets. I have a macro ( Cntrl + U ) that runs a series of steps and prints the results with it ending on the beginning page. This works well but I want it to repeat the macro until it reaches a blank cell on the starting page.
View 9 Replies View RelatedHow To Repeat Fields In A SUM
Feb 29, 2008I had a spreadsheet with 45 fields, endind with a SUM in field 47.
I've inserted new fields, exactly 531. The SUM doesn't know that and still thinks that I have 45 fields:
SUM(F2;F5;F8;F11;F14;F17;F20;F23;F26;F29;F32;F35;F38;F41;F44)
How do I add automatically the value 3 to F44, continuing to add the value 3 to 531? So I want:
SUM(F2;F5;F8;F11;F14;F17;F20;F23;F26;F29;F32;F35;F38;F41;F44;F47:F49; F52; ETCETERA)
Repeat VBA Formula
Dec 15, 2008How do I keep repeating
If Range("E22").Value Range("G3").Value Then
Rows("22:22").Select
Selection.Delete Shift:=xlUp
Until E22 does = G3
Then I need it to go to Row 23 and do the same.
My goal is to leave only rows (between rows 22 and 50) that have the same value in its column E that match cell G3.
Repeat Rows At Top Except One
Aug 18, 2007Is it possible to repeat rows on top of every page but one? Specifically, I have a seven page spreadsheet and I don't want the rows to repeat on the seventh page.
View 6 Replies View RelatedMatch And Count Value But Not Repeat The Same?
Jul 26, 2014In attached File, there is a table there is date in COLUMN "G" and column "H" contain Name....
I want to count value in column "L" by matching date from column " K " .....BUT THE SAME NAME SHOULD NOT BE REPEAT COUNT... i.e, HITENDRA and RITU name is repeat 2 times in date 1-Jul-2014 .. but it is a similar so it should count as a "1"..... the total count for the day is "6" but avoiding similar value the total count is "4"..... so I nead a "4" figure as a result......
Counting Repeat Values
Dec 10, 2013I'm putting a presentation together for work regarding false alarms and I'd like to count how many alarms have gone off at certain locations and I'm wondering if there is a formula that will accomplish this. I've attached a pic of a spreadsheet containing the data to be used. On the left side, there is a table labeled "Alarms" with columns displaying the dates, street numbers and street names. On the right side of the spreadsheet, there is a table labeled "Activations", which will be used to display the amount of single, double, triple, etc. activations.
For example, using the data, the alarm at "2 Red Oak Row" has gone off 3 times and since there are no other addresses where this has happened, a "1" would be displayed under the box labeled "3" in "Activations". Since the alarm at "4 Winding Way" and the one at "23 Blackberry Lane" have both gone off twice, a "2" would be displayed under the box labeled "2" in "Activations". The same would hold for addresses where the alarm has gone off 3 times, 4 times, 5 times, so on and so forth. In addition, if an alarm has gone off 10 or more times at any residence, the first 10 activations and any subsequent activations would be counted as a "1".
For example, if there is one case where an alarm at a certain residence has gone off 10 times (or more), a "1" would be displayed under box 10. If another residence's alarm also went off 10 times (or more), a "2" would be displayed under box "10".
Repeat Group Alphanumeric
May 7, 2014(1) In an excel i am about to create 1000 rows of records. The first 100 i set the column to display" Job Role 001 - Job Role 100. The formula i applied from row 2 onwards is: ="Job Role " & TEXT(ROW()-1,"000")
(2) Then now i need to repeat this Job Role 001 - Job Role 100 for the next 100 rows. But if i copy these Job Role 001 - Job Role 100 to the next 100 rows it will result in: Job Role 101 - Job Role 200.
Any solution to make it repeat exactly Job Role 001 - Job Role 100 for next 100 rows onwards??
Repeat Data Sorting
Nov 24, 2008I need to data sort several rows of a worksheet, followed by a different selection of rows, followed by another selection, etc, etc. The first selection is done by highlighting the rows and then following the data sort menu. \
However, if I try to highlight a second selection and use the repeat command, excel repeats the action on the first selection, not the second. As a result, I have to use the data sort menu again. There must be a repeat option which acts on the new selection.
Add Two Spreadsheet Rows And Repeat
Jan 5, 2009I have a spreadsheet that contains traffic count data for a two lane road. The data is by direction, by hour, 24 hours a day, 365 days a year so the data is basically 2X 365 = 730 rows of data.
I need to simply add the two directions together for each hour of each day, basically add two rows together, drop down to the next two rows and add them together, repeat.
I need the result as stand alone data on another spreadsheet so the Data, Subtotals operation provided by Excel won’t work for me but something similar that puts the data on another spreadsheet would work.
I also tried to use a formula in the new spreadsheet that added two cells in two rows on the original spreadsheet together and then repeated that process a few times and then tried to drag the formula down but couldn’t get it to repeat correctly.
Row Repeat In Bottom While Printing
May 18, 2009As we repeat rows at top and coloumn at left while printing using page setup option. can we repeat the rows at bottom and coloumn at right.
View 4 Replies View RelatedLook Up Dont Repeat Row Of Data
Jul 24, 2009I have rows of data that repeats every now and again and codes next to them What I need to do is have same row of data (without it repeating) and relevant codes next to these across the page. Tried doing Pivot table and failed. Example and proposed format enclosed.
View 4 Replies View RelatedRepeat A Macro Until End Of Workbook
Aug 29, 2009can I add to a macro that will repeat that macro on every subsequent worksheet in the workbook.
View 4 Replies View RelatedHow To Repeat Excel Macro
Apr 19, 2014How to repeat excel Macro?
View 11 Replies View RelatedRepeat Or Loop VBA Statements
Aug 2, 2014I am having trouble with trying to repeat or loop the below statements. I am trying to start with applying text in cell "B2" which will hide column "A" on a separate sheet. I want to know if it is possible to repeat the same statement but loop the statement until cell "SL2" and column "SK"?
[If Range("B2").Text = "" Then
Sheets("43mm").Columns("A").EntireColumn.Hidden = True
Else
Sheets("43mm").Columns("A").EntireColumn.Hidden = False
End If
Repeat VLookUp For Each Row In Macro
Feb 6, 2014I am trying to do a vlookup within a macro.
However this always shows the first result in the first row but the rest of the rows just show #REF.
I want it to look up 100's or rows and shows either the result or N/A
Once I create the macro this is what the VBA is telling me: [Code] ......
Macro To Repeat Number Set?
Mar 9, 2014I have many set of numbers in column A and Coulmn B each set separated by space.I need to repeat each set to n number of times.
View 14 Replies View RelatedMacro To Repeat On All Rows, Not Just The First One
Jul 6, 2007This macro is recorded, but I need it to start on row 2 and repeat down to row 3000. What changes do I need to make.
Repeat Spaces In Msgbox
Oct 28, 2009i'm writing to know whether in a messagebox like this:
View 7 Replies View RelatedNot Repeat The Same Formula In Each Cell, Over And Over Again
Feb 27, 2009I have a 34-page workbook. On Every Row (starting on line 4), and on Every Page (except the first "Summary" page) is repeated, this same formula....over and over again in column "N":
=IF(A4<>"A",(IF(AND(A4<>"A",OR(J4="",J4="NT")),"OK","WARNING: EXECUTION NOT EXPECTED OF LOW PRIORITY TEST CASE!")),IF((LEN(J4)=B4),"OK","WARNING: STATUS DOES NOT EQUAL TC COUNT!"))
So, since this keeps repeating over and over again, is there some way (either by formula, macro, or whatever), that I can prevent the constant repeating on every line, to bring the file size back down? [Note: This formula alone actually added almost 5MB to the file size!]
Two things to know:
- The formula above is seen on row 4 (that's why you see "4" all over the place). On Row 5, it would be "5" instead, and so on...
- The formula above always starts on row 4, and goes down to the "last used" row, in column "N" (so there's other information in that last used row as well).
....hopefully this is a very easy thing to do?
(PS: Thanks PeterSS for the help creating the above formula in the past...hopefully it can now be made less repetitive to conserve ~5MB of file space!)
Repeat A Date 6 Times?
Jan 10, 2012In cell A2 I have the date 28/12/11, I need that date to repeat 6 times, then in A8 it should say 01/03/11 6 times and so on , I know this can be done but my brain is on a go slow this afternoon and I can't for the life of me work it out
View 3 Replies View RelatedGet Macro To Repeat Itself Then Stop?
Mar 13, 2012I'm trying to create a macro to input information into a cell then repeat until the information stops.
So say I have 10 rows of information that fill up A1:D10. in E1:E10 I'd like a macro to insert some data into E1 then go to E2 and do the same until the end and then stop. So since A11:D11 would be blank the formula would just stop.
I actually work on 100's of cells a day and this is for a bigger project I'm trying to put together or I would just drag.
How To Repeat Process For Rows
Feb 18, 2013I have a list of rows with Yes and No check boxes. Columns "T" and "U" contain the output of these checkboxes (i.e. "TRUE" or "FALSE"). At the end I have a button which I'd like to run this code. Essentially, I want to code to go through row by row and do the following:
1. Check to see if both boxes are blank or if both boxes are checked - and if so set the background color to yellow
2. Otherwise set the background color to clear
I have written the following code which accomplishes this task for Row 9. Is there an easy way to repeat this process for rows 10-15 without copying all the text and changing the row numbers?
Then, any way, say "If all the rows (i.e. 9-15) have clear background colors (which would mean that they all 'passed' the test of having exactly one and only one box checked in the row), then run another macro which I have written"?
Rem Check to see if neither box is checked or if both boxes are checked and sets background color to yellow, otherwise sets background color to clear.
If (Range("T9").Text = "") And (Range("U9").Text = "") Or (Range("T9").Text = "TRUE") And (Range("U9").Text = "TRUE") Or
(Range("T9").Text = "FALSE") And (Range("U9").Text = "FALSE") Then
Range("B9", ("G9")).Interior.ColorIndex = 6
Else: Range("B9:G9").Interior.ColorIndex = 0
End If