numbers

I have row 1 (2019) totals Row 2 (2018) totals. Row 2 has all 12 months worth of data. Row 1 has 9 months worth of data. I need the sum of all 9 months in row 1 and the last 3 of row 2. That easy enough. Now when I collect the totals for the 10th month of row 1 I then need the total for...

Hello, I am wondering if there is a way to calculate months mathematically. For example, if this month is October (10) and I want to go back 3 months to July (7), is there an easy way to show this? Here's what I have: <tbody> A B 1 10 <--using "=MONTH(TODAY())" 2 Oct <--using...

Hello all, I was trying to use a formula to count rows that do not start with a number. Here all of the numbers that have a period should be skipped. I wan the other rows to count consecutive. With my formula, they skip the number that comes next. Could someone show me how? Thanks

I have a column of number values and need to find a give amount which could be a multiple of 1 or more of those numbers. Is this possible in excel?

Hi again, I got something I think is a big problem for me but I don't know what you think: I have a loop like For i = 1 To 100 ......... Next The loop is pointing to numbers in column B. However, all the numbers may not be present. For example, 2 or 54 etc, may not be available in the...

I'm looking for a way to add whatever number I type in my active cell to the cell immediately adjacent to it to the right. However, the part that gets tricky.. Is that I only want this to work in a range of cells. . . not the entire sheet. I have a tally of numbers in the range N5:N24...

Hello, I -had- part of my program working until I realized that the length of the filename wasn't always constant and I need help fixing that. In the following section of code it used to look for a sheet names *CEQ* and extract the two numbers before CEQ and the two numbers after CEQ. I then...

I have numbers as below. When the numbers end I want everything removed to the adjacent column. I cant use text to columns as there are varying lengths etc. So a code or formula please. P.S Some may not have letters etc after numbers for example WA2345 Before Excel 2010 Row\ColAE...

hi, i am tring to conver number to percent but its not happening its showing as numbers please help me out this and also i want to aply a condition if based on percent if above 50% the cells should be red and for DIO if its > 30 days it should be red when i am tring in F8 its working but when i...

Hi everyone, I need the example below to look like the example right of the arrow. I only want to take the Ashleigh data and all the numbers under Ashleigh and have that data to the side. Can anyone help me understand how to do this?

Hi i would like to design a spreadsheet with my staff in the first column and time across the spreadsheet. A coloured bar across the weeks would show when that staff member was available. The bar would be blank when they were on leave. This would visualise the numbers of staff numbers available...

I have a column of numbers that come from a vlookup. I want to add this column up skipping the cells with a #N/A result from the vlookup. Thanks guys.

Has me stumped. Column A: Fault codes (3 digit, multiple instances in random order) Column B: Unique serial number of part that has the fault in Column A. Data is continuously being added to the table. I want to use a formula to extract the serial numbers in column B into columns unique to...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Here I have a question how to reduce betting blokes that can guarantee max 1 incorrect, what I mean this, for example "Euromillions" playing 8 numbers direct we are playing 56 lines it cost 140€ "Formula=COMBIN(8,5)" if out of 8 numbers 5...

Hello everyone and thanks ahead for your help! I am using Excel 2016 and in my spreadsheet, in column A starting in cell A1 I have sorted numbers from 1 to 1000, no duplicates and no blank cells and no data beyond last number. There are however missing numbers. I would like Excel to when I...

Suppose I have two numbers 8170.5999 618.111 Is there a formula that shows them as: 8,170 618 That is, show a comma when over 999 I used TEXT with "$0,000" but this shows the comma even for numbers below 1,000

I have a column of serial numbers that are randomly classified. Is there an option in Excel that detects the missing numbers within this list? Thank you NUM 4001 4003 4004 4005 4006 4007 4008 4009 4010 4011 4013...

So i have a list of say 10 players down column 'A' To the right of these names there are 6 numbers ranging from 1-59 in separate cells (columns B, C, D, E, F, & G) Somewhere else in the spreadsheet, i want to put the recent lottery results (drawn twice per week) which will consist of 6 numbers...

Hello all, so I want to make a diagram, but would like it to be like spiderweb or something. It is interconnecting and comparing diagram. so example A1 b1 c1 d1 e1 1 7 4 5 2 2 8 10 11 3 3 3 A1 d1 4 6 B1 5 9 6 4...

i am in the need for a regex for my vba project. i need to replace the - dash that is in-between numbers only, example 1-3-1. The problem is i have negative numbers with dashes which i need to keep, but the patterm is consistent, 1-3-1, should be 1,3,1 so replace dash between digits with a...