|
|
Removing Special Characters by
Cathy Landry
Hello,
I exported to Excel 2003 my Outlook Calendar and now I have a lot of odd
little square characters that I cannot remove. Any suggestions...
|
|
2 |
142 |
|
|
macro shortcut help by
ericaamousseau
Hello I have a Macro set up in spreadsheets I have made for multiple people.
I have set it up so they can paste the info needed in a worksheet and then
use...
|
March 23rd, 2010 07:01 PM
by tompl
|
1 |
112 |
|
|
|
|
6 |
124 |
|
|
|
|
5 |
152 |
|
|
SUMIFS using a text rage by
Ziggy
I am still trying to make the conversion from 2003 to 2007. In
particular I'm trying to understand the SUMIFS since they are more
efficient than arrays. I...
|
March 23rd, 2010 05:41 PM
by Ziggy
|
0 |
109 |
|
|
SUMIFS using a text rage by
Ziggy
I am still trying to make the conversion from 2003 to 2007. In
particular I'm trying to understand the SUMIFS since they are more
efficient than arrays. I...
|
March 23rd, 2010 05:41 PM
by Ziggy
|
0 |
141 |
|
|
Date Format by
DaveMoore
A date has been entered in cell E4, 31/03/2010 but has been formatted
so as to display as MAR-10. That's okay, that's what I want.
I now wish to refer to that...
|
|
1 |
124 |
|
|
Column Average Given 2 Criteria by
AAA1986
I want to get the average for a certain column, given 2 different criteria.
Right now I'm using this formula for one...
|
|
4 |
123 |
|
|
annualize sales for remainder of year by
Kelli
I have a figure for YTD Sales and am trying to calculate estimated annualized
sales off of this. And, this will change monthly as sales managers update...
|
March 23rd, 2010 04:48 PM
by Kelli
|
3 |
133 |
|
|
Lookup on a combo box by
dp_amsafe_elkhart
I have a combo box in cell C2, with facility locations in it. In another
cell i want to either have an if statement if it matches the name put in an...
|
|
1 |
112 |
|
|
Lookup 2 values to return 1 by
Sarah
Does anyone know if you can combine and IF, AND, and VLOOKUP. I need to
lookup 2 different dates in a table and if both of those dates appear on one
sheet,...
|
March 23rd, 2010 04:05 PM
by Sarah
|
9 |
115 |
|
|
Link an entire Row with a Key Word by
Link an Entire Row with a Key Word
I have an excel document that has thousands of rows, but only 3 columns. I
need to know how to link over the whole row of data if a single word is used
in...
|
|
1 |
97 |
|
|
IF Multiple Conditions by
LJ
A B C
D E
Color Total Time Total Time 2 Time Allowed Y/NO
BLUE 1:22:33 2:22:33 ...
|
|
2 |
110 |
|
|
date format error in cell by
pat67
I have one cell that for some reason even though the format is set to
general, when i put in say 2007-2011 i get a pop up box that says date
format error. the...
|
March 23rd, 2010 03:14 PM
by pat67
|
1 |
112 |
|
|
|
March 23rd, 2010 02:46 PM
by rip1956
|
0 |
112 |
|
|
HLOOKUP into another xls file by
Paul Dennis
=HLOOKUP(Summary!F7,'Wk43'!$N$3:$S$3,1)
The above works, however sheet which is WK43 in this example and the
workbook changes everyweek hence I need to...
|
March 23rd, 2010 01:24 PM
by Max
|
1 |
124 |
|
|
|
|
1 |
142 |
|
|
DATEDIF FUNCTION NOT LISTED IN HELP by
Asoka Walpitagama - Brandix College IT
Should you not include DATEDIF function in the Excel 2007 HELP.
Its not listed even under the FORMULAS -- DATE & TIME FUNCTIONS
Is there any reason...
|
|
2 |
128 |
|
|
|
|
0 |
113 |
|
|
How to sort duplicates? by
J.Scargill[_2_]
Hi,
I have a Year to Date summary sheet with a long list of 18 digit barcodes in
column F that increases weekly as data is sourced from our staffs individual...
|
|
0 |
108 |