|
|
Selected cells shadding Invisible. by
Zarrar Janjua
When I select rows and columns in Excel, the selected cells are too feint to
see clearly (much darker in previous releases). Is there a way of darkening
the...
|
June 6th, 2007 08:58 PM
by KCook
|
6 |
59 |
|
|
|
|
1 |
94 |
|
|
Pastable function using VLOOKUP? by
zatomics
This is my problem:
I have a spreadsheet with three separate cells, call them A, B, and C,
that I am using for inputs. These three input values create a table...
|
May 23rd, 2006 06:17 AM
by Max
|
1 |
79 |
|
|
|
May 15th, 2006 07:01 PM
by CLR
|
2 |
169 |
|
|
Number formatting by
ZB
Hi,
I am need to convert numbers from my excel file to a text file where the
number needs to show up as follows:
###############.##
So for $401.11 the amount...
|
April 24th, 2005 03:50 PM
by JulieD
|
5 |
76 |
|
|
Time interval worksheet function by
Zb Kornecki
I would appriciate some help writing a function, to measure several interval
along a timeline. however not every interval applies to every record. what
I...
|
|
3 |
54 |
|
|
SUMPRODUCT Help by
Zb Kornecki
Please help me write a SUMPRODUCT formula
I have 3 columns
A=arrival time
C=time 1
D=time 2
I would like column B to show a count of how many times Col A...
|
August 22nd, 2007 03:46 AM
by Max
|
6 |
108 |
|
|
Count if by
Zb Kornecki
I have a years worth of dates in Col B and need to do countif and countblank
in Col D but I need to seperate by quarters, I was thinking of doing it w/
an...
|
|
5 |
97 |
|
|
please help w/ a time formula by
Zb Kornecki
I have 5 times fields the start times are in columns A & B and the end times
are in Columns C, D & E. They are not in order, but cols A or B are always
C,...
|
March 8th, 2007 01:18 AM
by Pete_UK
|
2 |
78 |
|
|
Filling down w/o dragging by
Zb Kornecki
Is there any way to fill down formulas w/o dragging the + cursur. I'm
working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb
|
May 31st, 2007 12:01 AM
by Alka
|
6 |
108 |
|
|
Counting letters and symbols by
Zb Kornecki
Hi our schedule sheets now need to be encoded with a specific letter or
symbol for each possible shift. This include upper and lower case letters.
and most...
|
|
1 |
60 |
|
|
formula: First and last day in month by
Zbigniew Lewandowski
Hi,
I have sheet:
In A column exist date
In B column exist "x" or null
In C column please bulid formula: first or last day in month only for day if
in column...
|
October 16th, 2005 04:51 AM
by Biff
|
6 |
126 |
|
|
|
|
1 |
90 |
|
|
|
|
2 |
65 |
|
|
|
October 21st, 2008 07:25 PM
by Spiky
|
2 |
72 |
|
|
How do i order selections contigously by
Zebediah
On one sheet I have a long list of items which I need my users to scroll down
and, when needed, fill in a value next to the appropriate item in the list. ...
|
|
6 |
79 |
|
|
Show only future Dates by
Zebrageek
I am trying to filter a list that has a column of start dates, and a column
of end dates. I want to ONLY show the end dates which are still in the
future. ...
|
July 20th, 2009 02:20 PM
by Max
|
4 |
105 |
|
|
blanks by
ZED
i am makeing a worksheet that needs to calculate scores
200 or under is a pass over 200 is a fail and i want
blanks left blank. the fornula i used has the...
|
August 12th, 2004 06:21 AM
by Michael
|
4 |
115 |
|
|
|
December 14th, 2008 01:16 AM
by smartin
|
1 |
61 |
|
|
|
April 14th, 2010 01:18 PM
by Eduardo
|
2 |
232 |