Results 1 - 20 of about 136
[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, let’s...
Nov  6, 2009Office Software > Excel
12 3 4 5 6 7