How to write code to produce 17 rows of 0s, then 17 rows of 1s ....all the way up to 120. So that would be 2040 rows altogether. It takes forever to do it manually.

I have the following syntax in B1: "1,2,3,5,6". and I need VBA to take the very last number out of that list, and increase by four in single steps. For example: before the code: "1,2,3,5,6" and then after it "1,2,3,5,6,7,8,9." The code must be flexible, though, because it will be running within another Macro, and it must work whether the last number in the list is 1 digit ("...4,5,8"), 2 digit ("...34,35,36") or 3 digit ("...111, 113, 114"). Those three examples would be changed into "...4,5,8, 9, 10, 11" "...34,35,36, 37, 38, 39" "...111, 113, 114, 115, 116, 117".

Am looking for an easy way to produce a list of combinations (maximum 6 numbers) from a range of numbers listed in 6 different columns:

Example Column A contains : 1,2,3 Column B contains : 7,8,11,15 Column C contains : 12,16,18,19 Column D contains : 17,30,31 Column E contains : 30,31,32,33,34 Column F contains : 37,39,40 The rules are:

In each combination of 6 numbers, numbers should always be taken from ALL 6 columns. In each combination, numbers cannot repeat.

I know you can take a number from one cell and combine it with number from another cell and make it one number. What I need to do is the reverse. Take a two digit number in a cell and separate it into single digits in two cells. If you have the number 50 in a cell, then is there a formula that will take the 5 and put it in cell and take the 0 and put it in the cell beside it?

I have selected numbers to play in the table shown above from cell G2:AD7 and celebrated draw result numbers are shown in cells A3:F7

Now, suppose I want to play the numbers, which are in cell G2:AD2 and the draw-celebrated numbers are shown in the cell A3:F3.

Now I want to check cells A3:F3 with G2:AD2 and want to know in which position are the celebrated draw matched with the numbers played.

In this case the result in AE2 will be 3; 22 that means only two numbers are matched with the played numbers. Those numbers are the number ‘6’ which is in the position 3 counting from G2 and number ‘48’ which is in the position 22 counting from G2 again.

The result must be shown in column AE for all the draws as shown in the table above.

my new payoff worksheet and then this small bug appears and my excitement like "poof"(gone)!.

with this code --> =if(search("ins",i27,),LOOKUP(99^99,--("0"&MID(I27,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},I27&"0123456789")),ROW($1:$10000))))+0

i can get the value if the word contains "ins" like this --> "Ins 723.00" return 723.00 which is correct, and then i've encountered a word which is like"723.00 Ins", and martin gave me the code to get from both sides which is this one --> =IF(ISNUMBER(SEARCH("Ins",A1)),LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000))))+0,"") . Work perfectly. and my big problem is that the word Ins 723.00 means Insurance and the 723.00 means Inspection, so it means they're different. and it means I cant use martin's code with this.

So is there any way i can get only the value if the word Ins is in the right side of the amount and also the code if the value is in the left side of the amount. I need two formula for this.

I would like to attribute a number to each digits 1 in position.

Â IJKLMNOPQRSTUVWXYZAAABACADAEAF1Â 12345678910Â Â Â Â Â Â Â Â Â Â Â Â Â 2Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 3Â Â Â Â Â Â Â Â Â Â Â Â 4Â 0111110010Â Â 234569Â Â Â Â Â 5Â 1110010000Â Â 1236Â Â Â Â Â Â Â 6Â 1010010110Â Â 13689Â Â Â Â Â Â 7Â

The list at the left is the data (A1:F1900) in the middle the table (is like a parking lot - place number), and in the right is the swap results, I mean if I put the table in front of the list, and want to know what place number 2 was before, I can see was in the position 7 in the table, next #6 was in 8 and so on, see the example:

Code:

2 6 25 31 37 50

1 2 3 4 5 6

[Code]...

when I go to swap the second line I mean 2-6-11-18-etc. the table has to move one cell down like this.

Code: 2 6 25 31 37 50

[Code]...

and for the next number, the same thing, the tabe go down one place and according from the new position swap the numbers.

The position talbe is on H:M from 1 to 500, I don't write H1:M500 because remember this table go down one row every time, and the results in O:T; well at least I don't find another way to explain.

I am having an issue with formatting a cell to 'general'. I have a macro that runs using a formula (i.e. =MID(A12, 18,5)) to extract certain characters from an external data source. I then use only the values of that formula. There then is another macro that compares that value to another value in another worksheet. The issue I am having is when the macro runs, the code is read as ActiveCell.Offset(0, 3).Value...but instead of returning the value in 'general' format, it returns it with what appears to be text (i.e. "75.50" instead of 75.5). This acts as a mismatch since the quotes appear.

I have attempted several things to correct, but even if I try to format-->general it maintains the quotes. The only way it changes is if I click within the cell...then it turns to general (i.e."75.00" becomes 75.5). I am not sure what is the issue.

With exception to Duplicate numbers on a single row, or column. I am hoping I can check an entire row against other rows, to see idf the same number are repeated.

Unlike the Lotto, this is about Safety boxes, where I have sequential numbering such as the following:

im using a formula to count how many time a customer has payed their bill using COUNTIF.

along with that i would like to use some kind of reference or a secont formula like =COUNTIF(range1:range2,"Jean K") + another formula, so it will only calculate the amount Jean K has paid, and won;t count everyones elses paymets. i just need a little help to make this happen.

and also included a sample of my sheet in a ScreenShot.

I'm Importing Columns from one sheet to another in the same workbook. imports good But:

1- Some columns with first records/rows blank do not import at all.

2- I have a column with some letter/numbers combinations and single numbers at times. Those single numbers are not imported. And half my data in that column are single numbers.

In row G, I have a wide range of values from -3000 up to 2500.

These values are generated from a formula. =A5-B5.

I need a script that will scan row G between G5:G500 and give them a letter value.

Convert anything less than 0 to an A Convert anything equal to 0 or equal to 1 to a B Convert anything between 2 and 7 to a C Convert anything greater than 7 to a D

It can place the new categorized letter value over the original formula in row G or put the letter value right next to it in H.

given the number set how many times does the number 5 show up in the 4th digit. I know its 3 but for the data size I need to run it on, it is impossible to count.

What function would count how many times a certain number shows up in the same spot?

I am trying to write a macro that will select and copy all cells in a row that do not have a zero value.

The data I am trying to select will be contained in 12 cells in a single row, i.e cells A1:L1 and all zero values will always be on the right hand side of the first non-zero value in this row (going left to right), for example:

Row: A B C D E F G H I J K L (1) 0 0 0 0 1 1 2 2 2 2 2 2

What I want to do here is to select and copy cells E1 to L1, since they are the cells with non-zero values. This can vary, so here there are 8 cells with non-zero values but the next time there might be only 5 cell or all 12 cells, etc. I have a lot of data to sort like this so doing this manually takes a lot of time.

Once the macro has selected and copied the right cells, I will manually paste the data where I need to put it.

The big problem I am having is knowing how to firstly select the appropiate cells.

I have set up a spreadsheet template that automatically populates specific values through the spreadsheet based on what the value of cell "A1" is. I want to run through 224 potential values in cell A1 and print out the worksheet after each potential value.

My thought on how to approach it is to write a macro that: 1. Selects the next item from the drop down box in cell A1 2. Prints the page (using default print settings) 3. Loops

But I don't know what the code would be. Cell A1 also does not need to be a drop down box, as long as it incrementally runs through all 224 listed values and prints after each one.

As i am working on consolidating the Missing numbers manually, whether will it possible for making this automatic.

In Column "A" I have Multiple Duplicate Invoice Numbers and followed by the Different Transcation numbers in Column "B".

In Column "D" I have Each Invoice Numbers and in Column "E" Total Transaction Numbers i.e., no. of times each Invoice have Transactions.

In Column "F" No. of times we received the Transactions.

Here i need to manually need to update each Invoice's Missing Transaction number in Column "H" in single cell with comma separated to each Missing Transaction numbers.