|
|
How do you add gridlines? by
greenwood
I have Excel 2002, and I added a new worksheet to my workbook, but it came up
blank, with no gridlines. I really like gridlines, but can not find a way to
add...
|
|
1 |
290 |
|
|
SUMPRODUCT more help by
benb
I have a column of dates and a corresponding column of values that are
actually functions converting a foreign currency amount into USD. I want to
create a...
|
January 14th, 2005 10:25 PM
by benb
|
6 |
150 |
|
|
|
|
6 |
380 |
|
|
VLOOKUP problem by
Jason
Hi,
I am struggling to find a solution to match my requirements & would
appreciate it if somebody can help me out. I have a spreadsheet with just
under 4500...
|
|
2 |
402 |
|
|
Copying absolute references by
dcruickshank
I have created a simple template with two worksheets.
The second worksheet summarizes the data from the first by referencing select cells. I have used the...
|
|
0 |
267 |
|
|
formulas for employee time sheets by
RJ
I am trying to create an Employee Time Sheet that has running totals of hours
and calculates those running totals at an hourly wage. This part, I...
|
|
1 |
157 |
|
|
|
|
1 |
275 |
|
|
|
|
0 |
315 |
|
|
|
|
1 |
137 |
|
|
countif by
Becky
hi I need help. In column A I have male=1, female=2. In column E I have
less than 5 yrs=1, two-5yrs=2 and over 5 yrs=3. How do I find out how many
males...
|
January 15th, 2005 05:51 AM
by Biff
|
1 |
126 |
|
|
Help adding text values by
Texas-DC_271
I have a row of cells that I need to add. The row of cells do not
contain a number but rather a text value. I have created a table
linking my text values to...
|
|
5 |
547 |
|
|
|
|
1 |
358 |
|
|
Edit Hyperlinks by
yazz22
I have an excel sheet with around 2000 hyperlinks pointing to files on our
company's internal server. The location of the files has to be changed (new
network...
|
|
1 |
119 |
|
|
Autosum ignores cell values by
D
I have inherited a complex spreadsheet and have encountered the following
problem:
I am trying to add up a row and although the formula is correct, the...
|
January 16th, 2005 12:59 PM
by D
|
4 |
138 |
|
|
Several Dates -Verify by
zeek
Greetings,
I have 6 cells A1 - A6 with dates.
Approximately 23000 Rows.
They should be the same, however, fat-fingers are involved making inputs.
What can...
|
January 16th, 2005 01:31 PM
by Ola
|
4 |
169 |
|
|
How To Suppres #N/A Values by
John
I've finally worked out the formula to work, which is below
=IF(ISNA(MATCH(A2,StaffNo,0)),"Crew",INDEX(StaffGrade,MATCH(A2,StaffNo,0)))"
However I am now...
|
|
2 |
155 |
|
|
Need formula for sheet & cell reference by
MPH
Help
Have a list of sheet names and want to create a formula to use sheet name
as a reference in a formula. Have tried "Indirect" but haven't succeeded
with...
|
January 16th, 2005 03:39 PM
by MPH
|
0 |
159 |
|
|
Formula help by
DEEKABEE
I want to sum a cell that contains a formula with another cell that contains
a formula. How do I write a formula that will show the rersult?
|
|
3 |
144 |
|
|
"Conditional" summing by
Aladin Akyurek
In B2 on the destination sheet enter & copy down:
=SUMIF(Sheet1!A:A,A2,Sheet1!B:B)
Replace Sheet1 with the name of your source sheet.
Gilbert De Ceulaer...
|
|
0 |
135 |
|
|
Conditional formatting by
Versateo
When using the conditional formatting dialog box, if you want more than one
condition to apply, you click the ADD button. However, you can only do this
twice,...
|
|
1 |
181 |