numbers

I have a specified range selected. Range(ActiveCell.Offset(0, -9), ActiveCell.Offset(0, -3)).EntireColumn.Select Now, I have to replace all numbers with zero in the above range, except formulas. Can anyone help me?

I currently have 2 sheets of serial numbers sheet 1 has all of the new serial numbers on it and sheet 2 has both old and new serial numbers on. I am currently trying to bring all of the old serial numbers into the sheet 1 but due to the nature of index match and vlookup I am only able to pull in...

ok, i'll explain as best I can in d2:s2 I have week numbers in a3:a100 I have part numbers what I am looking to achieve is if I populate (as an example) h15 a formula in c15 will populate with the relevant week number from row 2

Hi everyone. I have a number spreadsheet with 20 columns /100 rows of numbers. I need to get the sum of the highest 4 CONSECUTIVE numbers of each columns. I have found two formula to get the sum: =SUMPRODUCT(MAX(D3:D95+D4:D96+D5:D97+D6:D98)) or =MAX(INDEX(D3:D95+D4:D96+D5:D97+D6:D98,0))...

I have an excel program where I count the numbers for the past year then use the count to pick my lottery numbers. I have won small amounts for the past year every week but never amounts over $100 so now I would like to refine my program to look at the past years drawings and compare it to my...

Hi All, So I have a column which has only numbers. For eg. 345678, 674567. I want these individual numbers to be looked from a series of data which have corresponding Alphanumeric Values eg. 345678 - Computers, 674567 - Printers ...so on. How do I place a formula which looks up the...

Hello, I appreciate if somebody please help me with how it's better to clear contents but preserve formatting. I have a data with dates and numbers. When I use Sheet.Range ("A2").CurrentRegion.Delete this preserves formatting for numbers but does not preserve for dates. When I use Sheet.Range...

Hi I have a problem which I don't think is possible in excel but thought I'd throw it out there as this site has some amazing members who have wowed me in the past. I have two sheets one has data which i want pulled onto the 2nd sheet but in a very particular way. the cell has two numbers in it...

Hi, I have 2 columns with part numbers; Column A is a Master list of part numbers. Column B contains only the part numbers i need to work with. But Column A is in a workbook with links and formulas which i cant simply replace with Column B. So I need a way to identify the items in Column A...

Hi, Is there any way to filter on a large amount of row numbers not the contents on the cells? Thanks

Normally I use the "'" apostrophe to keep the "0" at the start of a string of numbers, but I am impurting the sheet into an excel tool which is dropping the ' and the subsequent "0". Is there another way to keep the "0" in the string. Thank you, Jerry

I have 11 cells to add that contain text and numbers. I only want to add the numbers, and if possible insert the sum into a cell that also contains text. My other problem is creating a percentage using those 11 cells divided by 11 corresponding cells with only numbers to get the percentage in...

Hello, I want excel to find me the last 5 values so then I can do Average, Min, Max... I found this formula =AVERAGE(OFFSET(C3,COUNT(C:C),0,-5)) from site https://exceljet.net/formula/average-last-5-values </pre> but the problem is my column is full of numbers and I want it to ignore the...

Hello, I have a workbook with multiple sheets. On one sheet, I want to create a search box. This will have three cells to enter the numbers to match to (done via a drop down list). I need the result to look at a table on a different sheet, match the three numbers and return four different...

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

Hi, I have a column B which contains numbers. These numbers correspond to worksheets in the workbook. I need to create a macro so that when activated will open the relevent worksheet in column B. I have hundreds and would take a long time to set a hyperlink to each one when the worksheet is...

Hello, I did some searching but could not find anything that seemed to work for me so I apologize if this has been asked before: Our office recently did a batch of Windows upgrades and I'm now on Excel 2016. I have numerous macros that will perform iterations and update numbers on the screen...

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

Is there a simple Excel function that will permit me to acquire the first 2 non-blank, non-zero numbers in a row? In the picture below, I'd like 24 to appear in 1st Score and 6 to appear in 2nd Score. As always, thanks in advance for your help! [/URL][/IMG]

Hi all I'm stuck with a mental block here: I want to generate 20 individual random numbers between two values (-3.28 and 14.50) but with a condition that the average of the 20 numbers should equal a set value, in this case 5.61 Can someone help please?