|
|
"Microsoft" Patch Virus Messages by
Alan
Does anyone know if the flurry of these things appearing in the newsgroups
recently is due to people maliciously sending them, or if the virus is
sending...
|
|
5 |
429 |
|
|
Cell values not displaying by
Alan
=INDEX('sheet1'!E2:E51,COUNTA('sheet1'!E2:E51))
i've got the above in a cell. which basically looks up the
last number in the E Coloum on sheet1. However due...
|
|
1 |
366 |
|
|
|
February 11th, 2004 09:38 PM
by Alan
|
2 |
519 |
|
|
Absolute cell references by
Alan
This is a copy taken from Google
Try the sub by Gord Dibben below
(always try any macro on a back-up copy of your file first)
Paste the sub - i.e. everything...
|
April 20th, 2004 03:50 PM
by Dave R.
|
1 |
335 |
|
|
|
|
4 |
85 |
|
|
How can I keep "#N/A" values from appearing in VLOOKUP results? by
Alan
(example formula)
=IF(ISNA(VLOOKUP(D2,H3:I5,2,FALSE)),0,VLOOKUP(D2,H3:I5,2,FALSE))
or
=IF(ISERROR(VLOOKUP(D2,H3:I5,2,FALSE)),0,VLOOKUP(D2,H3:I5,2,FALSE))
You...
|
May 2nd, 2004 01:11 AM
by Kem
|
1 |
189 |
|
|
|
|
1 |
176 |
|
|
|
July 16th, 2004 01:24 PM
by emm8080
|
2 |
286 |
|
|
|
|
1 |
151 |
|
|
Result in different cell by
Alan
Hi,
I have the following formula in cell f2:
=IF(A2"",B2-C2,"")
i want the result of B2-C2 to be put into cell E2 whilst
keeping the formula in F2.. How...
|
|
1 |
98 |
|
|
Convert date field to text by
Alan
I have a mass of data with dates, which I need to group
by DAY. I have formatted the cell to custom "dddd" so
that it shows the day, however when i pivot...
|
December 19th, 2003 03:45 PM
by Alan
|
4 |
510 |
|
|
Virus S**t by
Alan
Is there any way of preventing these 'Microsoft' and other virus loaded
messages appearing here with such monotonous regularity? Its really getting
on my...
|
September 28th, 2003 10:45 PM
by Alan
|
5 |
114 |
|
|
Cut and paste subtotals by
Alan
Hi -
I receive spreadsheet reports weekly that have several thousand records. I
subtotal these reports to derive subtotals for specific customers. I...
|
October 1st, 2003 09:44 AM
by Paul
|
2 |
77 |
|
|
Pivot table formulas by
Alan
Hello -
I am using XL2002. I have a pivot table and I was to include a simple
division formula. The table has a customer and sales info for 2001 and
2002. ...
|
October 7th, 2003 01:26 AM
by Alan
|
5 |
281 |
|
|
Open workbook for multiple people by
Alan
Hi again -
I have a workbook and want to have multiple people work on it
simultaneously. Now, it lets the 2nd person open it - read only. How can I
make it...
|
|
1 |
425 |
|
|
|
|
1 |
567 |
|
|
|
|
1 |
184 |
|
|
|
|
2 |
486 |
|
|
removing attributes...MAD as HELL by
Alan
I cna not for the life of me remove the "READ ONLY"
attribute for a Excel worksheet. I had made the sheet and
put important info on it and saved it to a CDRW...
|
|
3 |
168 |
|
|
Sumifs function by
Alan
I've entered the formula, it appears correct, and the correct result is
displayed in the function argument box, however only the formula displays in
the...
|
July 13th, 2009 07:16 PM
by Luke M
|
2 |
110 |