|
|
|
|
6 |
131 |
|
|
Sorting by
teh_chucksta
how can I sort a column with numbers and text in descending order where the
text falls to the bottom and not the top?
thanks,
charlie
|
May 15th, 2009 05:55 PM
by Mike H
|
2 |
99 |
|
|
numbers and macros by
Evil with a K
I have a couple of questions regarding managing the enormous amount of data I
see everyday that I simply cannot find a way to execute it in an excel Macro....
|
|
3 |
103 |
|
|
VLOOKUP by
Gary T
I'm trying to find exact matches from Sheet 1 to Sheet 2, and to show a zero
value if there is no match. Can't seem to get the formula...
|
|
2 |
89 |
|
|
|
|
3 |
111 |
|
|
Sumif / Countif by
Blue
Hi
is there any way that i can use 2 arguments for sumif & countif functions
instead of just 1?
--
Lois
|
|
3 |
73 |
|
|
|
|
4 |
98 |
|
|
COUNTIF: criteria is a format by
alligatormaki
I have a column with cells that have text of different colors. I'm trying to
count up the number of cells that the text is formatted a particular color. ...
|
|
2 |
89 |
|
|
Disabling copy/paste hidden cells by
Shawn
There is an odd quirk between Excel and Outlook in that if you copy a range
of filtered data and past the table in an Outlook e-mail and send it out, in
the...
|
May 15th, 2009 01:15 PM
by Shawn
|
2 |
89 |
|
|
|
|
1 |
136 |
|
|
|
|
1 |
108 |
|
|
Data manipulation help by
Brian[_16_]
Howdy all,
I have employee records with corresponding image files list all in Column A.
Each employee record is proceeded by the word BEGIN:, then SSN, NAME,...
|
|
9 |
136 |
|
|
|
|
1 |
72 |
|
|
Increased percentage question by
Brian
I am trying to determine how to go about generating a formmula for Excel
which will assit in working out a percentage increase.
The scenario is as...
|
|
3 |
81 |
|
|
Return Formula by
willemeulen[_5_]
I constructed a lookup table with formula's on the second sheet which I
want to use to return a working formula on sheet 1.
Example Shape Code 39:
Formula...
|
|
8 |
176 |
|
|
|
May 15th, 2009 09:48 AM
by ECH123
|
2 |
88 |
|
|
Macros by
JulianB
I have set up a macro in excel 2003, however, i can't run it in excel 2007. I
get many messages. "Save as *xps???? The dedug shows "print out" as my...
|
May 15th, 2009 07:01 AM
by Kassie
|
1 |
106 |
|
|
|
|
2 |
83 |
|
|
How do I locate a circular formula? by
Di
I have a workbook with more than 30 worksheets. Each time I open the
workbook I get the alert, "Microsoft Office Excel cannot calculate a formula.
There is...
|
|
2 |
81 |
|
|
|
|
1 |
83 |