|
|
|
|
1 |
73 |
|
|
need help with networkdays formula by
aashishtaneja
want to setup formula using networkdays through which end date which is 30
workingdays from start date can be calculated.
|
September 5th, 2007 01:06 PM
by Mike H
|
1 |
74 |
|
|
|
|
2 |
49 |
|
|
first ten and last ten averages by
aazharr
in one column i have names and in other column i have values. each same name
can have lot of values
so in column A all the names are written , (one name can...
|
|
2 |
72 |
|
|
Dynamic contents of commens box by
AB
Hello,
Is there a way by which I can make the contents of a
comment box dynamic, i.e. based on the contents of one or
more cells in the spreadsheet?
My...
|
|
2 |
115 |
|
|
Lookup references by
Ab
Why doesn't this formula work!?!
=LOOKUP(LEFT(A1,1),NUMS,LETS)
Column A contains numbers with multiple digits.
NUMS is a list of single digit numbers...
|
|
3 |
184 |
|
|
|
|
1 |
78 |
|
|
|
October 30th, 2006 08:21 PM
by Paul B
|
1 |
75 |
|
|
how do i write a macro by
AB
I want to write a macro to sort uppper and lower bounds form a sries of data
(numerical).
|
August 17th, 2006 08:47 PM
by Dave F
|
1 |
44 |
|
|
Time sheet calculations by
ab
Excel 2003 - hope this is the right group to ask.
I am trying to find a formula for a time sheet for employees. I will try to
show an example:
Col A (job...
|
June 8th, 2006 02:12 PM
by ab
|
3 |
85 |
|
|
weird problem with LOOKUP function by
ab
Hi,
This is my spreadsheet. Column C has the LOOKUP formula.
A B C
53 a a LOOKUP(A2,$A$2:$A$14,$B$2:$B$14)
447 b b LOOKUP(A3,$A$2:$A$14,$B$2:$B$14)
1...
|
|
1 |
122 |
|
|
dealer evaluation by
AB
I have long database of our dealer network and I like to grade them. The
methodology I like to use is to create a normal distrubition curve and
eliminate the...
|
June 15th, 2005 02:17 PM
by PC
|
1 |
87 |
|
|
|
April 9th, 2008 09:55 PM
by Spiky
|
2 |
143 |
|
|
Formula between sheets. by
AB Lighting
I am trying to find an easy way to take a full spreadsheet and using
different sheets write a formula to take certain inflormation into a new
sheet a re sort...
|
|
3 |
50 |
|
|
|
|
2 |
42 |
|
|
let's try it one more time by
ab3d4u
I had posted this same question. I did not get a good answer. But now I have simplified my own question. Hope this will help. I need a formula that deletes...
|
March 5th, 2008 06:57 PM
by Jim
|
1 |
93 |
|
|
at if "delete" formula by
ab3d4u
I downloaded a huge file in to excel. I selectively need to delete some entries which in this case are all in "rows" NOT columns. Is there a formula to do...
|
February 28th, 2008 11:43 PM
by Lt. Dan
|
3 |
98 |
|
|
Restricted Cells by
ab3d4u
I have a spreadsheet with the following characters - some columns are inaccessible for input, some cells are protected, there is a section of the spreadsheet...
|
|
1 |
78 |
|
|
IF problem by
ab3d4u
Here is my problem. In column A I have numbers with different colors. The colors have meanings. They represent a team. On column B, some of these numbers have...
|
December 18th, 2007 05:50 AM
by JMB
|
1 |
52 |
|
|
Nested if by
ab3d4u
I have 4 "if" scenarios for which I am looking a formula. It is just a basic scenario where I have 4 choices and I need this formula to read the four options...
|
December 19th, 2007 06:46 PM
by CLR
|
5 |
79 |