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
Formula for Minimum/Maximum by LaDonna Brooks
Is there a formula for the following situation? 1A - 10,000 1B - AL 2A - 15,000 2b - GA 3A - 35,000 3b - SC You have a min/max of 12,000/25,000 AL....
June 24th, 2009 05:57 AM
by Fred Smith[_4_] Go to last post
2 162
2 Dependent lists based on the same list by EZ[_2_]
How can I have a 2nd dependent list based on the same main list. I have my main 'category' list, then I created my 1st dependent list 'Products' both are...
June 24th, 2009 03:48 AM
by EZ[_2_] Go to last post
2 135
Finding Circular References by Philip J Smith
Hi. I have a workbook that displays "Circular references" in the lower left corner. I have checked each worksheet but the message does not change to include...
June 24th, 2009 01:46 AM
by Ashish Mathur[_2_] Go to last post
2 129
Formula (Excel 2003) by Newfie809
Hi there, I am looking for help with a spreadsheet formula, I have 54 Worksheets and on Line C6 of each worksheet is the Description and on E6 of each...
June 24th, 2009 01:38 AM
by Ashish Mathur[_2_] Go to last post
6 146
Date comparisons within AND() functions by Sambonator
I'm trying to compare dates within an =AND() function but having trouble. I can get =IF() to work but not =AND(). E.g. Cell A1 = 6/15/2009 I can do...
June 24th, 2009 12:58 AM
by Bernie Deitrick Go to last post
1 150
Using If function with text values by IF function with Text
I'm trying to use an if function with the logical test being, for example, =IF(A10=apples, , ) Is there anyway to utilize the IF funciton using a name or...
June 24th, 2009 12:26 AM
by Teethless mama Go to last post
5 141
Paste Special Glitch by Lady Success
When more than 2 instances of Excel are open, the Paste Special views the data as an object when you try to copy the data. There are times when I need 2...
June 23rd, 2009 11:45 PM
by Dave Peterson Go to last post
1 116
OFFSET and MATCH functions for cells by Neecy
I have a spreadsheet and reference file in which I am attempting to import the values of a cell from the reference file into the cell of the spreadsheet...
June 23rd, 2009 10:47 PM
by Bernie Deitrick Go to last post
4 107
Countif issue by Stuck
Here's what I have: =COUNTIF(OFFSET($P$9,0,0,(COUNTA($A:$A))-2,1),$P3) column A is a number cell P9 is a formula that produces text "G" cell P3 contains the...
June 23rd, 2009 10:29 PM
by Stuck Go to last post
3 145
how to link multiple columns to multiple worksheet totals / functi by Chieftan
Hi, I havea work book with 13 worksheets ... 12 worksheets for Jan to Dec. They are all identical structure, with vaying perfomance data entered. I have...
June 23rd, 2009 10:11 PM
by Chieftan Go to last post
4 130
Assigning strings number values and adding them together by JRD
Example: (see explantion below) Column A Answer 1 LMS LADprox 3 (2 for LMS,0 for LAD prox and...
June 23rd, 2009 10:08 PM
by JRD Go to last post
2 129
Auto Arrange by Kanmi
How can I arrange names aphabetically like from A-Z without retyping them on the column. Thanks for your time
June 23rd, 2009 09:56 PM
by Marcelo Go to last post
2 118
Sumproduct - number & text by Kashyap
Hi, I have number in colB & text in Col C,D I was trying sumproduct to go the data from colD looking at Col B & C something like below.. But result is...
June 23rd, 2009 09:44 PM
by T. Valko Go to last post
8 124
VLOOKUP FORMULA by Kanmi
I TRIED TO CREATE VLOOKUP FORMULAR TO INSERT DATA FROM ONE SHEET TO ANOTHER SHEET BUT IT WASN'T GIVING ME WHAT I WANT. EXAMPLE I want data entered in sheet1...
June 23rd, 2009 09:16 PM
by Teethless mama Go to last post
1 101
FORMAT by Tony7659
Hi, I have the table below for 2008/2009. Now, in another sheet in cell A1 I have the "Year" and in cell B1 I have the "Period". I need a formula to find the...
June 23rd, 2009 09:01 PM
by Tony7659 Go to last post
8 176
Counting number of occurances of a word by Chris the researcher
I need to count the number of times a word shows up in a given cell for which the number will then show up below the name of the word. ex. ...
June 23rd, 2009 08:49 PM
by RagDyer Go to last post
5 121
Conditional Formatting Problem by mrogozinski
One of my conditional formatting rules is as follows: If value of the cell is between 4.5 and 5.0 then format the cell "green". The problem is the formula...
June 23rd, 2009 08:46 PM
by mrogozinski Go to last post
8 108
Automatic Date Aupdate by Kanmi
I want to set row above that automatic change date when i change data on each of the column. For example Last Update: 6/14/2009 5/19/2009 5/19/2009 ...
June 23rd, 2009 08:43 PM
by Gord Dibben Go to last post
4 132
data validation drop down list format by Pwinkle
Hi, I created a data validation range that users enter information into to create the drop down list. The user does not need to enter information into all...
June 23rd, 2009 08:42 PM
by Shane Devenshire[_3_] Go to last post
1 127
"Count non blanks" if cells don't equal certain values by thegymshoe
I need to figure out a formula that counts the non blanks in a row, but omits non blanks equalling "UA", "UE" and "AA". Can anyone give me a simple formula...
June 23rd, 2009 08:29 PM
by RagDyer Go to last post
6 124
Post New Thread


Display Options
Showing threads 9841 to 9860 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:35 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.