numbers

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 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...

I have a array with 500 records and another array with 25 numbers. These 25 numbers are between 1-500. I want too clear all the records in 500 record array which are not in the 25 records array. Array1 10, 20, 31, 32, 45, 50 Array2 20, 45 After matching the result for array1 is 0, 20, 0, 0...

Hi, Can you advise a basic codce please to add a space between a telephone number. I have noticed that we have many telephone numbers entered like so, 01934820955 but it shoul;d be entered as 01934 820955 Also same for mobile 07899827427 should be 07899 827427 Information you may require...

I've seen this asked many times on the internet but I can't seem to find someone asking how to sort part numbers that also contain text. For example, I have the following part numbers and want them sorted in this way: 5-part 7-part 156-part 691-part When sorting, from smallest to largest, it...

Unfortunately this was bound to happen sooner or later. We have a number of product codes that are 6-digit numerical or alpha-numerical codes. It can be like "206679" or "F3465D" etc etc. Owing to the powers that be, we now have numbers like "716E18" Excel sees this and automatically...

Re: Number selection Hello All, Sometime back ( June 1st 2019 ) I put in a request in the forum for help on Configuring Number Groups. https://www.mrexcel.com/forum/excel-...er-groups.html What I would like to do is to perform much the same task as the original request except for the...

I have data that lists transactions with the product name, revenue, and cost. I make a pivot table, no problem. I try to add a calculated field to the table: Profit=Revenue-Cost. The answer I get treats the revenues numbers as if they are all 0's. The original data is formatted as numbers...

Hello,</SPAN></SPAN> I need to extract the numbers of column E:N and need to arrange them in order small to larger values in the columns P:Y</SPAN></SPAN> Example...

I need to create a custom cell format as follows: Example: 17a > This custom format would only require me to enter for example 6c OR 23d OR 3f OR 17a OR whatever #a OR whatever #b OR whatever #c etc. etc. etc. Do you get the picture? Before the need for an alpha character this was simple...

I have a large group of numbers in a column. I would like to average those numbers in groups of 7. So average the first 7, average the 2nd 7, and so on down the whole list. Is there a way to do this without manually selecting each group to find their average? I have Kutools and ASAP utilities...

Hi, I'm sure this will be fairly straightforward for someone here... I have a group of cells that I want adding together, they are cells G65, K65, O65 and S65. Each one of these cells contains both text and numbers and I only want to add the number part of the cell. They all contain the same...

Hi All, this question I asked a long time ago and didn't really get on top of it, I'm assuming I would need some VBA code to accomplish this Looking for some help on this one, if I have a series of numbers in cells A1:A20, then I would like these numbers to be printed in there corresponding...

HI Team, I want to arrange below table in order. If you see the 1st column have all the number. Now in C and G have common number with making of 1. Now i need both them in side to side. Same for others. All the columns should be arranged in order so i can know what are the alphabets have same...

Hi, I have this value (95551092 - ) in the activecell and I would like to add whatever value is in cell A50. I do have the following code which adds the value but it deletes the spaces and then moves the hyphen in front of the numbers. Sub test() Dim d As Double d = ActiveCell.Value...

i copied numbers from an online account. pasted them into excel 2002. how do i convert the numbers to numbers i can multiply etc? i tried putting a 1 into a cell then copying and paste special multiply tried converting the cell to numbers thanks all

So I'm trying to add a row of cells that contain both letters and numbers. I'm using the following macros: Function add_num(cell1, ParamArray Arr() As Variant) Dim temp As Double For i = LBound(Arr) To UBound(Arr) temp = temp + GetNumber(Arr(i)) Next add_num =...

The following INDEX/MATCH formula works but, I would like the return to be just the numbers (no text). Help modifying formula would be appreciated. =IFERROR(INDEX('SDC TRIRIGA'!$C$1:$C$15000,MATCH(A2,'SDC TRIRIGA'!$A$1:$A$15000,0)),"") Current Return: <tbody> REQ-1187706 </tbody> Would...

Hi all, I'm having a real issue in regards to being able to insert data into a cell which has data validation on it. Basically I have have made a simple data validation rule. Only numbers between 0000000000-99999999999 can be written into the cell (or in column A). I have used Excel function –...

Hello, I have an inquiry regarding round function and not sure if there is a solution or not The numbers in Column "A" are depends on some calculations What I need is to round the numbers in Column "A" to be only as the numbers in Column "D" (looks like (250, 250*2, 250*3, 250*4...)) I used...