|
Drawing Revisions (aslo for Specifications)
Drawing Revisions are tracked first "in house" with a Letter. Then
when issued to a client they are issued with a Number. For Example:
blank line
blank line etc.
2 Issued for Bids
1 Issued for Client Approval
C Issued for Departmental Check
B Issued for Review
A Issued for Comment
Please bear in mind the Revision list may have several blank lines
first. (For future revisions...
|
6 |
30.09.2006 20:28:10 |
|
|
Pivot tables
I've never got the hang of pivot tables.
It's as if there's just one fundamental concept that I've missed.
Can anyone recommend a good intro on the internet.
Thanks.
Tod
...
|
3 |
30.09.2006 20:01:19 |
|
|
Excel Macro
I have an excel spreadsheet in which I need to sort row with column headings
that are mixed between merged and unmerged cells. In other words, I have
merged columns for employee name, project number, id and then have additional
columns that have beginning date range and ending date range stacked. These
last date ranges cannot be merged.
Right now the macro gives an error message of "mer...
|
5 |
30.09.2006 20:00:39 |
|
|
NEED TO FIND FIRST " " FROM RIGHT
Help - I have a column in excel that contains names, such as:
Joe Smith
Joe E. Smith
Joe Edward Smith, esq.
etc
I need to isolate the LAST WORD in the column, for example:
Smith
Smith
esq.
The only way I know how to do this is to search for the first " " - but
I need to start the search from the RIGHT, not the LEFT. As far as I
know, FIND function starts the search from the righ...
|
15 |
30.09.2006 19:37:54 |
|
|
Dividing with Arrays
I have an interesting problem. I am trying to break out a quantity
number from a list of products from a cash flow. On one row I have a
Product name, Quantity, Sales Price per Unit, and Total Sales Price
(Qty x SP per U) for my breakdown. Also on this row I have a Beginning
Month and an End Month for the range of when the products are sold.
This then divides the Products Sales Price evenly...
|
3 |
30.09.2006 18:29:53 |
|
|
Extracting text from a string.
Hello,
Is there a way for excel to extract a snippet of data from a text string?
For the following string,
Form:FOUR:OL_FRYEN:00:Text:ON
I want to extract the data between the 2nd and 3rd colons, so the result
should be:
OL_FRYEN
The data is always in Column A, so ideally, the extracted bit would be
entered beside the source string, in Column B.
Each tab (268 of them) in ...
|
6 |
30.09.2006 18:09:02 |
|
|
Macro to open text files and copy their contents.
Hi all,
Is there a way for a Macro to open a text file, then copy it's contents to
a spreadsheet and name the tab so it matches the name of the text file?
Then repeat this for 200+ text files in the same folder? I thought I saw a
solution here a while ago but I couldn't find it.
Thanks,
Art
...
|
12 |
30.09.2006 17:08:30 |
|
|
Count cells in range
I need a function that simply counts the number of cells in a range. Not
based on a condtion, simply the number of cells in a range.
Obviously if I'm doing this once I can simply put in a constant. (It's easy
to see that the range A1:A50 has 50 cells.) But I need a formula that will
automatically adjust if the size of the range changes, so that if I insert a
row after A17, the formul...
|
4 |
30.09.2006 17:04:01 |
|
|
Define range to avoid circular reference
Is there any way to exclude a cell from a range.
For example, in Cell F10, I'd like to calculate the sum of all OTHER cells
in that row, excluding F10 itself. But SUM(A10:Z10) includes the cell F10,
and therefore generates a circular reference.
If I were doing a single cell, I could say SUM(A10:E10) + SUM(G10:Z10).
However, when I need a similar calculation for all cells in a range...
|
5 |
30.09.2006 16:59:01 |
|
|
my comments won't change font!
Hi!
I'm trying to change the font on my comments, but it doesn't work.
I'm doing the following:
1. Right click on cell with comment
2. Modify comment
3. Select whole comment
4. Select different font
and..... nothing happens!
Could you give me a hand?
Thanx in advance,
Albert
...
|
1 |
30.09.2006 16:46:02 |
|
|
Problem trying to generate a report with a formula
Hi all,
I'm trying to generate a report and am having trouble with the formula.
Any help would be greatly appreciated.
Here is what I need to be able to do.
I have 6 worksheets in the same workbook, worksheets 1 - 5 are
identically laid out and the sixth is the one I want to generate a
report on. Column A is for peoples names, Columns B-H are labelled
Monday - Sunday on top. If ...
|
1 |
30.09.2006 16:45:24 |
|
|
Conditional formatting - compound condition
I'm trying to do something that seems like it should be simple.
In Cell A10, I want conditional formatting that says: if Cell A10 is not
blank AND Cell C5 = 1, then apply conditional formatting.
I can use the Cell Value Is for the A10 check (applying one format), and the
Formula Is option for the C5 check (applying another format). But I can't
combine them so that I do the two checks...
|
2 |
30.09.2006 16:31:24 |
|
|
Lookup a range and insert range name into second worksheet
Hi,
Worksheet 1
Column B Column K
Delivery x Allocation A
Delivery x Allocation A
Delivery x Allocation B
Delivery x Allocation C
Delivery x Allocation C
Delivery x Allocation C
Delivery x Allocation D
Worksheet 2
COL 1 Col 2 C...
|
7 |
30.09.2006 16:14:50 |
|
|
Data Consolidation
I have 20+ worksheets in a workbook. Each sheet is a timesheet for an
individual and each sheet can have up to eight cost codes which will be the
same on some sheets but will not be in the same position on all sheets. How
do I label or set up a range so I can consolidate all of these cost codes on
a seperate sheet to give me the total hours for each cost code?...
|
6 |
30.09.2006 16:11:02 |
|
|
Pivot Table Calculations
How do I subtract a calculated column from another calculated column and
have it show on the Pivot table
--
ceunice
------------------------------------------------------------------------
ceunice's Profile: http://www.officehelp.in/member.php?userid=4526
View this thread: http://www.officehelp.in/showthread.php?t=1215337
Posted from - http://www.officehelp.in
...
|
2 |
30.09.2006 13:49:59 |
|
|
Hardware specification for dealing with large files (Excel 2003 and 2007)
Hi All
Apologies for repeating parts of other subjects, but I was wondering
what people thought were the most important hardware requirements for a
machine to effectively calculate large Excel spreadsheets.
Specifically, I have problems at the moment both with re-calculations
(can take a few minutes) plus things like re-calculating cell contents
(when copy-and-pasting formulae) can take fo...
|
4 |
30.09.2006 10:54:42 |
|
|
Formula For Monthly Date
Hello,
I have a worksheet that has products listed that are on sale at different
times of the year. My question is what formula to use to get all Jan
products,codes,prices etc on to new worksheet, Feb on another worksheet etc.
Thanks
Mare
...
|
2 |
30.09.2006 10:25:02 |
|
|
when i press up arrow key then cell is not going up but whole shee
...
|
2 |
30.09.2006 07:47:26 |
|
|
Two scales on Chart
Is it possible in Excel (2003) to have a LH scale and a RH scale when
charting?
For example, in US terms, a LH scale showing Dow Jones Index (say 9000 -
12000 points) and a RH scale of a particular stock (say MS, $15 - $30) over
a period of time.
...
|
3 |
30.09.2006 00:35:24 |
|
|
Comment box defaults
Can I change the comment box default font and stop it inserting my name in
each box?
Peter
...
|
4 |
30.09.2006 00:33:29 |
|
|
Keeping a text box with its data point
Does anyone know of a way to group a text box to a data point in an
excel chart? I am unable to click on both items to use the Group. If I
add x axis points, the text box is no longer near its point. If this is
not possible, I'd like to know that too.
Thanks,
Myrna
...
|
2 |
30.09.2006 00:07:10 |
|
|
Change the size of the sheet?
I need only 30 rows, 7 columns in my worksheet, and I don't want more
rows and columns to be present, even the row/column indicator at the
left/top of the view (i.e. I don't want to see 31, 32, 33,... at the
left border or H, I, J,... at the top).
What should I do?
Thanks.
...
|
3 |
30.09.2006 00:01:40 |
|
|
Bring cell format with contents?
(Sort of a novice, so try to keep it at my level, if possible)
In my spreadsheet, I am comparing calculated results to an "acceptance
value." If the results meet the "acceptance value" I want the cell to
display "Passed." If not, I want the cell to display "Failed." Using the
IF() function, I have it working (see below).
What I would really like -- and this is just fluff -- is to ha...
|
4 |
29.09.2006 23:01:32 |
|
|
entering time
hello all..
wondering if there is any way to do this...
I have a column formatted for time as in this format 12:00
when entering a time it is cumbersome to have to enter the hour, then a
colon, then the minutes.
Is it possilbe to simply enter a 4 digit number such as 1245 and have it
show up as 12:45 ??
thanks so much... I've found this group to be irreplaceable...
glen in orlando
...
|
4 |
29.09.2006 21:12:24 |
|
|
Show which cell has MAX, MIN values?
At the bottom of a couple thousand rows of data, I have =MAX and =MIN
formulas. Is there some way I could make the cells beneath my MAX and MIN
formulas show me the address of which cell has the displayed MAX or MIN
value? At least the row number?
Ed
...
|
7 |
29.09.2006 20:29:23 |