|
|
Referencing another worksheet by
rmellison
I am using a text string to reference a block of cells in another worksheet.
The text string is in a seperate cell, and I am using this string in a
multitude...
( 1 2)
|
|
10 |
294 |
|
|
Superscript in custom format by
Sloth
I have started to use custom formats to display units. For instance when I
want a number to display as 24" or 58.2 lbf. I don't know if this is the
proper...
|
September 15th, 2005 03:35 PM
by Sloth
|
2 |
174 |
|
|
|
|
1 |
178 |
|
|
Summary of Data from a Range by
Blobbies
I have a range of data, which is a weekly sports picking competition at work.
Basically on the left it has the event, and along the top it has my...
|
|
3 |
200 |
|
|
Filter List by
John Moore
I need to filter a list of data to be able to view each part and the customer
for each part. The example below shows part 10P2345 appearing 4 times, with...
|
September 15th, 2005 04:04 PM
by Max
|
3 |
168 |
|
|
Identical Name on multiple workbook pages by
Peter Rooney
As a hardened Excel/VBA nut, I'm probably going to be really embarrased when
I get the answer to this, but here goes...
I have a workbook containing a...
|
|
4 |
199 |
|
|
|
|
1 |
126 |
|
|
Formula or UDF to add figures by code # by
mikeburg
I have a list of figures in column A & each figure's 3 digit code in
column B.
What would be a cell formula that could be put in columns C & D to
subtotal by...
|
September 15th, 2005 04:30 PM
by Max
|
5 |
182 |
|
|
|
September 15th, 2005 04:55 PM
by Ellie
|
1 |
185 |
|
|
|
|
1 |
152 |
|
|
|
September 15th, 2005 05:01 PM
by Mike
|
1 |
240 |
|
|
Lookup and Sum by
Brent
How do I find multiple occurences of a value using VLOOKUP (or some other
function) and then sum the values.
|
September 15th, 2005 05:34 PM
by Vincnet.
|
1 |
96 |
|
|
greyed out button by
M Zahedi
A while back I added a button to redo (ctrl + Y) to the standard tool
bar. It was working fine for a long time, but now it is greyed out and
I can not get it...
|
September 15th, 2005 05:41 PM
by M Zahedi
|
3 |
122 |
|
|
E-mail addresses in Excel 2000 by
David Williamson
I have an HR director who is copying and pasting e-mail addresses into a
spreadsheet (Excel 2000). He wants to make these addresses links. I know
how to do...
|
|
1 |
122 |
|
|
|
|
2 |
626 |
|
|
Conditional Formatting and selection by
Kristin N
I have one column that has both name/address(in one row) and telephone
numbers(in another row). I'd like to move the name/address info into it's own
column....
|
|
2 |
119 |
|
|
|
September 15th, 2005 06:30 PM
by Suzan
|
4 |
190 |
|
|
|
September 15th, 2005 06:35 PM
by Mike
|
2 |
124 |
|
|
|
|
1 |
299 |
|
|
ignore missing values while ploting graph by
Excel plot
what commands do i need to give in order to ignore the missing values when i
am plotting the curve. By ignoring the missing values I will not get any
breaks in...
|
September 15th, 2005 06:48 PM
by Mike
|
2 |
95 |