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 |
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 |
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 |
Excel - Tasks to be performed automatically on particular dates Excel - Tasks to be performed automatically on particular dates Issue Solution Note Issue I have a huge spreadsheet and I am constantly... Nov 5, 2009Office Software > Excel |
Excel Macro to detect and hide blank rows Excel Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the... Nov 5, 2009Office Software > Excel |
[Excel]changing cell formula to text [Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula... Nov 4, 2009Office Software > Excel |
[Excel]Reset/replace seconds to zero [Excel]Reset/replace seconds to zero Issue Solution Notes Issue I have an Excel 2007 file which has in sheet1 the time people connects... Nov 4, 2009Office Software > Excel |