# number

1. ### Total to be the same

Hi I have a sheet "sheet1" that is on about 12 rows that all have the same amount in it 0,000213434 So If I change any one of these number in any row, i want all of the others to change to the new number also if I change 0,00012345 to 0,01234546 all of the 0,000123456 must change to...
2. ### Autofill Numbers In Merged Cells

I know there are some topics about autofill in merged cells, but I couldn't find what I need. I don't even know if it's possible. Is there a way to autofill numbers in this kind of table? (see image bellow). There are cells merged in rows and columns. Numbers with 2 or 3 digits, depending on...
3. ### Count if the value is positive and negative 'itself'

Hi, Column A // Column B -0.1 // 1 0.1 // 2 -0.1 // 3 0.3 0.7 0.2 // 1 -0.2 // 2 -0.2 // 1 0.2 // 2 0.7 // -0.5 // 1 0.5 // 2 -0.5 // 3 0.5 // 4 0.5 // 0.3 // Rule: 1. The starting value can be negative or postive 2. Reset the count if :- i- value is...
4. ### Format decimal as number of months

Hey everyone, I want to format a decimal/fraction as a number of months. For example, I'd like to enter "=1/12" into a cell and have it show "1 month," or enter "=1.5/12" and have it show "1.5 months." Is this possible? Thanks!
5. ### Convert Time into number for Payroll calculations in PowerQuery [Office 2013]

Hey guys. I am doing my first Power Query project using and have successfully transformed data are I wanted that I could not do in PowerPivot. However I need to convert the hours worked by each employees into Number so that I can take that number and use it in the payroll software to calculate...
6. ### Hide data labels with zero values WITHOUT changing number format

Hi, How to hide data labels with zero value? I did a bit search but all solutions suggested are by changing number format. As I already have a defined number format in the chart, changing format is not an option. Also, VBA is not an option.
7. ### Error on number formatting on VBA - Very Strange...

1) I have an excel sheet with values (Numbers) that represent dollar amounts. 2) I have a Userform that has labels that update the values according to the amounts on the Excel Sheet... Everything was running smoothly until I opened the excel worksheet with a PC (I work on MAC Excel 2011) in...
8. ### Data best fit?

Hi all, If I have a range of numbers to 2 decimal places in column A, for example from -2.52 to 3.84 with intervals that are not the same -2.52, -2.49, -2.48, -2,42, -2.42, -2.41, -2.38....... 3.65, 3.69, 3.70, 3.80. In column B the number in the cell adjacent to -2.52 is 20 The number is the...
9. ### A loop counter

Hello. I am working on a workbook that uses random numbers that loops until a certain condition is met; a specific number. I am wanting to be able to count how many times the loop has to cycle until the number is calculated correctly. Essentially a counter of the cycles. Any help is appreciated.
10. ### Formula - rank numbers high to low

I have a listing of values and I need to place a number 1-10 for the top 10 highest numbers. For example, out of these 16 numbers I need a 1 next to the highest number, a 2 next to the second highest number, etc. <colgroup><col width="72" style="width: 54pt; mso-width-source: userset...
11. ### Getting an exact match in a search

Hello, new to VBA, so forgive my ignorance. I created a spreadsheet which I am adding data and assigning a number to the data. I have a search setup to make sure the number I am assigning is not already used. It works great except it cannot differentiate between say 75 and 175 or 1075, which...
12. ### range error

I'm new to VBA so be gentle. This just started happening today. Whenever I select a preexisting command button to a macro, I get an error window listing the range as "Wrong number of arguments or invalid property assignment" What can I do now? Sub clearswitchboard()...
13. ### COUNTIFS or SUMIFS

Hi, below is a partial formula. How can I count the number of AND criteria's that are met? (AND(CFW\$16=2,CFW48=1),AND(CUI\$16=2,CUI48=1),AND(DIU\$16=2,DIU48=1)) I just need a 1 for one AND criteria, 2 for two AND criteria's, and 3 for three AND criteria's. Thank you, David
14. ### help with customer AutoNumber

I need help with how to setup a custom AutoNumber in Access. I want to be able to enter a starting number with up to eight digits and then have it increment by one. So, for example I want my starting number to be 30064889 and increment from there. Is this possible?
15. ### Not even sure how to explain this in a subject request

Hi Sorry for the terrible header but i'm not sure how to explain this correctly. On one sheet I have 1 column of numbers. Each number is on a row with further data. Some columns have no data. Some numbers are duplicated in the first column. On a second sheet i have the same list of numbers...
16. ### fill a range with numbers - vba

Hi The code below is going to fill a range with random number but all the cells will get the same number. What I want, is to fill cells of that range with different random number. So I am thinking to put that line of code in a loop but how can I loop when user might enter any different range...
17. ### Fill down an array formula across multiple worksheets

In short, what I need to be able to do is fill an array formula down in multiple worksheets. Within each sheet the formula needs to fill down a different number of times. I will give some background info so that this can be understood in context and then paste the code I currently have below...
18. ### Quick Help

Hi friends, Can someone help me with working out a formula for the below, my head is hurting from getting wrong a few times. Column A is a Yes or No Column B is a number 1 to 4 Column C needs to be a formula that returns the following "Code 1" if column b is 2 and column a is yes "Code 2"...

Hi all, I'm after some suggestions. I am currently putting a worksheet together at work that will show various bits of data. Some data is pulled onto the main sheet from a hidden sheet when I put their employee ID into a cell. If their telephone number is stored on the hidden sheet it will...
20. ### VBA loop within a loop, to identify identical values

Hello experts, I am sorry about the title. It might not be the best title to describe what I am looking for... I am actually trying to create a code that will loop through orders (order lines) and check the codes next to each order number. If all the lines of code next to each order are ZERO...

### This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...