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 Reverse Sort Order Last Post Replies Views
sumif? countif? by Aaron Hodson \(Coversure\)
Hello, I need some help with the following: I require cell K3 (in worksheet named 'brokers') to count the number of times the data in A3 matches those in...
September 3rd, 2008 04:35 PM
by Pete_UK Go to last post
3 125
'if' formula selecting a cell from a table by Aaron Hodson \(Coversure\)
Well, it is to me. I am trying to create a rating matrix within excel, that can produce rates from a table. I have been searching through the forums for a...
October 31st, 2007 04:42 PM
by Aaron Hodson \(Coversure\) Go to last post
3 90
Conditional Formatting - further assistance required by Aaron Hodson \(Coversure\)
Hello all, I require to format 17 cells in a row ie: A1:Q1 to turn red, dependent on text being inserted in K1 Please help, Thanks Aaron
October 8th, 2007 01:16 PM
by Aaron Hodson \(Coversure\) Go to last post
2 50
Text to dictate colour of the cell and/or row by Aaron Hodson \(Coversure\)
Hello all, I hope someone can help. I am trying to enter a formula to tell my spread sheet that if a value (any) is entered into a particular cell, I would...
October 5th, 2007 10:38 AM
by Aaron Hodson \(Coversure\) Go to last post
2 185
sumproduct and countif in one formula by Aaron Hodson \(Coversure\)
Hello, I have been trying for days to get the following function to work: =SUMPRODUCT((JAN!G:G=C18)*(JAN!M:M="y"))=COUNTIF(JAN!B:B,C2) The Sumproduct...
December 4th, 2008 11:27 AM
by Aaron Hodson \(Coversure\) Go to last post
2 110
countifs on earlier version of excel by Aaron Hodson \(Coversure\)
Hello, I have been working on 2007 excel and used the below formula: =COUNTIFS(JAN!G:G,B14,JAN!B:B,C2) I have just noticed upon saving that this will not...
January 21st, 2009 09:53 AM
by Aaron Hodson \(Coversure\) Go to last post
5 115
SUMPRODUCT in earlier verions by Aaron Hodson \(Coversure\)
Good morning, I have the below formula which appears to work fine in 2007 but not with earlier versions of excel. Could someone please...
January 21st, 2009 09:52 AM
by Aaron Hodson \(Coversure\) Go to last post
5 86
2007 excel options 'greyed out' by Aaron Hodson \(Coversure\)
Hi all, I seem to have a problem and not sure how to rectify, I am trying to do some 'conditional formatting' but the option to select this in the tool bar...
January 27th, 2009 04:55 PM
by Shane Devenshire[_3_] Go to last post
2 368
countif compatibility 2007 and earlier versions by Aaron Hodson \(Coversure\)
Hi Mike, Thanks for the info, sorry for the delay,,, Just completed all sheets but have a problem with this function, I am using 2007, so the coutifs work...
January 27th, 2009 04:52 PM
by Shane Devenshire[_3_] Go to last post
2 81
using 3 tables in one spreadsheet and utilising index formula to retrieve information by Aaron Hodson \(Coversure\)
Hello everyone, I have a table set up for which is use the below code to retrieve data, depending on the info I...
November 5th, 2007 02:40 PM
by Aaron Hodson \(Coversure\) Go to last post
2 61
copying equations from one file to another by Aaron Jensen
Hello everyone. I have a question regarding copying equations from one worksheet to another. All of my worksheets in both files have the same name. Is there...
October 15th, 2003 08:21 PM
by Bernard V Liengme Go to last post
1 105
Using Solver with the 'Frequency Array' Function by Aaron West
I'm having trouble setting up Solver to work with a Frequency array. I'm wanting to set the Adustable Cells as the Bin values for the array, set contraints...
July 27th, 2006 08:53 AM
by Aaron West Go to last post
0 62
Limitation on MID function? - very large string by Aaron Z
I have a cell that contains several thousand characters of fixed-length data. I've been able to parse out various values using a file layout that I refer to...
September 12th, 2007 10:05 PM
by Peo Sjoblom Go to last post
4 82
Counting using OR? by [email protected]
I have 2 columns and want to get the count of each row where either one of columns in that row is = "Y" and if both are = "Y", it still only counts as one "Y"....
February 20th, 2007 05:47 PM
by Bernd Go to last post
6 50
Restructuring records into a list by [email protected]
Hello, I currently have a long series of records in the structure Descriptor Value ABC 123 DEF 456 GHI 789 ABC ...
December 21st, 2005 10:08 AM
by mcg Go to last post
2 111
Data Validation by AaronMcG
Hello all, I am not an expert with excel. But i do use it very frequently. And lately i've been setting up a project for my company to standardize...
April 17th, 2009 05:16 PM
by Kassie Go to last post
1 63
Top half of covariance matrix by aaronmsl
Hi So I've used data analysis to produce a covariance matrix, however it only generates the bottom half of the matrix. Since I want to use the matrix with...
April 18th, 2010 05:15 AM
by Mike Middleton[_2_] Go to last post
1 256
Formula help by Aaron[_11_]
I am looking for a way to round up a number if the decimal number is greater than .25. I looked at the ROUND and CEILING functions but can't seem to put a IF...
November 13th, 2008 05:27 PM
by Pete_UK Go to last post
3 57
can i delete "lookup" from right-click in excel 2003? by aarria
Is there a way to edit what appears in my "right-click" function in Excel 2003? One of the options that appears in the right click option is "Lookup" which is...
February 22nd, 2005 06:34 PM
by Ron de Bruin Go to last post
1 143
Compare and count if data elements on two worksheets are similar by aascasacspas
I need to compare text in a range of cellw on worksheet 1 to a cell in worksheet 2 AND text in another range of cells in worksheet 1 to another cell in...
May 21st, 2009 04:59 AM
by Teethless mama Go to last post
1 108
Post New Thread


Display Options
Showing threads 821 to 840 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 02: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.