|
|
Final attempt save as binary question by
Kevryl
This is about my fifth attempt since March, so far without eliciting a single
reply (last attempt seems to have disappeared into the ether):
Re Excel 2007...
|
June 1st, 2010 07:17 AM
by Kevryl
|
6 |
390 |
|
|
Date Related Query by
sandy
hi need help again....
I have this Data
Date Submitted On-Time
3/14/2010 x
5/29/2010 x
3/12/2010
I have to count the number of on time...
|
|
1 |
321 |
|
|
Undeletable mark--amazing properties by
Don_Texas
A mysterious, undeletable mark appeared in an Excel 2003 spreadsheet. It looks like a forward slash, but half-length and more sloped (45-deg.). It won't...
|
|
0 |
464 |
|
|
|
June 1st, 2010 02:01 AM
by FSt1
|
1 |
380 |
|
|
Input box to find date by
Tom[_55_]
Hi,
As part of my macro, how can I make an input box (or whatever box) to
pop up and ask the user to input a date - e.g. 25/06/2097? On
clicking OK, it then...
|
|
4 |
417 |
|
|
I want to add or subtract a range of cells by
wormburner
I am trying to add a range if another range is "D" or subtract if the "D" is
an "R".
I have used SUMIF to add the range but cannot figure our how to not add...
|
|
2 |
444 |
|
|
Unwanted reformatting of protected cells by
USAOz
I have a number of spreadsheets in which I have columns formatted in a
particular way - e.g. Time to display 00:00:00 or ID formatted to display as
a Number...
|
May 31st, 2010 08:58 PM
by USAOz
|
0 |
345 |
|
|
Excel 2007 - Copy Picture Resolution by
XLUser
When I select cells to copy as a picture in Excel 2007, the resolution is
terrible. Text and objects with shadow's are very blotchy when pasting the...
|
|
1 |
507 |
|
|
Simply Array Formula? by
Going Crazy with excel[_2_]
I have a column of numbers. Looking for an array formula that will identify
and highlite the "highest" three values. Does such an animal exist?
|
May 31st, 2010 07:03 PM
by jkiser
|
6 |
402 |
|
|
Filter on Pivotable by
tran1728
Dear All, pls help me.
I work with Pivitable : Iem , Code and Qty.
exemple:
Item Code Qty
1234 10AA 25
1424 25BB 52
1475 10AA 32
1475 ...
|
|
0 |
278 |
|
|
Date Format Problem by
Alain
I have a worksheet with a column formatted as 022008 which is suppose to mean
Feb 2008 or 02/2008. I can't seem to figure out how to change the cell format...
|
|
2 |
373 |
|
|
|
May 31st, 2010 04:21 PM
by Balbir
|
0 |
307 |
|
|
|
|
1 |
441 |
|
|
Exporting the values to excel error by
Karthik
Hi All,
I am trying to exporting the values as '10-02' and '10-03' from my developed
application (developed in .Net). These values are stored as 02-Oct and...
|
|
1 |
377 |
|
|
Separate the boys from the girls? by
Quin
I would like a simple function that can help keep a dynamic count of males
and females assigned to a section. For example we will say there is a list
of 100...
|
May 31st, 2010 04:49 AM
by Quin
|
3 |
359 |
|
|
|
May 31st, 2010 04:39 AM
by Max
|
1 |
383 |
|
|
|
May 30th, 2010 11:44 PM
by akm
|
0 |
369 |
|
|
Sumif/SumProduct/lookup question by
Confused in TX
I want to insert subtotals only for items containing at least two specified
costs.
A B C
1 Item Name Cost Title Cost...
|
|
1 |
349 |
|
|
Sort problem by
Emece
I have the months of the year in one column. I need Excel to sort the months,
but according to calendar. I need January, February, March and so on. But if
I...
|
|
1 |
427 |
|
|
Hard to select first worksheet tab by
Dennis Marks
When you click on the icon in the upper left of a window a box appears with:
Restore
Move
Size
Minimize
Maximize
Close
With Windows 7 the box also appears when...
|
|
7 |
588 |