|
|
Addition base on condition by
68magnolia71
Hello you all,
I have the following problem with a production sheet:
A B, C, etc =the names of thr products
next column = production time
next column =...
|
|
4 |
100 |
|
|
time differences in a column by
68magnolia71
Good evening everyone,
On this forum I've been given (3/29/2005, Bernie Deitrick) formulas to
calculate time differences in column C base on the word "start"...
|
|
3 |
99 |
|
|
Last text value in a column by
68magnolia71
Good evening,
On this forum I've been given formulas by several persons that give the last
NUMBER value in a column. I tried to adapt them for TEXT. One of...
|
April 19th, 2005 08:50 PM
by Domenic
|
1 |
67 |
|
|
time differences in a column by
68magnolia71
Need to calculate the difference between two cells in a column. Exemple
A B C
Start 1 date/time
open ...
|
|
7 |
238 |
|
|
|
|
10 |
194 |
|
|
Condtional formatting by
68magnolia71
Hello everyone,
I'm looking for a condtional formatting formula based on 2 conditions. The
conditions are based on a text that are in 2 different cells in the...
|
|
2 |
90 |
|
|
Sumproduct by
6pak
I can not get the sumproduct function to work properly. I have read a number
of threads and followed the example to a tee, but function will not work.
Here...
|
|
4 |
74 |
|
|
worksheets linking in Excel? by
703
I made a worksheet for tracking manpower assignments. Once I had it done, I
copied that worksheet 15 times, named each tab to an employees name. When I
cut...
|
August 25th, 2006 06:48 AM
by Max
|
1 |
92 |
|
|
|
October 1st, 2009 11:46 PM
by 7777
|
0 |
109 |
|
|
#NAME? by
77Debbie77
I am pulling my hair out!!! I have over 60,000 rows of data with comments and
am trying to add a function to a cell: =SUMPRODUCT(--('Closed calls as of...
|
|
5 |
132 |
|
|
=SUMPRODUCT Col E = B, Col F = blank by
77Debbie77
I am using the formula below to try and get the total count of Col F when it
is blank (Col F is text data and some employees did not enter a comment) when...
|
|
7 |
139 |
|
|
two sided printing by
789
I have a 200 page worksheet to print. I like the idea of
putting it in 100 pages, using both sides of the paper.
Excel 97 had this feature. I now have Excel...
|
|
2 |
290 |
|
|
|
August 29th, 2006 02:05 AM
by Cbus
|
4 |
207 |
|
|
WORKBOOK INDEXING by
7of9
I have a multipage workbook (40 pages) and want to set up an Index page.
I tried hyperlinking, but when I copy it for the following year's use, the...
|
|
1 |
127 |
|
|
vlookup character limitations by
808bobby
is vlookup limited in retrieving cell contents greater than 255 characters? I
have a vlookup function that is properly retrieving the cell, but the text...
|
|
1 |
123 |
|
|
time format by
818jaime
Can some one please tell me how to format time exported from Avaya IQ.
example time exported 00:01:23
I need to format to only read 1:23 in excel 2007.
Thank...
|
|
4 |
100 |
|
|
|
|
0 |
72 |
|
|
vlookup, two worksheets by
88Keys
I want to take data from one worksheet and put it into another using vlookup. I have been able to do this in Lotus 1-2-3 by specifying the entire path of the...
|
July 2nd, 2004 06:04 PM
by 88Keys
|
2 |
108 |
|
|
|
|
1 |
148 |
|
|
Dates by
904allen
I have a sheet that figures dates, it can go back 3 years the user now puts
in the dates for each year needed, it looks like this
4/1/05 to 12/31/05 ...
|
March 27th, 2008 01:58 PM
by Pete_UK
|
9 |
100 |