|
|
|
|
2 |
121 |
|
|
smpte time code by
KO_the_Kid
Does anyone have any suggestions for an excel custom format for smpte
timecodeadding/subtracting and formatting cells for video tape logging.
|
|
0 |
86 |
|
|
Track Changes in Excel by
Singz4J
I want to use the track changes function, but the amount of text typed into
the cell is too much for the tracked changes box to hold so instead of being
able...
|
August 5th, 2008 03:05 AM
by Singz4J
|
0 |
83 |
|
|
averaging in a pivot table by
time conversion[_2_]
I have one column in a pivot table contains numerous Doctors. In an adjacent
column I have the minutes that it takes them to do a task.....some have more...
|
|
4 |
91 |
|
|
Using a function/formula for copying text by
McKenna
I have a spreadsheet that contains information on work performed that day
1A DATE
1B WORK ORDER NUMBER
1C TECHNICIAN
1D WORK PERFORMED
I would like to know...
|
August 5th, 2008 02:30 AM
by Max
|
7 |
126 |
|
|
|
|
1 |
94 |
|
|
Hyperlink to a chart by
Sarah G
I have a workbook with multiple charts as their own worksheets. I have a
navigation page in which i wish to put hyperlinks to the various charts
however,...
|
August 4th, 2008 11:35 PM
by Sarah G
|
0 |
86 |
|
|
|
August 4th, 2008 11:21 PM
by Scott
|
0 |
79 |
|
|
|
|
1 |
78 |
|
|
Concatenate with leading zeros by
Nikki
I need to input a formulat to concatenate three cells together. The first
cell is a nine digit number ex. 001234567 the second cell is a one digit
number ex....
|
|
2 |
82 |
|
|
conditional formatting by
dkstech
I've read most of the similar topic posts but still haven't quite figured out
what to do. I used to teach computer science so I know conditionals, I just...
|
|
3 |
74 |
|
|
adding an amount to each cell by
mark
I have a spreadsheet that already has numbers in it. I want to add .40 to
each cell at the same time. Can this be done?
Thanks
--
mark
|
|
3 |
83 |
|
|
Sumproduct range changing with deletions by
Steve
I have this formula in one of the tabs in my workbook:
=SUMPRODUCT((Sun!$G$3:$G$200="Time missing for
sunday")*(Sun!$J$3:$J$200="Swingshift"))
I understand...
|
August 4th, 2008 10:24 PM
by Steve
|
6 |
95 |
|
|
Tracking inventory in excell or access by
tracking_guru
I'm trying to keep track of inventory going through multiple steps in a very
long process. The items in question leave the facility in batches of 100 or
more...
|
August 4th, 2008 10:22 PM
by JLatham
|
1 |
59 |
|
|
|
August 4th, 2008 09:56 PM
by Spiky
|
2 |
74 |
|
|
2 VLookups by
Guitarbuyer
Hi,
I am using Excel 2003 on Vista Ultimate. I need to find the value of a cell
if the part number or product group is used. Here is the example
A1: Part...
|
|
1 |
58 |
|
|
Total of a certain currency by
Tia[_3_]
Hi
Im working on an invoicing workbook sometime i have to issue invoices
in GBP not only in USD
they are in currency format and i am trying to find a way to...
|
August 4th, 2008 09:24 PM
by Spiky
|
5 |
86 |
|
|
|
August 4th, 2008 08:44 PM
by Spiky
|
4 |
164 |
|
|
Problem calculating Using a Percentage by
BrownsFan
I have a value of 289.2 in column A and a value of 325.1 in column B.
I created the the difference in percentage by using the following
calculation (325.1 -...
|
August 4th, 2008 08:35 PM
by Spiky
|
4 |
70 |
|
|
Array formula by
Sandy
Hello Folks,
I am using the following array formula:
{INDEX(C$2:C$8800,MATCH(1,IF($A$2:$A$88800=$Y2,IF($S$2:$S$8800=$AA2,1)),0))}
The formula returns a...
|
|
3 |
91 |