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
Copy a formula to the right increasing the rows from another works by Tracy
I posted this question this morning, but I did not get a resolve. Maybe this is a little more clear. I have two worksheets within my file Worksheet called...
August 27th, 2008 04:52 PM
by Pete_UK Go to last post
9 94
Formula Help by Lee Ann
I have a worksheet/form which is being used to track time spent on specialty details in my office. The user needs to indicate which days of the month are...
August 27th, 2008 04:35 PM
by Pete_UK Go to last post
8 68
Conditional formula containing text and wildcard by PMo
This is a rather complicated equation (at least to me). I am trying to create a conditional formula that will recognize partial text with a wildcard * and...
August 27th, 2008 04:14 PM
by PMo Go to last post
3 72
Automatically Entering Values by Sanchit
Is there any way to preset some values? Suppose I entered some values in From A1 to A4 (A1=12,A2=13,A3=14,A=15) Now I want that when I enter 12 in C1, it...
August 27th, 2008 03:33 PM
by Spiky Go to last post
4 129
countaif by A.Mourice
plz. i need a help. How can I use countaif with many conditions or any similar formula?
August 27th, 2008 03:32 PM
by Fred Smith[_4_] Go to last post
4 86
Finding lowest price by Steve M[_4_]
I'm hoping someone can help me with a formula that will determine from 4 non-consective columns, ie, F,H,J,L, the lowest price of the four and place the...
August 27th, 2008 03:04 PM
by rajesh Go to last post
1 36
Look up, not down by mckzach
Greetings all, I want to find a specific value (1) across Row 3, then look UP to Row 1 and return the corresponding name (e.g. Jim), as below. What formula...
August 27th, 2008 03:00 PM
by Teethless mama Go to last post
1 37
find max.. by [email protected]
assume we have the following lists... How can i return max value of "id"? e.g. ia1 = 11 ia2 = 8 ia4 = 5 ib1 =7
August 27th, 2008 02:38 PM
by Teethless mama Go to last post
1 35
Variable Range for NPV by Dkline
I need to calculate an NPV that could start in any given year and end in a later given year to provide a stream of income. For example - I have a 30 years...
August 27th, 2008 02:14 PM
by Dkline Go to last post
7 43
free movies by [email protected]
http://www.freemediatv.com/video/992-Meet_Dave_2008_DIVX.html http://www.freemediatv.com/video/991-VLC_Media_player_Online_test_only.html http://www.freemediatv...
August 27th, 2008 12:24 PM
by Taurien Go to last post
1 126
Ignore NA in a formula when I type it in a cell by Tyler Manhattan
=IF(F60,10,0)+IF(H6=1,10,0)+IF(I6=1,10,0)+IF(Q6=0,10,0)+(K6*20)+(M6*20)+(O6*20)-SUM(R6+S6) When I put a NA into cells K6, M6, O6, R6, S6, it won't...
August 27th, 2008 10:23 AM
by Joerg Mochikun Go to last post
4 53
Cell Reference by Taurien
Hi! I need to know that can we use a particular cell in a formula again and again. And my excell 2003 is showing numbers in columns but in earlier versions...
August 27th, 2008 09:44 AM
by Taurien Go to last post
4 54
HLOOKUP by Freshman
Dear experts, In sheet "Team", cell N3 is a lookup value. In sheet "Group", array table is E9:L42 and row index is 42. So, in sheet "Team" cell N4, I set a...
August 27th, 2008 09:09 AM
by Freshman Go to last post
2 53
soma gebraica by Kajimbangala
how to sum algebric +-?
August 27th, 2008 09:08 AM
by Max Go to last post
1 50
Using CTRL to select cells for a formula by Elgee
Hi - I tried to search for help on this one before posting - but wasn't sure how to search for my answer if that makes sense. Essentially - I work with a...
August 27th, 2008 08:30 AM
by Joerg Mochikun Go to last post
2 55
Timesheet Function by Ricardo
I have the following in a spreadsheet for working out time work. Everything adds up into little columns, however when this entry is put in, it produces a...
August 27th, 2008 08:10 AM
by Bob Phillips Go to last post
2 62
Index/Match by Esradekan
I have a workbook for wages. Each staff member has a sheet of their own calculating gross amounts paid. Tax is deducted from this amount but is complicated by...
August 27th, 2008 07:45 AM
by Esradekan Go to last post
3 77
Calculating Sortino Ration (Downside Deviation) by TimH
I am trying to write a formula to calculate the Sortino Ratio defined as (Expected (Observed) Return - Minimum Acceptable Return(MAR))/Downside Deviation. ...
August 27th, 2008 04:46 AM
by Max Go to last post
6 88
Pivot Table filters, especially DATE filters by chris
I have consistently had trouble filtering information in a Pivot Table by DATE in Excel 2007. There seems to be no way to designate a field of date items so...
August 27th, 2008 04:33 AM
by chris Go to last post
0 82
if statements returning dates by Clinton
i have the following formula to give a 2 day cycle for production which will skip saturdays and sundays. can it be made to miss other days such as public...
August 27th, 2008 04:25 AM
by T. Valko Go to last post
4 64
Post New Thread


Display Options
Showing threads 21081 to 21100 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 12:12 PM.


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