Summary: I have a spreadsheet with a column of formulas. These formulas have some variations from row to row but they all end with "$9880". I want to add a re...
Summary: You could use vlookup to control which row from your first sheet is reported on. Add a column to the left of your data in the first sheet and enter th...
Summary: I'm trying to covert a Lotus formula to Excel but have run into problems with multiple nested IF formula's (to many)... The formula works in Lotus but...
Summary: Hi All, I'm having a problem where Word or Excel 2007 are taking a long time to load. It's taking about 20 to 30 seconds just to load a document. So f...
Summary: Try this: - Select an empty cell - Hit Ctrl-c to copy it - Select the cells you are trying to fomat - Do Edit...Paste Special...Operation...Add Someti...
Summary: I am working with an Excel workbook that contains two sheets. On the first sheet, I have several columns of information about departments participati...
Summary: Please help. I want to use a date formula to find the difference between 2 dates. I know the formula but, when I apply it to a worksheet, a number app...
Summary: In my Outlook 2003, when I add a second folder to the Contacts and transfer people to it I want them to be in both folders, can I do this? Or how do I...
Summary: what formulae have you been trying? I don;t know about using a single formula to do this ...... but one way to do it is use the if function to determi...
Summary: I'm trying to add a star symbol to a Word 2003 doc. I've checked Insert>Symbol, Unicode and ASCII Hex and Decimal option and even Character Map. How c...
Summary: Excel is an amazing application and I am sure that what you want to do can be done but unfortunately, personally, I am unable to determine what it is ...
Summary: Thanks again for your help! May I know how could I go about merging this information from the same array (say, A1:D10) from three different worksheets...
Summary: A relative needs to replace their old pc which has failed. He has very poor eyesight and has been using a facility in Windows98 that allows for docum...
Summary: I have an excel file with one cover sheet and 500 tabs. Each of the 500 tabs represents one company using this company's name as tab name. I have exac...
Summary: After a little thought, I think a better formula to use would be: =A1-SECOND(A1)/86400 since 1/86400 is 0.0000115740740740741 not 0.0000115. ...
Summary: My suggestion would (probably) not back up sent emails, or anything the user did after receiving the message (such as sorting it to a folder). To conf...
Summary: We are planning a campaign to send either tech associates or removable media (CDs or flash drives) to client locations to set them up to use our websi...
Summary: First, let me say that I just edited my earlier response because I noticed that my example data didn't match in 2 sections of my post due to a typo. O...
Summary: Hi, OK, so you have two Excel workbooks which we can call A.xls and B.xls B.xls is a subset of A.xls You need to highlight all names in A.xls that are...
Summary: Hi, Here is a macro that will copy formating from a master workbook to a series of other, named workbooks. I haven't tested if page settings are copie...
Summary: I have been trying to use an IF statement to compare date/time entries in a report I am building (format = yyyy-mm-dd hh:mm:ss). Essentially there are...
Summary: Hi, can anyone recommend any kind of tutorial or demonstration that would help me create a stock control system on Access 2000? I'm a relative newcome...
Summary: The link below refers to Outlook 2003, but it works with 2000 also (or just Google search for pfbackup.exe). http://www.microsoft.com/downloads/detail...