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
can I auto email someone from excel if a reference value prompts i by Paaulw
Is it possible to create an auto email if a value within an excel cell falls within a particular parameter.
September 22nd, 2008 11:45 PM
by JP[_5_] Go to last post
4 197
Locking cells but keeping Grouping Function available by Cheriti
I am trying to lock cells in a worksheet to protect the formulas but want the users to still be able to use the grouping function already incorporated- does...
September 22nd, 2008 10:44 PM
by Gord Dibben Go to last post
1 172
If Function with Dates by Bev
I have the following formula - which works correctly, =IF(F6--"2005-01-01","No","Yes"), F6 is a date ... my question is, what does the -- signify in the...
September 22nd, 2008 10:25 PM
by Peo Sjoblom[_2_] Go to last post
1 208
Pivot Tables Based on Filtered Data by Michael[_3_]
Hi Folks - I created numerous pivot tables from a dataset. I now need to create the same number of pivot tables for a filtered subset of the dataset. Is...
September 22nd, 2008 10:21 PM
by Dave Peterson Go to last post
1 167
Sumproduct-multiple criteria = and not = by Tasha
Ok....this is my problem.... have multiple criteria that I need to set up a SUMPRODUCT function for, equalling some and not equalling some. This is one...
September 22nd, 2008 10:10 PM
by Spiky Go to last post
4 163
highlight selecting by SteveDB1
Hi all. I'm looking to find out what the colored "boxes" are called when we enter a worksheet function, and select either a single cell, or a range of...
September 22nd, 2008 09:47 PM
by Spiky Go to last post
3 108
Max problem by BNT1 via OfficeKB.com
Hi In a range of cells i have the formula, =IF(INDIRECT("'"&(B1)&"'!c5")="",NA(),INDIRECT("'"&(B1)&"'!c5")), this returns N/a when c5 is empty. I have an...
September 22nd, 2008 09:36 PM
by BNT1 via OfficeKB.com Go to last post
2 139
Excel send emails by jc132568
Dear experts, Can excel send emails automatically when a number in a particular cell falls under a particular value? regards jc132568
September 22nd, 2008 09:24 PM
by Ron de Bruin Go to last post
1 119
Date expires in 2 years by Catguam
I am looking for a formula that would mark the cell as "EXPIRED" if the date is 2 years or more. My scenario is if a person is trained I need to be notified...
September 22nd, 2008 09:01 PM
by Catguam Go to last post
2 120
Adding contents of another cell to the middle of a line of text by [email protected]
To save me HOURS of work, i really need to know if there is a way to replace a part of a line of text with the contents of another cell. For example if i have:...
September 22nd, 2008 08:06 PM
by Peo Sjoblom[_2_] Go to last post
1 271
How do I merge colums with data by up4ms
I have imported data to excel. The problem is the phone number is broke into three separate colums. Also the customer first name and customer last name is...
September 22nd, 2008 07:52 PM
by Peo Sjoblom[_2_] Go to last post
8 91
Nested Functions for Conditional Formatting Formula by RandyH
I'm trying get the right syntax figured out for the following so I can insert it as a formula for conditional formatting to color a cell red or yellow. Not...
September 22nd, 2008 07:28 PM
by Mike H Go to last post
3 102
HELP!!! TIME SENSITIVE by Walt
Hi, I have a worksheet that is filtered. I need to create multiply worksheets that can show information based on the initial worksheet but with different...
September 22nd, 2008 07:25 PM
by Walt Go to last post
5 114
Reconciling by Hscott
I have a very large file that we have to reconcile monthly. There are two worksheets, one is an A/P aged invoice and one has a list of all of our payments...
September 22nd, 2008 07:05 PM
by Spiky Go to last post
3 134
Change color of rows every time value in first column changes by Natasha
Hi, I am using Excel 2003. I have a spreadsheet with one-to-many relationship data. First column contains plot numbers that repeat if more than one species...
September 22nd, 2008 06:55 PM
by T. Valko Go to last post
2 277
[XL 2003/07] Standard Error of Moving Average by Vincent Isoz
Hi, I just would like to know what some of you think about the calculation of the "standard error" avalaible in the Moving Average tool visible in the...
September 22nd, 2008 06:37 PM
by Vincent Isoz Go to last post
0 116
COUNTIF....how to use =0 but 9 as CRITERIA by Jay
I cannot figure out how to use two criteria with the COUNTIF function. Here is what I need to accomplish: I have a list of 2000 numbers in column A, the...
September 22nd, 2008 06:10 PM
by Jay Go to last post
3 111
Filter by Deborah
I have a worksheet with 716 rows I need to select every 17th row. How do I do that?
September 22nd, 2008 06:02 PM
by Roger Govier[_3_] Go to last post
6 102
Need to rank values with ties by MichaelZ
Could someone provide a duplicate ranks with decimal fractions algorithm. I need to rank data that has tied values, but I want a ranking that is unique for...
September 22nd, 2008 05:44 PM
by Mike H Go to last post
9 137
Fill cell based on # of days by spezticle
My spreadsheet starts on the 17th of september. I'd like to have every cell filled with red that =b1 (9/17/08) +14. so, 9/17 10/1 10/14 10/28 all get...
September 22nd, 2008 05:00 PM
by Spiky Go to last post
3 122
Post New Thread


Display Options
Showing threads 20061 to 20080 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:21 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.