I have in sheet 1, cell A1 a date which says Jun-2005 (the cell format is mmm-yy and this date is linked to another diff sheet) Because the date in cell A1...

In sheet 1 cell A1 i have a date that is generated from another sheet, the date in this cell reads 'Jun-2005' (The cell is in mmm/yyyy format) In cell B1 I...

I have in sheet 1, cell A1 a date which says Jun-2005 (the cell format is mmm-yy and this date is linked to another diff sheet) Because the date in cell A1...

I have downloaded and installed the morefunc add in and i am currently able to use the indirect.ext function as required. However, when i send the file to...

Hi If in cell A1 I have a month name for example: 'January' In cell D1 i want to say, if the month in cell A1 says 'January' then add a month and show...

In column A I have 1000 rows of text.Within each line of text in this column is a 5 digit number that is at different points within the text. Is there any way...

I have a spreadsheet in sheet 1, cells A1 to L1 show months of the year. In rows A2 to L50 there are numbers. In Sheet 2 I want to create a sheet whereby the...

In XP Excel I have 13 worksheet tabs, one for each month and 1 for a summary. On Summary tab I have 12 columns with the month name in each as written on the...

can you help please? i have the following cell C3 = data validation from a fixed range (5 drop down options) cell C6 = data validation drop down - the choice...

Hi, I have a query on some data i'm currently analysing and it's causing me a headache. I'm hoping there is a simple solution to this that doesn't involve...

Hello all If anyone can help me with this query i'd be very grateful. I'll try and explain it as simply as possible. I have the following data. Columns A,...

I am trying to get a cell to act how Microsoft Words deals with web address. For example writing. www.bob.com in Word would link that to the website, chnaging...

Just wondering if I could automatically change a graph. For example I do a number of graphs for every month, obviously days of the months changes so on a...

I have a worksheet with multiple columns. I want to add all the values in the amount column that equal certain information in 3 of the other columns...in...

Is there a way to take a pivot table and 'unpivot' it back to a normal spreadsheet?

Using the 'rows to repeat at top' field of page setup, is there a way to print non-connected rows (i.e. rows 1, 2, 5, & 6)? The formula only allows for...

Hi Gents... First post here! I have a staff list in Excel where each employee has either IN or OUT stored in a cell relating to each day of the week... I...

Dear Experts, I've a table of data and wonder whether or not it's possible to use Vlookup or Hlookup to find and list multiple rows of matching records....

My problem sounds simple if you say it, however I am very new to Excel and can't figure out how to do it. I have numbers 1 to 18 in a column A. Column B can...

I have a column, with both positive and negative numbers. I want to know how to have Excel count the positive numbers and then devide by the total number of...