-
Excel - Macro to search and replace
I have two workbooks with identical setup. item name address 1 address 2... Read more
ExcelMay 12, 2010 at 05:50 AM -
Excel - The LEFT function
[Excel] The LEFT function This function allows you to... Read more
ExcelNovember 21, 2011 at 12:11 PM -
Excel - Remove #Value error message
How to remove the #Value error while leaving the formula in cell? The... Read more
ExcelDecember 8, 2011 at 05:02 AM -
Excel - Create drop down list on certain cells
I wanted to create a drop down list from data in Sheet2. I have tried the... Read more
ExcelOctober 3, 2012 at 04:28 AM -
Excel - Delete certain cells of active row
I would like a code for the following: Check which row is... Read more
ExcelMarch 6, 2010 at 05:18 AM -
Excel - Filter data through a formula
I need a formula of the following quotation: Column A Belongs To... Read more
ExcelFebruary 11, 2012 at 07:12 AM -
Quickly create a simple holiday schedule
Here's a simple tip on how creating an Holiday schedule. A1: Enter... Read more
ExcelJune 19, 2009 at 05:35 AM -
Excel - VLOOKUP to filter rows based on numbers
I have list of Incident numbers (both Closed and open) in Column A and only... Read more
ExcelMarch 23, 2010 at 08:02 AM -
The logic functions
A short explanation on the use of the following functions: IF, AND, OR,... Read more
ExcelAugust 26, 2013 at 06:44 AM -
Excel - Formatting Individual characters
Generally, formatting options covers whole cells (all of the contents).... Read more
ExcelOctober 31, 2012 at 09:15 AM -
Repainting a cell using excel VBA
I am writing a code in excel VBA to generate a report.I am totally new to... Read more
ExcelNovember 4, 2009 at 12:56 AM -
Excel - Changing cell formula to text
Consider that I have: In cell A4, it contains a formula... Read more
ExcelMarch 22, 2012 at 10:43 AM -
VBA - Setting the AutoFilter function
I have a problem with a macro, I want apply a filter on a field so that when... Read more
ExcelSeptember 12, 2011 at 11:20 AM -
Excel - Input mask issue
I would like to assign a custom input mask to a textbox like... Read more
ExcelApril 26, 2012 at 07:36 AM -
Excel - The DEGREES function
Under Excel the angles are expressed in radians. To convert them to degrees,... Read more
ExcelJune 20, 2012 at 12:00 PM -
Excel (all versions) - How to copy a simple formula?
To copy a simple formula over a wide range of cells (columns and/or rows),... Read more
ExcelJuly 16, 2013 at 05:24 AM -
Import file names in Excel
I have a folder with a series of Outlook files (with the .msg extension),... Read more
ExcelOctober 15, 2014 at 04:00 AM -
Excel - The TRIM function
The TRIM function removes all empty spaces in a text string, except those... Read more
ExcelNovember 15, 2011 at 11:05 AM -
Excel - Copy and paste values from specific columns
I want to, copy/paste values on the specific column based on cell A2. i.e. ... Read more
ExcelJuly 30, 2012 at 08:28 AM -
Excel - The FIXED function
This function will return as value, a text representation of number rounded... Read more
ExcelNovember 15, 2011 at 11:12 AM