number

I have this code to select a random number up to the value I enter in Cell A1 In Cell B1 I enter the number of rows I want to fill. This VBA ensures that each number is only selected once The problem I have is that sometimes Cell B1 is a larger number than cell B2 so I want to be able to enter...

I have a spreadsheet with 214 rows til now, with 10 units of data on each row, 5 numbers and 5 letters. The numbers go from 01 to 1237 and 80 letters from A to CB. I need to make a table with the number of occurences of matched pairs and triples. I would like to know the number of times that 2...

Hello, I have a userform that contains a lot of controls One of them is "cmdSubmit" that contains many actions (I finished them all instead the following) I already have piece of code that copy a range and paste it in sheet2 (this range contains (Name, ID, ...)(Doesn't contain the Number) ex...

I've got 2 types of data and thought it might be a good idea to use an array to store the row number in for subsequent processing; is this a better solution than ifs & loops ? Both sets of data are in blocks of approx 4 to 7 rows but each block in its raw form is separated by a blank row so...

Dear mrExcellers, In my company we work with a product database with calculations in it, every product offcourse has an unique article number. In the shared server we have a folder with pictures of every product with the article number as the title. We want to add the pictures automatically to...

Hello brainiacks, (said with utmost respect). here is my problem: I have some code in a workbook named configureData.xlsm that creates a filename and stores to cell Q2 . I want to open a new workbook.xlsx and save it with the fileName created in Q2 The path would always be the same: UsersName...

I have a list where I want to put it to "Last Name, First Name" but if they have multiple words in their last name, I only want the last part of their last name to ensure that I won't have any errors when I'm performing a check as some reports don't put the full last name. at the moment I have...

Re: Number Selection - Extension Hi All, Extending from another thread posted Re: Number SelectionOct 24th, 2019 I am looking to analyze multiple alternate groupsizes combinations upon a Number Table and performing a similar type of ROW andCOLUMN analysis undertaken in that thread. Please see...

I am looking for a quick VBA solution. I have a range of numbers (not consecutive) in one column, 881 to be exact. I need to insert 146 blank rows in between each number, then move to the next number in the same column and then insert 146 more blank rows, until I reach the end. Does anyone...

Hi All, Can someone please help me on below formula. I am trying to add +1 if order number and store number (any one) value are different but if both values are same just use above number. =IF(OR(C3=C2, B3=B2), A2, IF(OR(C3<>C2, B3<>B2), A2+1)) RA NAME PO 4525 ABC 2001 4525 ABC 2001 4526...

I thought this would be simple but my attempts are not working for me. I need two things PLEASE. I am trying to calculate the total number of "days" between two dates, and secondly, calculate the number of "week days" between the same dates. Each would be in a separate cell. I am totally...

I have a table of data which is broken up by a number of blank rows at irregular spacing. I need to find the row number of the next blank row after the last occurance of a string in col A---which can be somewhere in the middle of the data table. I've got the row number of the last occurence of...

I want to set some numbers as system numbers to use against the ranking as done by the code below. Currently, I am using three numbers – 100, 95 and 90. In the future, I may reduce (say 2 numbers) or increase (say 5 or more numbers). And in each scenario, the aim is to make those numbers take...

I'm looking for a non-array formula that will find the position in a list of the number closest to another number. In A1:A6, let's say I have 1;2;7; ;8;9 The closest number to 6 would be 7, so the formula would return 3 for the 3rd position. The closest number to 3 would be 2, so the formula...

I have a row of 10 numbers and each week i add numbers. What i want to do is have a formula that will average the last 4 numbers in that row of numbers when i add numbers to the row of numbers. So what im saying is i want to be able to always adverage the last 4 number that have been entered...

Hi everybody, Below is the code I'm using (it does work) to find the next available number in a series of numbers in column A. I search through column A, find the missing numbers, put them into an array and then find the smallest number in the array. Is there is a more simplified/efficient way...

Thanks in advance for any help ! So I’m still learning VBA, using a combination of the macro recorder, this website, trial and error, and so on. I have a file, let’s call it “FILE A”, which has a number of worksheets. The file includes some code that pulls in data from a number of other...

Hi guys I have a spreadsheet with various cells in column A that contain data in the following format: 181/2 (18.3) Are there some formulas that will copy the number before the / and the number immediately after (ignoring the number in brackets)? I would like to copy the number before the /...

Is there a formula that I can put next to the final date that will "forecast" the number? My car contract allows 12,000 miles per year and I'm checking if I'm estimated to hit it.

Hello, How can I keep different numbers of zeros in a cell, for example, 000 or 000000 or 00000000. When I use custom format, I am limited to the number of zeros that is customized but I need to have different number of zeros in a column cells. Thank you.