Search results for query: *

Have you looked at the INTERCEPT function in Excel? Never miss an opportunity to shut up

=IF(A1="y",IF(A2="y",IF(A3="y",IF(B1=1,"Y",""),""),""),"")&IF(A1="y",IF(A2="y",IF(B1=2,"Y",""),""),"") Never miss an opportunity to shut up

Type a 1 in any empty cell. Copy it. Then highlight your whole data range. Paste Special and choose Multiply. Never miss an opportunity to shut up

To do this you need a chart that displays a secondary vertical axis. It should be easy to do that with your data. You can hide the secondary vertical axis by choosing axis options if you wish. Click a chart that displays a secondary vertical axis. This displays the Chart Tools, adding the...

Can you not just open up the dotx and then go to the office button and save as Template? Or am I missing something? Never miss an opportunity to shut up

Try copying all the sheets into a new Excel file and see if error persists. Never miss an opportunity to shut up

It seems to be related to a Nortel product on your system. You will need to sign up for their IT Toolbox discussion forum. I do not wish to become a member of Nortel user group, so that's as far as I got. Never miss an opportunity to shut up

You need to do this step again: [highlight #204A87]Then I saved it as a Quick Style Set HelloWorld101[/highlight] Never miss an opportunity to shut up

Aziz I could not fathom what you are trying to ask. At least for someone like me, could you make it simple? Never miss an opportunity to shut up

I used to say minimum 10%; but lately as applications get smarter I have upped the figure to 15% minimum. Basically, the re-pagination takes up a lot of room on your hard drive whereby slowing down the response or "seem" to crash while it is doing all it's switcheroos. A lot of the times if the...

If Justin's solutions have not worked, then it is likely a registry proble. Please look at this article . [highlight #CC0000]Caution: if you have not used registry settings before; I would suggest asking an expert.[/highlight] Never miss an opportunity to shut up

First of all check to see if you have enough hard drive space .... At least 15 to 20% of total. Then, if that's ok, we might have look for solutions. Never miss an opportunity to shut up

You can go to File, Options, General and turn of the mini-toolbar pop up. Caution: it will turn off for all purposes. Never miss an opportunity to shut up

You can also go to Regional settings in Control Panel. Under the Format tab click on "Customize this Format..." or "Advanced Format"....or whatever it is for your OS and change the list separator to a pipe symbol. Close. Open Excel file and save it as a CSV file. It will be saved as a pipe...

Make sure print settings for all ws are the same. Most likely the dpi setting for sheet 3 is different from the rest.

I am not sure if I am missing something here. Can you not send it as a PPS file? Avoid Hangovers. Stay drunk.

First, try repairing the Excel file. It may be corrupted. The info to repair a file is available under Help in Excel "Repair a corrupted file" Avoid Hangovers. Stay drunk.

I have yet to come across a file that cannot be deleted. If you or anyone in your organization knows DOS commands, it takes only a few seconds to delete the file. You really only need to know CD and DELETE commands. Also, you can try to change the user name on another machine to that of the...

There should be a temp file on the network that excel created. Most likely it will be xxxxxxx.tmp type of file. If you delete that, you should be able to access the original file. Might not be bad idea to delete all *.tmp and ~*.* files on the network drive. Avoid Hangovers. Stay drunk.

If your data is in cell A2, then =TRIM(SUBSTITUTE(A2,TRIM(LEFT(SUBSTITUTE(TRIM(A2)," ",REPT(" ",99)),198)),"")) should extract any text after the second space To find last word in any string (I have tried only to 5 words) =IF(ISERR(FIND(" ",A2)),"",RIGHT(A2,LEN(A2)-FIND("*",SUBSTITUTE(A2,"...