|
|
Text Report to Spreadsheet by
cindee
Hello! I have an excel spreadsheet that came from an
Accounting report that was laid out like this:
CUST0099
INV9880 09/06/02 1456.09
INV9767 09/01/02 ...
|
|
1 |
95 |
|
|
|
|
1 |
258 |
|
|
Countif Function by
Joe
I'm trying to count the number of cells that are greater
than "26 wks". When I use Countif(S3:S82,"=26 wks") I
also get the cells with 3 wks, 4 wks, 5 wks, 6...
|
|
1 |
108 |
|
|
Adding user-defined function in Excel2002 by
jimlyke
Stupid question, but how DO you add a custom function in
the new Excel? I used to rarely do this in older
versions, but I cannot seem to make it work now. Is...
|
|
3 |
110 |
|
|
Lottery check by
IanF
Hi,
I am in a lottery sindicate at work and we purchase
numerous entries (lines) for each draw. I need a way to
enter the latest draw and let it lookup the...
|
October 3rd, 2003 05:37 PM
by Biff
|
2 |
104 |
|
|
Functions by
Dawn
I have a spreadsheet done. Column D will let be marked
with an X if need to be ordered. Column E has price of
said product. I would like the total to be at...
|
October 3rd, 2003 05:38 PM
by ray
|
2 |
104 |
|
|
Functions by
Dawn
Thank you guys sooo much!! I am sooo relieved :)
Dawn
|
October 3rd, 2003 06:09 PM
by Dawn
|
0 |
135 |
|
|
Pivot Table Sorting Help by
nicholjl
I exported payroll data from Quickbooks into Excel and it went in as a
Pivot Table. I have several columns, the first being Soc. Security
Number and it is...
|
October 3rd, 2003 06:17 PM
by Liz
|
1 |
111 |
|
|
|
October 3rd, 2003 06:34 PM
by Biff
|
2 |
232 |
|
|
Functions applied to filtered cells by
Debra Dalgleish
I don't see your screen shot, but you can use the SUMPRODUCT function to
calculate visible cells after a filter has been applied. For...
|
|
3 |
495 |
|
|
One More on Date Function by
Kreiss
Everybody that helped me in my previous question was a
great help....thanks!
Now, I have this and it...
|
October 3rd, 2003 07:17 PM
by Kreiss
|
1 |
101 |
|
|
Still trying to find the "MAX" by
Joe
Bob,
It does work when using the same format of the cells ie..
2 wks, however some of my cells contain "stk", "stock"
and 0 (zero) and I need to keep these...
|
|
3 |
121 |
|
|
|
October 3rd, 2003 07:24 PM
by ray
|
1 |
384 |
|
|
|
October 3rd, 2003 07:56 PM
by Dave
|
9 |
351 |
|
|
delete blank rows by
steve
What is an expedient way to search an excel worksheet,
find and delete blank rolls withouthaving to manually
scroll through the blank rows.
|
|
1 |
102 |
|
|
random by
sj
I am trying to set up a worksheet to randomly sellect a
certain percentage of itmes from a list. I need to slect
text data, and I need to be able to change...
|
|
1 |
77 |
|
|
auto filter/ status bar by
ryan
when using auto filter how do you get stats to appear on
the status bar (ex. 56 of 100). some of my worksheets
have it while others say "filter mode"
|
|
1 |
309 |
|
|
Excel 2002 by
Mary K.
While hiding some columns in a worksheet, I accidently hit
save. How can I unhide the columns and retrieve all the
data.
|
October 3rd, 2003 09:14 PM
by ed
|
2 |
108 |
|
|
excel function by
Dick
In Excel is there anything like the Range Value command in
Lotus which I used to blow away a range of cells' formulae
while leaving behind in the cells the...
|
|
2 |
95 |
|
|
|
October 3rd, 2003 10:04 PM
by ed
|
7 |
373 |