Hi there, I have one sheet ('A') with a range of dates (dd/mm/yyyy) in row 3. In column A there are some times and the cells from column B onwards, will have...

Any help/advice much appreciated... I have a numerical value produced as a result of an existing formula and need to find the closest higher value from a...

I want to be able to calculate how many working days there are between an issue date and a completion date, but, if there is no completion date I want to...

I have a holiday sheet where a number of the cells are locked but some can be accessed to put in holiday requests. The person inputs their holiday request in...

Dear All: First, allow me to express my deepest thanks for all of the help y'all have provided me over the years while working and figuring out my...

I use the formula suggested in 1 second by "teethless mama". =IF(COUNT.IF(Range;value)1;"duplicated";"") It works well for know numbers but I am not able of...

I am nesting tables in a worksheet, but the inside subtotals keep appearing under the outer subtotals. In fact, the first nested table subtotal is properly...

I'm doing a search of a table with a unique transaction code (column A) and its corresponding description (column B). The table doesn't have all of the...

Hi I have a workbook with lots of validation drop-downs, it works fine for me and some of my colleagues, but some others cannot see the arrows? I have sent...

Hello, Got two sheet with the following data: Sheet1 Sheet2 A B A 0010711463 29 0010711463 sumif( 0010701463 15 0010711463 10 0000711463 45

Help please. I have cell C2 as an option of either less then 1400cc, more than 2000cc or a number in between. I have cell D2 as 'Petrol' or 'Diesel'. I have...

How do I get a cell to round up by $1.00 without changing the sum total? I know how to make it round up by one or two places. Example: Cell (A1=...

Can anyone advise how to create an alert when sheets inadvertently remain grouped, (after the purpose for grouping has been completed) so data is not...

I am trying to set up a worksheet to calculate a storage cost according to date recieved. Ex. 200 cases recieved before the 16th charged at $0.50 per case....

Good evening group! I am trying to use the DGET function to return one value from a group of cells. My table structure looks like this: Temp pH Cl2...

Referring to the post in General Question There is a list of numbers 1,1,1,1,1,2,2,3,3,4,4,5,5,5,5,5 from cell A1 to A16 Mode(A1:A16) = 1 However, if I...

I have 5 plus variables. See below for types of criteria. If the criteria meet certain conditions then it needs to sum all the appropriate values for that...

I am trying to sort info based on the most recent database it appeared in. Column A has the Master List, and outlying columns have other info. Column B has...

Hi, I want to make a nested loop. Or something to compare the value of cells. The first loop will step through all of the cells in column A starting with...