excel

Friends Can you help please? If in excel I have a block (columns & rows) of cells that are all pointing another sheet (In this instance a monthly sheet) Is there a way that I can easily change the address that these cells point at without changing any of the rest of the formula? I want to...

Long shot. Is there any way to by-pass a paswsord on an excel spreadsheet at all? Fingers crossed.

I have a Garmin golf GPS thingy (Approach G6) which stores lots of data on each round. Lots and lots and lots of data. It also has a rudimentary scorecard viewer which only works in Internet Explorer (PC version) and doesn't show putts taken or fairways hit, data which is stored in the G6...

Hi, Could some kind member help me to produce a spreadsheet which would enable me to record which CCTV Cameras are working.:confused: My needs are Column 1 Camera numbers 1 upto 300 Column 2 Camera Location Column 3 Working Y / N ( If possible I would like it so that the column defaults to...

Is there a way to combine INDIRECT and direct cell references? In the current workbook I want to reference the same cells in different workbooks, for example:- In cell B10 of the current workbook I want the contents of A DIFFERENT WORKBOOK Sheet1 G22 The DIFFERENT WORKBOOK will change...

to any excel wizards out there, i need to write a user defined function in excel 2010 that takes two inputs, the upper and lower range and then solves a sextic equation with real coefficients. ie between the limits of 8>x>1 solve x^6-7x^5+4x^4-14x^3+12x^2-5x+23=0 its really doin my sweed in...

A problem has occurred since my upgrade to lion. When I open a word or excel document, t doesn't open the one I'm after but the last one I looked at. But if i chose the open document and then close excel it works ok, looks like an issue with the open save new app

I have a few excel data problems that I need assistance with, would anyone be able to assist please? Basically (for now) I need a digit adding to the front of a 22 digit number and another digit removing within the number. The numbers are all in column A and there are over 14000 of them, it...

Hi folks, I have two dates in this format... 04/01/2010 08:20 and 11/05/2010 11:15 Need to work out the difference between them in minutes. Then when I have got the minutes value work it back so it show its in months, days, minutes. Crikey !!! Any ideas bright sparks ? Gary

Howdy! A little bit of urgent help... I have 3 tables in excel, all in the same format: ID, Value (e.g. MATH: Alice 2 Bob 1 Cheryl 3 ENGLISH: Alice 1 Doug 5 FRENCH: Bob 2 John 1 ) What I want/need to do, is merge the ID column, but keep the other colums distinct, so...

Hi My brother is looking to buy a Mac and has been told that Microsoft Excel: Mac can't do Macro's is this true? And if so, is there anyway around it? Many thanks Tan

Hi all, I was wondering if an Excel expert on here can help me with something I need to do for a report. One worksheet has multiple columns of data. I want to be able to filter the data and transfer it to a fresh worksheet so I can put some fancy formatting so it can be used for a...

Any experts out there? I want to change the fill colour (to custom colour RGB 5,255.5) of cell range A1-A10 if the contents of cell A9 is the word 'Green'. I'm almost there but can't quite get it. I know how to change the cell that the word is in using Conditional Formatting. The formula...

How would I go about turning an html page into an excel spreadsheet? Anyone?

Now I consider myself pretty expert at Excel, but.... I've got Excel 2003 (SBE), and when you first open it, you get a blank worksheet, entitled 'Book1'. When I open a saved worksheet, that 'Book1' should disappear, but it doesn't. So if I've got three worksheets open, I actually have...

We have some turnover data in a column in Excel, and have drawn a simple line graph to represent it. Which of the trendlines should we use to predict future turnover? Thanks,

Does anybody know if it is possible to sort data in an Excel column alphabetically from the right? Thanks!:D

I have 2 cells, A1 and A2 I would like to initially enter a figure into A1 with the end result that the VAT element is displayed in A2 and the the net value is in A1 E.g. By intitially entering £10.00 in A1 the end result would be £8.51 in A1 and £1.49 in A2 Many thanks!

Does anyone have knowledge on how to create a sum that will calculate a column of time. the format is HH:MM:SS. Basically I've exported my Carphone Warehouse bill and I want to be able to check the time totals within allowance, over allowance etc etc. I cant seem to get a sum function that...

I have been invited to the preview night on Wednesday 19th July (and no idea why), is anyone else going?