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
linking to formula template on different tab by Rebecca
I don't know if I can do this in Excel, but thought it worth asking. I have a list of 80 clients. I need to know the cost for them, which is a complicated,...
January 8th, 2010 10:51 PM
by Rebecca Go to last post
0 108
If 0, count various codes in a range on another sheet by Steve
I have this formula in N37 =SUM(G37:M37)/5 If the above result is 0, I want to count the number of times a specific code(PQ) is in a specific range on...
January 8th, 2010 10:34 PM
by Steve Go to last post
8 60
calculating a minimum fee by Jackie
I'm looking for a formula that will calculate the following information: If 15% of the sum of a range of cells is less than $40.00 then the fee is $40.00. If...
January 8th, 2010 10:29 PM
by Jackie Go to last post
3 88
If Then Help by nabanco
Hi, how would I say: if cell e1 is a positive number, then return "win". If cell e1 is a negative number then return "looser". Thank you
January 8th, 2010 10:11 PM
by nabanco Go to last post
3 45
trouble copying a cell from one workbook to a new one by Carmela
I can not copy a cell from one workbook to a new one. when I right click the cell on the first workbook and then open a new workbook, the paste is not...
January 8th, 2010 09:26 PM
by Carmela Go to last post
2 62
copy between workbooks by Carmela
I am having a problem copying between workbooks. I usually just right click on copy and then go to the new workbook and right click paste. However, the...
January 8th, 2010 09:24 PM
by Carmela Go to last post
3 84
Cross Referencing by misstrious
Apologies if this seems a simple question, but I am at a bit of a loss on how to do it. I have two lists of people with a many to many relationship Group...
January 8th, 2010 08:34 PM
by Basil Go to last post
1 46
Need a formula by Rob
I am hoping some genius out there can help me with a formula. I want to do this…. First cell has total sales of 10,000, Second sell has fees of 100. I...
January 8th, 2010 08:04 PM
by Eduardo Go to last post
5 40
Lookup or an alternative by CHerzog
I have several sheets and I am trying to pull data from the master to the others, I have been trying to use the Lookup and IF function. But I cant get the...
January 8th, 2010 07:34 PM
by CHerzog Go to last post
2 49
Need help with formula to weed out duplicates by Meenie
Excel 2003 I receive information regarding patients in a hospital setting, the patient being identified by Medical Record Number. I need to know the number...
January 8th, 2010 07:17 PM
by Meenie Go to last post
4 64
Lookup/multiple by Minerva
This is a small snapshot of what i have in 2 sheets:- Department/Category/Place-----------(3 similar columns for both...
(Multi-page thread 1 2)
January 8th, 2010 06:21 PM
by richpauly13 Go to last post
13 90
Copy contents of a cell into a blank cell by fire9990
How do I copy the contents of cell B2 into cell D2 only if D2 is empty
January 8th, 2010 05:58 PM
by Gord Dibben Go to last post
2 73
Creating a Formula in Excel by Rob
I am hoping some genius out there can help me with a formula. I want to do this…. First cell has total sales of 10,000, Second sell has fees of 100. I...
January 8th, 2010 05:58 PM
by Gord Dibben Go to last post
4 63
Copy contents of one cell into another if cell is blank by fire9990
How do I copy the contents of cell B2 into cell D2 if D2 is empty
January 8th, 2010 05:54 PM
by Gord Dibben Go to last post
2 57
Formulas & Dates not working in .xls file by AOA
I have recently converted to Excel 2007 and upon opening a .xls file in compatibility mode, I find that no formulas work in the entire workbook, and all of...
January 8th, 2010 05:25 PM
by Squeaky Go to last post
1 83
Nested Conditional Functions by DyingIsis
This may be simple for everyone else except for me. I have a spreadsheet in which each column I can fill in one of three options (N/A, Yes, No). This is done...
January 8th, 2010 04:52 PM
by Paul C Go to last post
2 54
attach files by ankurcma
Hi to all Elite Group members some time queries and their solution posted here are not in good format , its little bit confusing I want to request all of you...
January 8th, 2010 03:10 PM
by Dave Peterson Go to last post
2 66
Refresh - F2 by enna49
You are probably tired of this type of question, but here goes. Is there any way to quickly go through a spreadsheet with the F2 Enter (to refresh a cell) ...
January 8th, 2010 03:09 PM
by Dave Peterson Go to last post
1 45
Need to create rows from columns by patc303
I have a spreadsheet that looks like this: Name | item 1 | item 2 | item 3 (etc.) I need to format it into: Name | item 1 Name | item 2 Name | item 3
January 8th, 2010 02:59 PM
by Paul C Go to last post
1 67
countif using other cell values for 'range' and 'criteria' by tony
using excel 2007 I am trying to set up a countif function that can easily be used by basic excel users. what i want to do is have a couple of cells where the...
January 8th, 2010 02:18 PM
by Bob Phillips[_3_] Go to last post
4 74
Post New Thread


Display Options
Showing threads 4041 to 4060 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 06:37 AM.


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