|
|
Help with Value in one column... by
David M
If you have an ethnicity column I want to go to the next column and for all
of a certain ethnicity I want to return either a 1 or a zero.
Column A ...
|
|
3 |
95 |
|
|
Averaging Times by
David M
I am wanting to try and average times, but I do not want to include the 0:00
in the formula for the average. Is there something that I can use to simply...
|
|
2 |
123 |
|
|
Time Extraction In Minutes by
David M
This one is hard to explain but I will give it a shot...
I have a start time and an end time of an incident...lets
say the start time is 1:40am and the end...
|
|
2 |
367 |
|
|
Pick a Random name from a list. by
David M Fritzke
I am working on a Free Give Away of some products. Our systems give me a
list of individuals who we have had contact which are then placed in excel.
We would...
|
|
5 |
97 |
|
|
How Do I format Background pictures? by
David Marinez
Thanks to a member I was able to insert a picture into the background. But
now I need to know how do I format that picture. I'm sure it's not
difficult,...
|
|
4 |
140 |
|
|
How Do I Write over Pictures? by
David Marinez
I pasted a scan picture onto my spreadsheet. Send it to the back and made it
transparent. I want to be able to type on the cells over the picture in
order...
|
July 15th, 2006 02:48 AM
by CLR
|
3 |
66 |
|
|
Excel should let you sort by subtotals by
David Matsumoto
Does anyone know if or how Excel can sort by subtotals without a bunch of
workarounds?
----------------
This post is a suggestion for Microsoft, and Microsoft...
|
|
2 |
80 |
|
|
|
|
2 |
120 |
|
|
Single word subjects and anonymous posters by
David McRitchie
"Single word subjects and anonymous posters" sure
takes any enjoyment out of trying to find solutions and posting replies.
You can get a free email address...
|
|
7 |
295 |
|
|
|
|
8 |
366 |
|
|
Formula to color cells based on result by
David McRitchie
Hi Vinny,
Conditional Formatting is certainly the easiest to use and it
does not matter how the value changed, but the limitation of
3 formatting choices per...
|
January 5th, 2004 05:14 PM
by Vinny
|
1 |
330 |
|
|
Comment Boxes and Gridlines by
David McRitchie
Hi Andy,
HTML will show borders but your gridlines will be ignored
even if you have checked Print gridlines on your setup, sheets
it has nothing to do...
|
|
0 |
286 |
|
|
Carry forward totals at each page break by
David McRitchie
Hi Paul,
This is not provided for in Excel. It can get quite messy trying
to create such feature. How about a running balance instead.
G22: ...
|
May 18th, 2004 07:26 PM
by paulb
|
1 |
287 |
|
|
|
|
0 |
240 |
|
|
Excel symbols!!! HELP!!! by
David McRitchie
Hi Michael,
I really don't have any idea what your two columns of data represents,
but a char(217) in the wingdings font would be a star. So maybe
take a...
|
|
0 |
121 |
|
|
HYPERLINK Worksheet Function by
David Messenger
Working in Excel 2000.
Trying to use the HYPERLINK Worksheet Function to Hyperlink from one sheet
to a Cell on another Sheet.
I can get it to work easily by...
|
October 11th, 2007 08:55 PM
by Pete_UK
|
3 |
67 |
|
|
HLookUp by
David Mok
Help!
I can get a simple HLookup fundtion working.. see example below: (table and
the Hlookup formula extracts the number 0.65
Counter GIL SYNF FRC
...
|
|
1 |
76 |
|
|
I need a cell to be blank. by
David Moore
I'm linking cells from another worksheet and I have two questions
which are somewhat related.
1. When I link the cell using ='Worksheet2'A2 the cell that I'm...
|
September 17th, 2009 09:26 AM
by Pete_UK
|
4 |
121 |
|
|
Getting text data from a pivot table by
David Morris Evans
AIG Policy # State WC Code DOUBLE HOUR OVER Grand Total
WC 968-5711 AZ 8810 11,797 50 11,847
9040 435,558 18,577 454,135
CO...
|
|
0 |
57 |
|
|
Query column for unique values by
David Morrison
I have a worksheet that has numerous duplicate values in a column. I'd like
to do the equivalent of a SQL "select distinct" but don't know how to do
this in...
|
|
3 |
493 |