|
|
Cumulative totals by
Songoku
Hi
I need some assistance on this one please I am trying to calculate the
cumulative total of trips by journey time ie
journey time Trips
00:00:00 ...
|
August 1st, 2008 08:54 AM
by Songoku
|
0 |
79 |
|
|
Drop Down & V Lookup by
Chantelle
Still on my restaurant menu database and I can think of what I want it do but
am unsure of what the commands are in excel!
I have one dependent list which...
|
|
4 |
99 |
|
|
Rounding Numbers. by
GEM
How can I round a number to two decimals. Not using the increase/decrease
decimals. For example...
I get an answer like this, 2.41666666666667, I know that...
|
|
2 |
96 |
|
|
|
August 1st, 2008 07:49 AM
by Marcus
|
2 |
130 |
|
|
Conditional Cell Lock by
James8309
Hi everyone,
I am just having problems with people editing the cell values. I know
how to lock particular cells in a worksheet but how do I...
|
|
1 |
78 |
|
|
Delete only specific fill colored rows? by
>Excel
I'm working to close out our last fiscal year numbers. From July 2007
- June 2008 we've used the light yellow fill for the payment rows and
no fill for the...
|
August 1st, 2008 05:08 AM
by JMB
|
1 |
97 |
|
|
Quick way to change file name by
Frank Situmorang[_2_]
Hello,
In my formula to take the amount of total collection there is a file name
ExtractDatainvcoll_Servr_080718, identified by date 080718 means this is the...
|
|
2 |
67 |
|
|
IF function by
MB HEG
I want to calculate our daily goal based on the hours worked in a day. If we
are off that day, the goal is 0. My false value keeps coming up with the
text...
|
|
7 |
113 |
|
|
VLOOKUP - MULTIPLE RETURNS by
Chantelle
I am attempting to create a menu database for our restaurant. I want to
return the name of a supplier when I choose a specific menu item so that in
my cost...
|
|
4 |
69 |
|
|
Counting time by
Lisa
Hello,
I have a table with 'time to event' in column B - i.e 20 weeks (doesn't have
to be weeks)
In column C i would like to calculate the actual DATE from...
|
August 1st, 2008 02:05 AM
by Lisa
|
3 |
53 |
|
|
Additional Columns past IV? by
MGarrison
Is it possible to get more columns in a spreadsheet. I would like to have 200
more past IV - any ideas? or is this a limitation of excel?
Thanks
MG
|
|
3 |
79 |
|
|
Mann-Whitney U test by
Rocky4460
Can anyone suggest a formula for this?
Basically, I'm trying to find out how many times does a number on the data 1
column exceed the numbers on the data 2...
|
August 1st, 2008 01:08 AM
by Pete_UK
|
5 |
56 |
|
|
Formula by
Yitzhack
I'm working on a project where I'm calculating the number of weeks per
quarter. What a need is a formula where 40=p, 80=pp 120=ppp and finally
160=pppp. Is...
|
|
2 |
50 |
|
|
Two "IF" functions in one cell by
Sunny
I was wondering if it is possible to insert two IF functions in one cell.
For instance =IF(A1="x","a","") and IF(A1="y", "b","")
Thanks.
|
August 1st, 2008 12:30 AM
by RagDyer
|
2 |
71 |
|
|
IF Formula Not Working by
novice
Hi,
When I use the IF formula in excel e.g. =if(h20,"CM","IN)
it displays the formula, not result (CM or IN)
Anyone knows why?
Thanks!
|
|
4 |
49 |
|
|
Data/Validate/List by
BobxxCalgary
I am attempting to use a drop down list which is located in a separate
workbook. I've gone through the directions several times by using the help
menu...
|
|
1 |
54 |
|
|
|
July 31st, 2008 10:26 PM
by Derf
|
11 |
170 |
|
|
|
|
1 |
68 |
|
|
V_Lookup question! by
CuriousMelly
I would like to do a v_lookup for stock between different worksheets. The
order sheet that I get in looks like this with 5 columns
Ship To Location ...
|
|
1 |
52 |
|
|
|
|
3 |
137 |