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
In Excel, conditional format (font red) referencing another cell? by Christine Hemphill
I want to do a conditional format to make cell A1 have red font if cell B1 is equal to a certain value (text). Can I do a conditional format on a cell...
(Multi-page thread 1 2 3 ... Last Page)
November 12th, 2009 04:40 PM
by Jamie Go to last post
38 568
How do I set up a formula to add column a if column b = cell c1? by michelle
a b c d 1 .2 yes yes .3 2 .5 no no .5 3 .1 yes maybe 0 So, as in the above example, I need to put a...
(Multi-page thread 1 2 3 ... Last Page)
March 30th, 2010 03:09 PM
by Bernard Liengme Go to last post
38 545
SUMPRODUCT and "--" by Michelle
I don't understand why sometimes I have to use "--" before an argument in the SUMPRODUCT fuction, and sometimes a "*". Can anyone point me to a resource that...
(Multi-page thread 1 2 3 ... Last Page)
October 13th, 2009 02:29 PM
by rock star Go to last post
37 361
Simplify formula by Luke
Pardon the new thread about the same thing I posted earlier. I would like to clean up the mistakes I made in my earlier quest. In it's raw form my setup looks...
(Multi-page thread 1 2 3 ... Last Page)
May 6th, 2005 07:21 AM
by Harlan Grove Go to last post
37 539
QDE (Quick Date Entry) by Norman Harker
Hi Community of Excel Users! This is a joint posting from 4 of the "regulars" to these newsgroups: Bob Phillips, Frank Kabel, Ron de Bruin, and Norman...
(Multi-page thread 1 2 3 ... Last Page)
September 5th, 2004 01:24 AM
by Frank Kabel Go to last post
37 2,810
Lookup in an Array by Steve
Can somebody tell me how to look up a list of items in a column from an array and then return the information in a cell that is in a column which is the same...
(Multi-page thread 1 2 3 ... Last Page)
November 6th, 2003 03:52 PM
by Steve Go to last post
36 1,014
How Do You Stop Annoying Excel Message Boxes? by Colin Hayes
I have a worksheet with a hyperlink to a program outside Excel. This is working fine at this point with one exception. Every time you click on the link Excel...
(Multi-page thread 1 2 3 ... Last Page)
January 14th, 2008 10:44 PM
by Colin Hayes Go to last post
36 370
Text manipulation by paulinoluciano
"Is there some VBA code which could delete all first, second or third characters of a text? Could it be done to the three last characters from this same text...
(Multi-page thread 1 2 3 ... Last Page)
January 12th, 2006 10:54 AM
by paulinoluciano Go to last post
36 418
Average function by Karen
I am trying to average time values over several weeks. However, I would like to exclude time values that are 0. Below is an example: Wk 1 Wk 2 Wk 3 ...
(Multi-page thread 1 2 3 ... Last Page)
July 12th, 2004 05:16 AM
by Harlan Grove Go to last post
35 770
Number of years, months, days between two dates. by Bluenose
Hello. I have a function that allows me to calculate the length of time between...
(Multi-page thread 1 2 3 ... Last Page)
June 30th, 2005 02:18 PM
by Grizzly Bear Go to last post
34 1,058
Count Functions by TSNS
Hi Everyone i am looking for a formula that would let me count the number of cells with a value between zero and 15? is there something that would...
(Multi-page thread 1 2 3 ... Last Page)
October 20th, 2007 05:04 PM
by Alan Beban[_2_] Go to last post
34 315
Countif function for Even and Odd numbers by Jezzy
Hi Hi, I need help with a formula. I would like to count a column that consists of even and odd numbers eg. 28, 31, 43, 50, 60. I like to count how many...
(Multi-page thread 1 2 3 ... Last Page)
October 25th, 2008 07:16 PM
by Harlan Grove[_2_] Go to last post
34 255
How can I count items in a filtered list? by tommy
do anybody know, how to use "countif" with filtered lists? the function subtotal does not allow conditions (e.g. "name") the function countif does it, but it...
(Multi-page thread 1 2 3 ... Last Page)
February 4th, 2010 05:51 PM
by T. Valko Go to last post
33 538
Macro for detect palindromes and repeats in letters/numbers string by Luciano Paulino da Silva
Dear all, I am looking to detect palindromes (sentence or number or other sequence of units that can be read the same way in either direction) and repeats...
(Multi-page thread 1 2 3 ... Last Page)
April 16th, 2009 04:59 PM
by Luciano Paulino da Silva Go to last post
33 344
Counting # of days between 2 dates excluding Fri & Sat) by Khaledity
Hi, I am doing a vacation tracking sheet for my subordinates, and I want to count the number of days they have consumed by entering start date and end...
(Multi-page thread 1 2 3 ... Last Page)
March 29th, 2009 01:05 PM
by Jacob Skaria Go to last post
33 263
Multiple Item Lookup by Chad F
I want to search sheet1 for all items that begin with "803" (803000 thru 803999) from A1:A4000 range and just list those item numbers in sheet2 starting in...
(Multi-page thread 1 2 3 ... Last Page)
January 16th, 2009 03:33 AM
by Chad F[_2_] Go to last post
33 196
Match Last Occurrence of two numbers and Count to Previous Occurence by Sam via OfficeKB.com
Hi All, Thank you very much for taking the time to provide various formulas. I need to find /match the LAST time two specific numbers appeared together and...
(Multi-page thread 1 2 3 ... Last Page)
April 4th, 2005 02:17 PM
by Max Go to last post
33 1,144
CountIf on Upper/Lowercase by ws
COUNTIF (A1:A10,"=A") treats "A" and "a" the same condition. Is there any way that I can differentiate the them (thus uppercase and lowercase) in countif &...
(Multi-page thread 1 2 3 ... Last Page)
December 6th, 2003 04:38 AM
by Dave Peterson Go to last post
33 347
Reverse PRICE function by ingmar
Wondering if there is a way to calculate coupon rate of a bond based on YTM, maturity, settlement date, and bond's price essentially I am trying to back solve...
(Multi-page thread 1 2 3 ... Last Page)
November 6th, 2008 05:26 AM
by John C[_2_] Go to last post
32 223
Validation of cell to enter data by Frank Kabel
Hi try using data validation ('Data - Validation).: - Select the cells in column A (assumption you start in A1) - enter the following formula in the data...
(Multi-page thread 1 2 3 ... Last Page)
March 9th, 2004 12:01 PM
by Peo Sjoblom Go to last post
31 900
Post New Thread


Display Options
Showing threads 21 to 40 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 09:57 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.