number

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

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

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

What im trying to do is average a row of numbers that represent the months. what im getting back as a result is: when i put a IFERROR(AVERAGE(A1:A5),0) FORMULA for Cells A1 thru A5 and i want my answer in CELL A7 i get one answer of the number i put in cell A1 not the adverage of that number if...

Hi everyone, I have an excel workbook with many tabs/worksheets. Each worksheet is in pretty much the same format. The thing im trying to do will work much easier by an automated VBA macro. Something that a little beyond me but I'm getting there. What I want to do manulally is this: In my...

I have one excel file where data is entered, and then transferred to another excel file with macros. On the second excel file I would like a macro that inputs a sequential number for each day in column A, and a sequential number for each week (or Month if week isn't possible) in column B. The...

Hi all, I need help building out a formula here. If I have a column of data that I am performing a SUMIF on, I would like to incorporate a Rounding calculation to the SUMIF formula. If the sum of the data's decimal point is below .5, round down nearest whole number, if over .5 round up to...

Hi all, I'm trying to get a number from a cell based on the criteria in 2 different cells but in the same column. This has to be pasted in another sheet, which has got the reference number same as one of the above 2 criteria. Please help. Thanks,

Hi All, I'm wondering if someone could help me on this! Is it possible to add month instead of range. Like count unique number in column B for the month of Sep, Oct or Nov. Note that I have column C which has dated when claim number was issued. A B Test-Count | Auto-Num...

Hello all, I'm trying to figure out how to VLOOPUP a custum number rounding function based on the type of pollutant. For example...(these emission rates are made up for the purpose of the example) Avg (lb/hr) Max (lb/hr) Annual (tpy) Pollutant A 0.11115...

Hi, thanks for looking? When I download some nominal data from the finance systeminto excel the supplier number (which is a mixture of letters and numbers) appearseither at the start, middle or the end of a text string including otherinformation. Therefore if I am wanting to do a vlookup against...

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

In cell A I have a date (e. 22-Jan-16). In cell B I have a number (ie. 10). How do I make cell C return the cell A date plus the number in cell B in years? So it would return 22-Jan-26.

I have data running down column A (Part Numbers) Example: I have a Part number in A2 but don't have another Part number until A45 and then another lets say in A55 How can I copy A2 down to A44 and then A45 down to A54 and then A55 down to last row (I can determine LastRow by using Column B)...

Hi all, Probably a really simple answer to my question. I've written the below formula to give me a tel number in a cell if one is held on another sheet and to show no tel held if it isn't there. The final part of the formula works fine but if i hold a tel number is gives me #value ! error...

Hi all. I'm renting out construction tools and have my margin at different rates depending on the number of rental days. This is what my days-margin cells look like: <tbody> D E Days Margin 1 1.4 2 1.3 3-7 1.2 8-14 1.15 </tbody> If I have A3 titled "Number of Days", B3 shows the...

<tbody> Original Revised Days Overdue 12/2/19 31/3/19 X 31/12/19 X </tbody> Good morning all, I wonder if you could help me out with a query. I have a table with two dates, an original date and a revised date. I need the formula which looks at the revised date first and...

Hello, I have a large table (100x200) which is updated daily. Cells are either 0 or 1. For each column and starting from row 2 I need to count the number of continuos 0 until a cell with 1 is encountered (e.g. today cells from K2 to K13 are all 0, H14 is 1 so the result should be 12...

I am am looping through a range on my computer (Excel 2013) and where I find a number 1 I want to replace it with a random number between the bottom number in Cell I9 and the top number in cell I11 So what I need my code to do is Activecell.value= "Randbetween Range ("I9").value and Range...