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
Countif - problem counting text, other text by gmoore3055
I have a database which lists addresses by city, state, zip. I have used =COUNTIF(Database!H3:H33,"A3""1") to count the number of times I see five...
February 4th, 2010 11:30 PM
by T. Valko Go to last post
1 88
simple countif formula by Brian
Column B in my spreadsheet consists of 10 rows with one letter in each cell. I would like a formula to count cells B1,B3,B5,B7 and B9 only if the value in...
February 4th, 2010 11:21 PM
by Lars-Åke Aspelin[_2_] Go to last post
2 192
how to return mulitple corresponding values by MetricsShiva
i want to look up a name that occurs several times in one column of a spreadsheet and return corresponding values from each row the name occurs on. Vlookup...
(Multi-page thread 1 2 3 ... Last Page)
February 4th, 2010 11:03 PM
by T. Valko Go to last post
69 2,760
selecting an item at random for QA sampling by Eric F.
A co-worker has asked for help speeding up a process for QA of images of scanned documents. She does an end-of-line QA check on a set number of document...
February 4th, 2010 10:48 PM
by Eric F. Go to last post
1 183
I wish to group my worksheets under group tabs by Art
is this still not do-able?
February 4th, 2010 10:37 PM
by Dave Peterson Go to last post
1 81
indirect function by WINDMILL
I'm not familiar with why / when the INDIRECT function is used. I've inherited a spreadsheet, it has 10+ spreadsheets, and throughout them there are several...
February 4th, 2010 10:32 PM
by Dave Peterson Go to last post
2 80
if is error then "No Data", if not then average range by SK08
I believe the formula should be something like: iferror(average(C1:F1=TRUE,"No Data), average(C1:F1)
February 4th, 2010 10:21 PM
by Teethless mama Go to last post
1 123
Value list by Maint Girl
i need help with making value lists in excel so that i can make my data base consistant with the data i am entering
February 4th, 2010 09:12 PM
by Otto Moehrbach[_2_] Go to last post
1 59
Switch First and Last Names by Karen
What is the excel formula to change John Brown to Brown, John? Thanks!
February 4th, 2010 08:40 PM
by Teethless mama Go to last post
3 86
edit a comment while protect sheet is on the cell is unprotected by Rubber 4 u
i want other useres to b able to enter /edit a comment in an unprotected cell when protect sheet is on
February 4th, 2010 08:37 PM
by Gord Dibben Go to last post
1 85
calculating the "mean" for a group of numbers by rob
I am trying to find the mean for a groud of numbers, but the formula needs to exclude any number less then 26. 29,64,90,48,25,0,96,65,50,86,99,0,0
February 4th, 2010 08:23 PM
by David Biddulph Go to last post
2 112
Turning =E13 to =$E$13 by Bishop
I have worksheet with several hundred formulas in the form of =E13. I want to make all the formulas static, i.e. =$E$13, because I have to delete some rows...
February 4th, 2010 07:58 PM
by Pete_UK Go to last post
3 117
Password by Maria Elena
forget the password in worksheet( excel )
February 4th, 2010 07:41 PM
by Eduardo Go to last post
1 92
HELP by Roozo
The above explains everything great, however i do not have the same number rows in each set of data, e.g. A1 address 1 A2 address 1 A3 address 1 A4 address...
February 4th, 2010 07:18 PM
by Roozo Go to last post
0 65
How do I force the y-intercept value by Tony41
Is it possible to force the Y-intercept value to 100 when performing linear regression?
February 4th, 2010 07:14 PM
by Tony41 Go to last post
0 106
match by ganga
Hi, I have 2 work books. One is weekly schedule and other one is yearly vacation schedule. I would like to link both books matching names and dates. Vacation...
February 4th, 2010 06:55 PM
by Bernie Deitrick Go to last post
3 89
Returning a Value from Another Worksheet by TLH3934
I have two worksheets in one Excel 2007 file that I'm working with, in which I want the second worksheet to return values of the first worksheet. Hope I can...
February 4th, 2010 06:55 PM
by Kristin Go to last post
2 97
Sumproduct cell reference vs embedded "values" by BobMcBarker
I have experimented with all sorts of different combinations and there is clearly some syntax issue that I am running afowl of or something I do not...
February 4th, 2010 06:40 PM
by Teethless mama Go to last post
3 88
Sumproduct Search, Sum Durations by mp80237[_2_]
Hello, I have a table that I need to get information out of using Excel. Below is a sample from the detail data. systemslist severity Duration Minutes Fare...
February 4th, 2010 06:37 PM
by Pete_UK Go to last post
5 112
Count rows based on multiple criteria by dmg
I have a need to count the number of rows in an Excel spreadsheet based on contents of multiple cells. The formula is on one worksheet and all data is on a...
February 4th, 2010 06:30 PM
by Glenn[_6_] Go to last post
3 131
Post New Thread


Display Options
Showing threads 3241 to 3260 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:46 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.