|
|
automatically fill in blank cells?? by
AlaskaMX
Can I type info in 1 cell and have it automatically put different info in the
next cell? Kinda like autofill but not that exact option. This would be...
|
|
6 |
71 |
|
|
Show the last # in a column by
Alaskan in a Cubicle
Seems simple, but I'm not figuring it out. I have a one-page sheet on which
others will periodically add information to some columns. At the bottom, I
want a...
|
|
5 |
119 |
|
|
April 1 by
alaskanrogue (Marc George)
Why does Friday, April 1, 2005 in a date formated cell generate a wrong data
type error when using the WEEKDAY formula?
|
|
5 |
91 |
|
|
|
|
2 |
109 |
|
|
How can I reference a cell within a formula by
Alaska_Word_novice[_2_]
I have a formula in the form:
=G1*'Producer 1'!B1+G2*'Producer 1'!B2+G3*'Producer 1'!B3+G4*'Producer 1'!B5
I would like to be able to replace 'Producer 1'!...
|
|
3 |
60 |
|
|
Conditional Formatting by
Alastair Brannen
I have a column which contains the date of every Monday. I would like the
Monday of this week to be highlighted. Any assistance would be greatly
appreciated.
|
|
1 |
60 |
|
|
|
|
1 |
83 |
|
|
Delete rows that are empty across columns by
ALATL
I have the following columns that are a result of a pivot table. I would like
to delete the folllowing occurences. I tried using the range function but got
a...
|
November 6th, 2006 04:09 AM
by ALATL
|
0 |
46 |
|
|
vlookup & Extrapolation by
alawi
I have the following columns
Va2 177
V3 216.37
V3/rootT3 11.984
Q3 ?
V3/rootT3=11.984 which is not in the table
I need to retrieve the Q3 from a long...
|
|
2 |
88 |
|
|
If Statement based on blank fields by
alaxmen
I am trying to write an IF statement in a cell for a calculation based
on whether a cell is blank or not. This is what I have started with
but I know it isn't...
|
February 8th, 2006 08:00 PM
by alaxmen
|
3 |
79 |
|
|
Deleting content by
alazydaydreamer
Hello there,
I am working with an excel sheets that has over 3000 products in our inventory
The first column contains the part number. Each part number has...
|
March 22nd, 2005 10:57 PM
by RagDyer
|
3 |
77 |
|
|
|
January 20th, 2010 02:18 AM
by Dave
|
1 |
98 |
|
|
|
|
1 |
109 |
|
|
Splitting cells by
Albee
I have a huge column of address info. All the info is only seperated by
spaces not comas. Each address is a different length so i cant even split by
using...
|
March 2nd, 2009 05:11 PM
by Albee
|
2 |
70 |
|
|
Formula in cell by
albericht
Excel Help says enter 10-5 and it will read the answer as 5 in the cell. I
tried it, but it just read 10-5. So I then tried clicking Enter, but it then...
|
November 5th, 2007 08:29 PM
by CLR
|
2 |
35 |
|
|
Columns by
albericht
Can columns be sorted alphabetically? If so, how?
|
|
3 |
67 |
|
|
lookup function help by
alberson
I am having a problem with the formula below. I have a chart of
certifications listed by date which are due annually. I have a column
dedicated to list the...
|
|
2 |
88 |
|
|
excel functions by
Albert
What feature allows you to show the differences between two colums of
numbers? Item by item, not just column sub-totals or totals.
Thanks, Albert
|
|
1 |
80 |
|
|
HLOOKUP Formula Error by
albert
I'm trying to use the HLOOKUP formula for the following scenario:
Lookup value is a reference cell (B8)
Table_Array is the range of cells (B15:E15)
Row Index...
|
|
1 |
66 |
|
|
Count of days by
Albert
Can someone tell me how to correct the formula to count
the days across a year?
This formula is returning 25 days, which is wrong.
=DATEDIF(I5,D5,"yd") & "...
|
|
5 |
88 |