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...
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...
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...
Was at this years comic con at Excel London, was the first year for me to visit the event,
which turned out to be a good day!! Think tho next year id have to go in character :D
heres some of the photo form the day...
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...
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.
Any ideas bright sparks ?
A little bit of urgent help...
I have 3 tables in excel, all in the same format:
What I want/need to do, is merge the ID column, but keep the other colums distinct, so...
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.
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...
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
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...