I have a column of data in which recent test results are recorded. Column A specifies the shop and in column B the data is recorded in the format 'AARAGG'...

Is there a way to reference the nearest cell above the current cell that has text - distance is always going to be variable.

I have a question...... I used to be able to set-up an Excel template to "auto-name" the worksheet when I clicked "Save As". I had a certain cell in the...

I need a function that tests whether a cell containing multiple words includes certain text. For example, test for the occurrence of the string "alarm" and...

Hello, I have 2 worksheets. One with historical rents: it has 5 columns: A B C D ...

Hi all, i need your help with another formula column a..column b... column c....column d green..... banana... 1 5 orange... apple...... 2 ...

Hi, anyone know which key strokes are needed to insert curly brackets within a...

Not exactly sure how to describe it best. Just need a tally of the times a two different names in two different columns are on the same row. Thanks!

I have two colums that have simple sum and imsub formulas in them. They return a repeating number. I would like to have a simple 0.00 number in these cells....

Hi and thanks in advance. I have 2 columns of Data, A & B. Column A is a Named Range. I would like to lookup and format cells in cloumn B if the value in a...

If I have a column of data that I got using this formula: DATEDIF(B2,C2,"m") & " months " & DATEDIF(B2,C2,"md") & " days " & TEXT(C2-B2,"hh") & " hours " &...

I have recommended using --TEXT(...,"hh:mm") to ensure that the resulting time value is identical to the binary form of the displayed time value. But...

Hi , I`m currently using the following formula fine: =AVERAGE(IF(($H$10:$H$89=0)*($N$10:$N$89="W")*($AB$10:$AB$89-10),$AB$10:$AB$89)) This then selects only...

=IF(J1860,(J186-J198),(J128-J198)) How can I change this formula to make J198 an absolute value. Because if J198 is negative, it adds the number and I want...

I dl a timesheet template where the date is formatted to say Sunday, Monday etc. (Eg 40017 displays Thursday in column A5 and 23/07/09 in column B5) I need a...

I have two colums of data, the first is a time/date stamp in mm/dd/yyyy hh:mm format, the second is a rainfall amount (0.00). I need a daily total for the...

Background: I am compiling a simple depreciation sheet neccesary to feed a 5 year P&L. Depreciation method: 1)Simple straight line depreciation. Sheet...

Hi! I use Excel 2007, I need some help: 1-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting (changing color of...

Hi I have a series of numbers in column A. I need to add the letter B to the beginning of each. Can someone suggest some code to achieve this? Grateful...

I have an excel workbook that has several pages/tabs that then have several pages within. I want to be able to merge the entire workbook into one document...