Search results

As Shades suggests, this is possible, and there are a couple of ways to do it, one has a lookup table to take the required condition and the ColourIndex you wish that condition to change to. Although in theory you can display 65k colours in Excel, in practice it's limited to a (adimittedly...

Try typing "'http://" instead. ie. put a ' at the start.

My home server reports NTFS too, it's actually an ext3 journalling :) No, if you don't know, I'm sorry I can't help !

So what is the server ? Windows NT 3.5 ? A flavour of Linux ? Novell ? Or is it a workgroup environment ?

Problem is you will have lost any leading zero's. You could try storing all telephone numbers in international format, but I haven't tried this so it may cause you as many problems with a "+" at the front.

I assume the 'shared' file is on a server ? Do you know what server ? Sometimes (normally quite rarely) the local worstation and the server get out of sync. When the workstation opens the file it tells the server and the server puts a lock on the file, if something happens at the workstation the...

I assume you enter your status number on the overview sheet ? I assume there is a "key field" so we can identify which row to remove on say sheet 2 when it's status becomes 3 ? I assume there is validation such that blank, 1, 2, 3, 4, 5 only are accepted ? If yes and yes and yes then you could...

You don't say what you actually want to do. Does a user in India enter their currency in rupees and it gets coverted to dollars. Or do you just want them to have their reports in rupees ? If it's the former you have a problem with fluctuating exchange rates (most internationals have agreed...

Okay ... test data ???

Clive2002 It would be nice if you could actually send some test data, i.e. you could paste the areas into word as tables instead of pictures, better still zip the XLS and post that. de-normalise is not a real word but I think we get your drift, in fact if the data were normalised and residing...

Oooh Oooh Oooh, I wanna change my vote, I'm going with the following list ! 1. Merged Cells (thanks Rich !, that's so ... irritating, what's wrong with centre across selection ?) 2. Cells formatted White 3. Anything to do with 'Page Break Preview' 4. Removal of Row & Column Headers 5. People...

You consider that Plush ? That is usually one of the first things I get rid of when someone sends me a workbook. Another "pet hate" is when they format cells white to get rid of grid lines instead of just turning them off.

Say you put =A2 in A3, then drag it down as far as you like. Now you have the value of A2 in ALL of these cells. Say you want to put "Orange" in cell A6, you now have "Orange" from A6 down. Now you put "Apple" in A9 you now have apple from A9 down.

Try This :

I'd use copy, paste special, transpose ...

If you had the 12th of January and you subtracted 1 month you'd expect to get the 12th December, so when you have the 30th how is the formula supposed to know you want the last day of the month instead ? If you DO want the last day of the month (in each answer) I think you'll need a UDF (User...

Surely not !!! ;) That would be cheating :eek: a_20120/tanha is still gonna have to wait for the code though :D

To ensure you get the 'best' solution for your problem, you should always include as much information about how your data looks. So an additional question would be "does it always end in a "core3" ?" This would make the formula easier as you could say =LEN(A2)-5 to know where your second comma...

Record a macro, do it, then read the macro. How else are you gonna learn ? :D

You don't say if your first "xxxx" are always 4 characters. I have assumed they are but if not the formula will require another 2 find elements, you should be able to work that out for yourself given this. =MID(A2,6,FIND(",",A2,6)-6)