A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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 Go to last post
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...
August 1st, 2008 08:52 AM
by Arvi Laanemets Go to last post
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...
August 1st, 2008 08:15 AM
by joeu2004 Go to last post
2 96
Excel cannot complete this task with available resources. by Ali
When we try to open this particular file from any PC on the network we get this error "Excel cannot complete this task with available resources. Choose less...
August 1st, 2008 07:49 AM
by Marcus Go to last post
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...
August 1st, 2008 06:39 AM
by Joerg Mochikun Go to last post
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 Go to last post
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...
August 1st, 2008 03:43 AM
by Frank Situmorang[_2_] Go to last post
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...
August 1st, 2008 03:28 AM
by Dave Peterson Go to last post
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...
August 1st, 2008 02:13 AM
by Chantelle Go to last post
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 Go to last post
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
August 1st, 2008 01:14 AM
by Fred Smith[_4_] Go to last post
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 Go to last post
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...
August 1st, 2008 12:31 AM
by Yitzhack Go to last post
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 Go to last post
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!
July 31st, 2008 11:54 PM
by Dave Peterson Go to last post
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...
July 31st, 2008 11:14 PM
by T. Valko Go to last post
1 54
[XL07] Conditionally format fill color for entire row by Trevor Stone
Hi All, Is it possible to conditionally format the fill color for an entire row based on a cell reference? For instance, Columns 1,2,and 3 are text but...
(Multi-page thread 1 2)
July 31st, 2008 10:26 PM
by Derf Go to last post
11 170
This function returns incorrect value sporadically by Mike
I'm using this function in Excel '07 to return the worksheet name into cell B1 on a...
July 31st, 2008 10:12 PM
by T. Valko Go to last post
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 ...
July 31st, 2008 09:55 PM
by T. Valko Go to last post
1 52
How can I merge and link workbooks into one summary workbook? by Sylvia
hello! I am desperate - I need to link several workooks from different departments together to create one summary workbook that is automatically...
July 31st, 2008 09:55 PM
by Ron de Bruin Go to last post
3 137
Post New Thread


Display Options
Showing threads 22181 to 22200 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.