Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. xlhelp

    Creating Data Point on Line chart where 2 Y Axis' cross over

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

    Excel 2007 If Then Formula Help

    =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
  3. xlhelp

    Excel 2010 - $123 to Number

    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
  4. xlhelp

    Line chart with 2 X Axis

    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...
  5. xlhelp

    Adding a new Template`

    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
  6. xlhelp

    Unrecoverable Errors with Excel on the increase... Tables at fault?

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

    ERR5061 clock sync

    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
  8. xlhelp

    update changes in style set

    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
  9. xlhelp

    update changes in style set

    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
  10. xlhelp

    Windows & Microsoft applications crashing

    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...
  11. xlhelp

    Windows & Microsoft applications crashing

    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
  12. xlhelp

    Windows & Microsoft applications crashing

    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
  13. xlhelp

    Annoying tool widget popup in Word2013 when setting a form control

    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
  14. xlhelp

    Convert 2013 Excel Document to Pipe-Delimited Format

    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...
  15. xlhelp

    Weird Excel issue that prints the third worksheet separately?

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

    How do I make a PowerPoint presentation stand alone?

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

    PowerPoint Errors With linked Excel information - 2003

    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.
  18. xlhelp

    Close file on network drive opened by another user

    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...
  19. xlhelp

    Close file on network drive opened by another user

    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.
  20. xlhelp

    extract string from right till the space

    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,"...

Part and Inventory Search

Back
Top