|
|
eliminate partial text in many fields by
BuffaloBilly
I have many fields with, for example, "08:22 CST" and I'd like to eliminate
the "CST" so that I can use an IF formula with these times. How can I
eliminate...
|
|
1 |
93 |
|
|
|
|
1 |
54 |
|
|
|
|
5 |
108 |
|
|
Calculate the difference between two times by
Buffgirl71
I have two columns. Both have a time format of NN:NN:NN. I would like
to calculate the difference. For example, if I have 10:02:01 and
10:03:05, I want to know...
|
|
3 |
77 |
|
|
|
|
1 |
100 |
|
|
Calculate the difference between two times by
Buffgirl71
I have two columns formatted as time in this manner: NN:NN:NN. I want
to calculate the difference between the two times. For example, in the
first column I...
|
|
1 |
52 |
|
|
Inserting information from One Sheet to Many by
Buffulo Alice
I have a workbook with 150 sheets. My first sheet is a list of places. I
would like to take that list and have each cell become fill into cell C5 in
all the...
|
|
3 |
115 |
|
|
How can i fill horizontally? by
Buffulo Alice
I am working on a rather large inventory workbook. I have a main page which
compilies data from 130 sites. Each one of these sites has it's own sheet
titled...
|
December 23rd, 2008 11:51 PM
by T. Valko
|
2 |
84 |
|
|
|
November 21st, 2007 04:22 AM
by T. Valko
|
5 |
149 |
|
|
lookup or match or max??? by
buffyslay
hi there
XL - 2000
i have a page in my workbook with the following info:
Col A Col O Col P
Name ...
|
|
2 |
461 |
|
|
F2 Enter to make Formula Work by
Buffyslay_co_uk
Hi
anyone got any idea on this?
I have a vlookup, which is picking up data from another page in the
same workbook, I have to F2 and then Enter to make...
|
February 2nd, 2004 05:45 PM
by Paul
|
3 |
414 |
|
|
how to seperate into columns? by
bufhal
Hope someone can help me.
I have a text file that when I open in Excel, all the comma delimited
fields are in the "A" column. I need all these records to be...
|
January 16th, 2006 06:35 PM
by bufhal
|
3 |
109 |
|
|
Pivot Table References by
Bufo
In 2000, I think you could refer to a Grand Total in a
Pivot Table in another formula, copy it down, and have it
be a relative reference. Now, it seems to...
|
December 3rd, 2003 12:59 AM
by
|
2 |
123 |
|
|
|
December 7th, 2007 10:24 AM
by Stephen
|
1 |
56 |
|
|
|
|
3 |
72 |
|
|
Countif using dates by
Bugaglugs
In column A I have dates in the following format;
01-Apr-05 right through until the end of March 2006
On a different sheet in my workbook I want to summarise...
( 1 2)
|
|
11 |
234 |
|
|
|
|
2 |
46 |
|
|
|
|
3 |
100 |
|
|
Same header and footer in excel and word by
Bugsy
I have a header that includes some special colors and border that I want to
copy to excel. I can copy it as a picture and it sort of works. How do I
same...
|
May 23rd, 2007 02:22 PM
by Bugsy
|
0 |
52 |
|
|
|
November 28th, 2005 03:23 PM
by noyb
|
2 |
90 |