/m2205

The sheet name can be accessed through the filename function.

I can't get on excel to give you the excact format but you should be able to find the exact format on the web somewhere. If I can get on Excel I will find it for you.

That would give you a generic reference to the sheet name that can easily be copied.

Good luck
Richard

/m2206

If the addresses are stored as a string in one cell you can use the Excel filter function. It has an option to filter but leave only unique records.

Otherwise, you may be able to do something with conditional formatting if the addresses can be sorted into an sensible order.

Richard

My query is what can cause the excel links to not work properly. I am currently refering cell B2 to A2. A2 has returned an answer of $35000. But B2 is not reflecting $35000. Instead the value is something completely different. I am not performing any other operations or function in B2 like add, subtract, or anyhthing- it's a simple reference to the previous cell.
I will greatly appreciate help with this

Assuming the formula is =A2, try recalcing the spreadsheet.�A;�A;�A;�A;�A;�A;�A;________________________________�A;From: QT - Neha <qtopic-27-tHAhkTQwWtmq@quicktopic.com>�A;To: QT topic subscribers <qtopic-subs@quicktopic.com>�A;Sent: Tuesday, 28 April, 2009 2:24:40�A;Subject:Help with Excel functions (www.meadinkent.co.uk)�A;�A;--QT-------------------------------------------------------------�A; Reply by email or visit�A; http://www.quicktopic.com/27/H/tHAhkTQwWtmq/m2213�A;--------------------------------------------------------------- -�A;�A;My query is what can cause the excel links to not work properly.�A;I am currently refering cell B2 to A2. A2 has returned an�A;answer of $35000. But B2 is not reflecting $35000. Instead the�A;value is something completely different. I am not performing�A;any other operations or function in B2 like add, subtract, or�A;anyhthing- it's a simple reference to the previous cell.�A;I will greatly appreciate help with this�A;_________________________________________________________________�A;To unsubscribe: http://www.quicktopic.com/27/X/tHAhkTQwWtmq�A;Start your own topic in 20 seconds: http://www.quicktopic.com |QT�A;�A;�A;

I am trying to create spreadsheet that has start time in column a, ending time in column b. column c heading is 8:00 am, column d heading is 8:15 am, column e heading is 8:30 am, etc.... through to 9:00 pm. I want to create a fomula to place a one in a cell if the times in columns a and b occur. If a start time was 8:00 am in column a and ending time was 8:45 am in column b, then there would be a 1 in columns labeled 8:00, 8:15, 8:30, and 8:45. The other columns should have a zero in it. Would really appreciate some assistance. Can you help?

/m2215

Hi Jerry,

You should be able to do this with an IF function. Something on the lines of...

=if(and(C$1>=A$1$,C$1<=B$1$),1,0)

Unfortunately I don't have access to Excel at the moment so I can't check the formula but it should give you the idea of how to achieve the result you want. Good luck

PS you could also add some conditional formatting to give the sheet some graphicalk impact as well.

I want to work out the gross profit we make on an individual job.
A1 = cost to client (the amount we invoice for) e.g. £4200
A2 = what our actual cost was e.g. £3150

What formula do I use to work out the gross profit on this job.

/m2217

Hi Margaret,

In A3 you could put =A1-A2

Good luck.

Hi Richard

I wasn't clear in my message 2217. I want to work out the gross profit as a percentage not as a straight figure.

/m2219

Hi Margaret,

Then =(A1-A2)/A1

Format the cell to show the answer as a percentage.

Good luck

Hi, I'd want to create a chart that shows 5 people's names with what they did over 3 (financial) years together i.e. Apr06-Mar07; Apr07-Mar-08;Apr08-Mar09 for every person.

Thanks

/m2221

Hi Julie,

I would suggest that, if your data is already organised, that you try the chart wizard. Where this is depends upon the version of Excel you are using but once you find it, it is good at getting basic charts working.

HTH

Richard

Hi,

I'm using your (very) useful macro to export to XML from Excel, is it possible to end if the next row is empty?

Thanks

Edited by author 23-06-2009 11:25 AM
i am unable to find any solution for converting number to words in excel.
so please help me sir. plese send the solution on my Email ID-udekara@yahoo.com

/m2224

There is no function in Excel to do this. So you will need some VBA to do it. Try this:

http://www.ozgrid.com/VBA/ValueToWords.htm

Good luck

I'm having trouble with a spreadsheet, hope you can help, because I'm stumped. In my case, if I enter a formula in a cell, the formula is shown in the cell, rather than the result of the formula entered. I've never seen anything like this. I can go to another column and enter the formuala, and see the appropriate results, but for some reason I have a number of columns that are displaying this problem. Seems like some kind of formatting issue, as I can drag a column that reflects the appropriate results using a formula, and drop it over the problem column, and everything is fine. Weird.