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
Excel worksheet by boschuster50
Is there a formula, or function that will, In a spreat sheet, if there is a section in the sheet that does not pertain to some of the users of the...
August 1st, 2008 05:37 PM
by boschuster50 Go to last post
2 77
Countif Range not working by tommcbrny
Hi, I have the following entered to set a text value in column d when some other text value is found in a cell range within columns b and...
August 1st, 2008 05:29 PM
by tommcbrny Go to last post
4 100
Data Base Functions by Gerardo
Hello, I need to sum info that meets more than one criteria. Excel has Data Base funtions that work by referencig to a range that contain criteria to be used...
August 1st, 2008 05:25 PM
by Gerardo Go to last post
2 102
find a sequence by LiAD
I want to get excel to look through a series of numbers and words, find the words that match, calculate the difference between the two numbers associated...
August 1st, 2008 05:18 PM
by John C[_2_] Go to last post
3 73
Need help creating a function by chrspty
I have a spreadsheet that compiles a specific incentive given to customers. I need to be able to total the number of people who received the incentive based...
August 1st, 2008 04:48 PM
by J Sedoff[_3_] Go to last post
2 88
Vacation Calculator by Sarah
I am attempting to calculate vacation time for employees based on years of service. I do not know how to write the function to do so. I have an accrual...
August 1st, 2008 04:48 PM
by Gary Brown[_4_] Go to last post
1 72
How can Excell automatically fill in a default function for a colu by Richard-44[_2_]
I can't find this feature defined/explained anywhere, but I admit I'm having a hard time knowing what search-phrase to use. Automatic Fill? Automatic Input?...
August 1st, 2008 04:43 PM
by Spiky Go to last post
3 115
Need function that will work in Excel 2003 like "Countifs" in 2007 by RD
The following is an example of my database. I am looking for a formula that will provide me a count of the number of times a "Rank" is less than 20 (20)...
August 1st, 2008 04:35 PM
by RagDyeR Go to last post
3 104
IF with Search/Find??? by TotallyConfused
I have tried several ways to identify a rows in a column with the first three characters are the same "BSB". The data reads in the column like: ColA row 5...
August 1st, 2008 04:33 PM
by RagDyeR Go to last post
6 143
skipp blank cell by Sanjiv
for example : I write a formula : =if($m9=25,$j9,"") and copy the same A!:A7 ouput of the above : A 1 100 ...
August 1st, 2008 04:09 PM
by Spiky Go to last post
3 154
Fill color with if function by maz
Hi. I want to fill a cell with some color based on the value in other cell. if a24 then a1 is blue. Can anyone help me? thanks
August 1st, 2008 03:48 PM
by Spiky Go to last post
4 80
index(match) Wind Uplift Calculations (match four conditions) by JMeier
INDEX/MATCH works good on tables with two or three arguments but I haven't been able to figure out how to use it with four arguments Criteria Roof Angle Roof...
August 1st, 2008 03:48 PM
by Bernie Deitrick Go to last post
9 98
What purpose is the INDIRECT function? by Simon[_8_]
Thanks Surely if I want cell value of A3 to appear in cell B4 I could enter "=A3" in cell B4?
August 1st, 2008 03:08 PM
by Pete_UK Go to last post
8 81
COUNT IF but not if 'X' IS NULL by Pyrite
Hi, I have a list of vehicle types and a list of MPG figures. I want to do an average MPG for each vehicle type so I need to know not only how many of the...
August 1st, 2008 02:34 PM
by Pete_UK Go to last post
5 89
I Need get work this formula by ytayta555
Best to you I have this formulas : =AND(COUNT(B1;B3;B5)=1;COUNT(C1;C3;C3)=1;COUNT(D1;D3;D5)=1;COUNT(E1;E3;E* 5)=1;COUNT(F1;F3;F5)=1) An perfect...
August 1st, 2008 02:06 PM
by ytayta555 Go to last post
6 78
Can I use solver for this? by Belinda7237
I am not sure the best way to solve my problem and am hoping someone can help. I want to be able to determine approx how long each item takes to produce. I...
August 1st, 2008 02:02 PM
by Dana DeLouis Go to last post
5 62
Using Autofilter to exclude dates by Ian
I'm working with data that has about 19,000 rows. The information is date specific, and there are scores of rows for each date.. I was working with February...
(Multi-page thread 1 2)
August 1st, 2008 01:41 PM
by David Biddulph Go to last post
11 126
Password by Gitano
Is there any way to protect some worksheets with a pasword that can not be breaked?
August 1st, 2008 01:23 PM
by David Biddulph Go to last post
3 59
Security Warning Message Bar to update External Links in Excel 200 by ash
Hi, is it possible to change the Security Warning Message Bar that prompts you to update the external links to a dialog box just like the earlier version of...
August 1st, 2008 10:42 AM
by ash Go to last post
0 128
Formula with multiple variables by Sam
I have two reports pulled into a workbook. I am trying to match three columns of data and bring back the results from a 4th column. I am using the...
August 1st, 2008 09:58 AM
by Max Go to last post
8 96
Post New Thread


Display Options
Showing threads 22161 to 22180 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 07:22 PM.


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