|
|
|
|
1 |
94 |
|
|
Help with formula by
Richard
How would you write a formula to calculate the total hours in sheet1. Thanks
in advance!! I'm trying to match whats on sheet2 with the part number on
sheet1....
|
|
1 |
69 |
|
|
|
|
11 |
126 |
|
|
|
|
9 |
79 |
|
|
Help with formula by
Richard
whenever I type in this number on sheet1, Lookup RT-005 0n sheet2 Column A,
match qty in column B with RT-005 in column A, Take qty in column C, Run time
in...
|
|
1 |
56 |
|
|
Summarizing Dates into Months and Years by
Yuanhang
Hey, assume I have column A like that as followed:
Column A
12/11/07
1/07/08
2/13/08
2/13/08
3/11/08
Basically, column A are some dates sorted...
|
February 19th, 2008 11:13 PM
by T. Valko
|
8 |
71 |
|
|
Help with ROW function by
markmcd
Hi.
Looking for some help regarding the row function.
I have the following formula:
=LARGE($C$19:$D$24,ROW()-ROW($D$18))
Some data is included here by way...
|
February 19th, 2008 10:51 PM
by markmcd
|
3 |
88 |
|
|
|
|
1 |
81 |
|
|
ComboBox linked to TextBox by
capt
I have a UserForm, in which there is one Combobox and five TextBoxes.
I would like to be able to select an item from the ComboBox and an
associated item, from...
|
February 19th, 2008 10:26 PM
by capt
|
4 |
62 |
|
|
|
|
1 |
70 |
|
|
|
|
1 |
59 |
|
|
Wrap Text Not Visible by
Randy
Have wrap text turned on in a cell but can't seem to get the last line of
what I've written to show up in the cell no matter how much I expand the
cell. ...
|
|
5 |
70 |
|
|
The error of my ways. by
Cerberus
in the function below, I am having an issue with 3 and 6 showing up in the
cell. 0,1,2,4,5 all come up fine but I seem to have an issue after the
IF/AND. ...
|
February 19th, 2008 09:36 PM
by Max
|
5 |
96 |
|
|
Help with dates by
[email protected]
I am using Excel 2007 for generating purchase orders. The shipping
date from the vendor needs to be 7 days prior to the shipping date to
the customer. The...
|
|
6 |
72 |
|
|
Excel 508 compliance by
DavidF
How does one establish, verify and ensure 508 compliance on an Excel
Spreadsheet? PDF files can be verified using Acrobat and the tables within
PDF files...
|
February 19th, 2008 09:07 PM
by dlw
|
1 |
61 |
|
|
New Tabs by
Bailey
Is it possible to create new tabs and tab headings dynamically, thereby
creating a new worksheet for every entry? By that I mean, can I enter a list
on one...
|
|
1 |
67 |
|
|
|
February 19th, 2008 08:15 PM
by Tfrup12
|
0 |
61 |
|
|
Paste problems by
Olga
I am unable to paste more than 255 characters into an Excel cell. It cuts it
off. I know that I can type roughly 33,000 characters or so directly into
the...
|
|
1 |
69 |
|
|
|
February 19th, 2008 08:02 PM
by T. Valko
|
3 |
75 |
|
|
Header Insanity by
[email protected]
Hi,
I have a multiple-paged (35 pages) sheet displayed landscape on 11x17
paper. On page 1, the first three rows contain information about each
subsequent...
|
|
2 |
73 |