| Thread | Last Post | Replies |
|
| Print Visable Data Only | 26 Apr 2007 13:56 GMT | 1 |
I am currently producing a worksheet which presents the number of
outstanding errors that are produced by a group of around 200 people. The
data is in a pivot table, but this is hidden as the layout is too rigid in a
pivot table. From the drop down I can select any area of the ...
|
| Look Up help (repost) | 26 Apr 2007 13:21 GMT | 2 |
Given the following sample data and layout:
"data" sheet items sample
A B
1 1 1
|
| Total the highest 5 of 8 amounts. | 26 Apr 2007 12:32 GMT | 2 |
I need a formula to total the highest 5 out of 8 values. please help me.
|
| "Help | About" in Excel 2007 | 26 Apr 2007 11:53 GMT | 2 |
I spent some time looking for it today, but I couldn't find it.
Has the "About Microsoft Excel" screen been removed, or if not then
where is it?
|
| IF(INDIRECT ? | 26 Apr 2007 07:55 GMT | 3 |
Hi hope you can help!
I have a number of copies/versions of the same spreadsheet (layout)
which I now have to do a column content count on ie
=countif(A1:A100,"A")
|
| Re-post Didn't appear first time | 26 Apr 2007 07:38 GMT | 1 |
Hi hope you can help!
I have a number of copies/versions of the same spreadsheet (layout)
which I now have to do a column content count on ie
=countif(A1:A100,"A")
|
| FIND SPECIAL CHARACTERS | 26 Apr 2007 07:21 GMT | 3 |
I am trying to find character "*" and replace them in my spreadsheet.
However, whenever I did, all were replaced.
Is there a way of typing in order that the program know I am actually
searching for the character "*" only ?
|
| Can I use the named range in the following way? | 26 Apr 2007 06:41 GMT | 1 |
I defined a cell named range:
Let's call the cells A1 to A5 to be "trytry".
Then in another cell, I enter "sum(trytry)", I will be able to get correct
result.
|
| if statement help | 26 Apr 2007 04:30 GMT | 3 |
Looks like this
Adam 1
Smith 2
Johns 6
|
| how to log in to office online | 26 Apr 2007 02:38 GMT | 1 |
how do access my microsoft office basics.
have tried through msn and cannot get on.
thank you
|
| Selection Transparency | 26 Apr 2007 02:30 GMT | 1 |
I just started using Excel 2007, and I am having trouble actually seeing the
range of cells that I am selecting when I click and drag my mouse. Does
anyone know if there is a way to make the selection darker and more visible
like in Excel 2003? I have searched the options and ...
|
| Re-ordering Rows | 26 Apr 2007 02:10 GMT | 1 |
I am using Excell 2003.
I have a range of cells that are sorted thusly
Col1 Col2 ... Coln
-------------------------
|
| File comparison | 26 Apr 2007 01:38 GMT | 1 |
Folks:
I have 2 separate Excel files. Each file contains about 100 symbols. I would
like to run a quick COMPARISON
the content of these 2 files in order to identify those symbols words that
|
| alphanumeric sorting | 25 Apr 2007 23:20 GMT | 3 |
I got this data in a column:
100A
100B
100C
|
| Concatenting dates..the correct format, please | 25 Apr 2007 22:30 GMT | 4 |
I have two date fields that I need to concatenate
for example
A B
1 Start Finish
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread