[XSL-FO] How to read a file .FO/.FOB? [XSL-FO] How to read a file .FO/.FOB? Issue Solution 1 Solution 2 Issue The XSL-FO is a format description page like PDF or DVI usually... Nov 20, 2009Office Software |
Text String count within a Cell Text String count within a Cell Issue Solution Note Issue I have number of records (see below) and want to know if I can use a function... Nov 19, 2009Office Software > Excel |
How to split data into multiple worksheets? How to split data into multiple worksheets? Issue Solution Note Issue I hope someone can help! I have a .csv file open with excel that... Nov 19, 2009Office Software > Excel |
Cell input to call macro in adjacent cell Cell input to call macro in adjacent cell Issue Solution Note Issue I have a scenario that i'd like automated. The scenario is as... Nov 18, 2009Office Software > Excel |
Excel Arrow keys stopped functioning Excel Arrow keys stopped functioning Issue Solution Note Issue I am using Excel 2000. I am trying to move from one cell to another in... Nov 17, 2009Office Software > Excel |
Excel - Using IF statement to add 1 to total Excel - Using IF statement to add 1 to total Issue Solution Note Issue I am trying to get a formula to add + 1 to a total cell based on... Nov 14, 2009Office Software > Excel |
Excel Formula for cell calculation Excel Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the... Nov 14, 2009Office Software > Excel |
Excel - Comparing columns and returning value Excel - Comparing columns and returning value Issue Solution Note Issue I have an Excel spreadsheet where I want to compare values... Nov 14, 2009Office Software > Excel |
How to remove Hyperlink on copied text from website? How to remove Hyperlink on copied text from website? When copying information on website, obviously the hyperlink from the text will... Nov 14, 2009Office Software |
Not able to send mail from the Gmail outlook Not able to send mail from the Gmail outlook Issue Solution Note Issue I had configured Gmail in Outlook 2007. I am able to receive all... Nov 13, 2009Office Software |
EXCEL: The INTERSECTION function EXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the... Nov 13, 2009Office Software > Excel |
Excel - Extract identical cells of 2 columns Excel - Extract identical cells of 2 columns Issue Solution Note Issue Hello, Got a list of words in column A Got a list of words in... Nov 13, 2009Office Software > Excel |
Import CSV: bad alignment of dates Import CSV: bad alignment of dates When opening a CSV file with Excel containing a column of dates and they are not well aligned. It... Nov 12, 2009Office Software > Excel |
Difference between dates with the DATEDIF function Difference between dates with the DATEDIF function The Syntax Example Making use of: Notes The DATEDIF function is not documented in... Nov 12, 2009Office Software > Excel |
[Word]inverting a text(mirror effect) [Word]inverting a text(mirror effect) Though it is possible rotate the text with Word (icon text box, and format/ text orientation),... Nov 6, 2009Office Software |
Creating Shortcut key to merge cells Creating Shortcut key to merge cells Issue Solution Note Issue If there a shortcut to be pressed on the keyboard to merge cells in... Nov 6, 2009Office Software > Excel |
Excel Comparing cell A1 to entire A column in Sheet 2 Excel Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2... Nov 6, 2009Office Software > Excel |
Excel - IF formulas for Printing and Calculation Excel - IF formulas for Printing and Calculation Issue Solution Note Issue I am trying to get Excel IF formulas to print a text and... Nov 6, 2009Office Software > Excel |
Excel Macro for copy & paste selected range Excel Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data... Nov 6, 2009Office Software > Excel |
Excel Total Range of Values Excel Total Range of Values Issue Solution Note Issue I'm trying to get a range of values totalled. I have one set of columns, lets... Nov 6, 2009Office Software > Excel |