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 Replies Reverse Sort Order Views
Can I Use a Count Function for Text? by Joan NYC
I have been trying to calculate a column of Text in order to sum contents by certain criteria I have tried Count, CoutA and CountIF and cannot be able to get...
(Multi-page thread 1 2 3 ... Last Page)
May 22nd, 2010 07:17 PM
by Chris Reid Go to last post
106 2,313
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 10:03 PM
by T. Valko Go to last post
69 954
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches by [email protected]
I have been trying to find a way in which i can have excel search through two columns to find each unique match between the columns and somehow change the...
(Multi-page thread 1 2 3 ... Last Page)
November 16th, 2007 07:27 PM
by [email protected] Go to last post
65 713
How can I lookup when match has more than one value? by bonot1
I am using LOOKUP functions to retrieve info from a list. Some of the lookup values have more than one match in the list. Is there a function that allows...
(Multi-page thread 1 2 3 ... Last Page)
May 24th, 2010 10:00 AM
by Roger Govier[_8_] Go to last post
55 1,284
Can you AVERAGE IF and not null? by Spottkitty
=AVERAGE(IF($A$3:$A$45="Photo",H3:H45)) This is the array I'm using to try to determine an average. Problem...if the field is blank it's counting it as zero...
(Multi-page thread 1 2 3 ... Last Page)
April 26th, 2010 11:48 PM
by Hijosdelongi Go to last post
51 810
Excel IF/LARGE Function problem by andyp161
An incentive scheme at work allocates points to employees and the three highest earners per week receive bonus points. Therefore, I want excel to locate the...
(Multi-page thread 1 2 3 ... Last Page)
July 26th, 2004 08:13 PM
by hgrove Go to last post
50 924
How to calculate days:Hours:Minutes: by Kurewe
Greetings, I am working on a spreadsheet that performs several calculations on the data that is provided in another spreadsheet. The basic function of my...
(Multi-page thread 1 2 3 ... Last Page)
January 17th, 2005 11:11 AM
by Bob Phillips Go to last post
46 1,005
Incorporating Cell color fill in an "if" logical function? by George_Sky
I want to identify a specific cell by highlighting it with a cell fill color when an "if" statement returns a "ture" response. How do I do this?
(Multi-page thread 1 2 3 ... Last Page)
May 6th, 2010 06:42 PM
by Luke Go to last post
45 1,362
Random Numbers by Steved
Hello from Steved ok I am no thinking straight What do I need to do please to have a number in a row 1 to 40 as an example below 1,23,9,25,33,40 each row...
(Multi-page thread 1 2 3 ... Last Page)
September 14th, 2005 04:30 PM
by RagDyeR Go to last post
44 686
Blinking Text by Esra Dekan
OK, i know its kind of frowned on, but I need to have a cell that flashes text. How do i do that in Office 2007? Any help appreciated TIA Esra
(Multi-page thread 1 2 3 ... Last Page)
February 19th, 2008 12:42 AM
by Gord Dibben Go to last post
43 502
Sum based on specific condition by Wendy
Need help...I am trying to sum only those values in column (D) whose corresponding value in column (A) is greater than the value in column (B). (A) ...
(Multi-page thread 1 2 3 ... Last Page)
June 7th, 2007 09:25 PM
by Harlan Grove[_2_] Go to last post
43 475
Date fomula not working by FangYR
I have use this last year, it's fine until now. the formula is now new to...
(Multi-page thread 1 2 3 ... Last Page)
February 18th, 2009 11:13 PM
by Max Go to last post
43 503
Formula to Return the next 1st Tuesday of a Month by Sean
How can I construct a formula that will relate TODAY to the 1st Tuesday of each month. For example as today is 01/12/07, my formula should return...
(Multi-page thread 1 2 3 ... Last Page)
December 3rd, 2007 08:22 AM
by Sean Go to last post
42 600
help on averaging function by Treesy
Is there a way to not have a blank or zero value not be counted in an average function. Example: I have a spreadsheet that has a year's worth of data. ...
(Multi-page thread 1 2 3 ... Last Page)
July 18th, 2007 09:10 PM
by Harlan Grove[_4_] Go to last post
41 435
Bug in Excel's (not VBA's) MOD function by HarlanGrove
The value 12,345,678,000 is too large to store as a long integer but well within the range of integers that a double precision floating point real can store....
(Multi-page thread 1 2 3 ... Last Page)
August 30th, 2005 05:13 PM
by Harlan Grove Go to last post
41 1,110
How can I make a drop down box visible within a worksheet? by skittles_golf
I have created several Drop Down boxes in a worksheet but I want to make them visible so people know there is a drop down box there. Right now the arrow...
(Multi-page thread 1 2 3 ... Last Page)
May 19th, 2010 07:43 PM
by Cheers and Beers Go to last post
40 1,190
Frank Kabel: A Sad Day for the Excel Community by Norman Harker
Hi Everyone! The heading expresses our distress at a loss to the community of Excel. It is with the greatest of sadness that I must report the news...
(Multi-page thread 1 2 3 ... Last Page)
February 7th, 2005 04:51 PM
by John Go to last post
39 814
A ? for our Excel Guru's and MVPs by 4pinoy
Considering that we are under the Microsoft Forum Domain and as a simple excel user. I need to know what are the guarantee we can obtain from 3rd party Add...
(Multi-page thread 1 2 3 ... Last Page)
November 24th, 2006 02:08 AM
by 4pinoy Go to last post
38 461
Counting Unique Values by Bob
I have a column with the following dates: 11/23/05 11/23/05 11/23/05 11/25/05 11/25/05 11/28/05 12/1/05 12/1/05
(Multi-page thread 1 2 3 ... Last Page)
November 1st, 2006 09:00 AM
by Jamie Collins Go to last post
38 511
If/Then Formulas by Bk Goto
Hello and Good Day =) I am in need of some help... I would like to create a formula where IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2 Any...
(Multi-page thread 1 2 3 ... Last Page)
August 13th, 2008 09:27 PM
by John C[_2_] Go to last post
38 425
Post New Thread

Display Options
Showing threads 1 to 20 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 04:18 AM.

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