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
how do I create independent results? by pbart
Brute force and ignorance but it does it. Extending to more cars/drivers gets very tedious. A little more finesse anyone. Sub assignDriver()
March 29th, 2010 08:11 PM
by pbart Go to last post
0 103
Networkdays and misleading results from blank column by Rosemarie
Hello, I am working with two columns of dates and need to work out the number of working days between two dates, column A and column B with result in Column...
March 29th, 2010 07:49 PM
by T. Valko Go to last post
3 122
Count # items in ColA if blank in ColB by Nadine
I need to count the number of items in ColA that match a certain criteria in ColA and are blank in ColB. Any ideas? Thanks. Nadine
(Multi-page thread 1 2)
March 29th, 2010 07:40 PM
by Nadine Go to last post
11 197
count if for blanks with 'or' by Steve Stad
Can you use the 'or' with a countif to count blanks -- if so can you tell me how? For example trying to count blanks in a column of data where the range, eg.,...
March 29th, 2010 07:14 PM
by T. Valko Go to last post
3 109
COUNTIF for 2 columns by b1llt
I'm trying to set a parameter of the following in a formula in column J: =COUNTIF($C:$C,$B300) That also only counts the number of times in column J where a...
March 29th, 2010 06:52 PM
by b1llt Go to last post
7 208
Doing a countif against a substring of the range to be scanned by jetboy2k
I need to see how many cells in a particular range have a substring that matches the text against which I'm searching. So, for example, I've tried the...
March 29th, 2010 06:24 PM
by jetboy2k Go to last post
1 111
SUMIF with NAME RANGE by Big_Tater[_2_]
I'm really struggling with this and I know someone here can help with this formula. I'm not sure what I'm missing. I have 2 worksheets ('Monthly Report'! and...
March 29th, 2010 06:24 PM
by Gary''s Student Go to last post
1 126
Multiple conditional formating for one cell by tech1NJ
I have a workbook with several sheets. Sheet1 has several hundred rows of text. Some of the same text will appear in multiple rows of Sheet1. On Sheet2 I...
March 29th, 2010 05:37 PM
by tech1NJ Go to last post
2 142
How do I page break in the middle of a row in Excel? by Carolyn Fiutem
I would like my document to fill the whole page and not just a 1/2 - 2/3 of the page due to the height of the row.
March 29th, 2010 05:29 PM
by Gord Dibben Go to last post
1 146
VALUE appearing (referencing blank cell) by Mark D
Hi Guys, sorry for again posting on here but this reoprt will be the death of me. I have 2 cells that have the following formlas IN C45 ...
March 29th, 2010 05:28 PM
by T. Valko Go to last post
3 114
I need to copy half of the info in a cell... by BoDuke1028
I am trying to make a song book after importing data into Excel. The title of the song and the artist are in the same cell, seperated by a double space. Is...
March 29th, 2010 05:16 PM
by BoDuke1028 Go to last post
4 129
MSNstockquotes option quotes by hawleyj
Have asked question several times at different forums with no answers. Maybe I'm the only person in the world using this function? Option symbols were...
March 29th, 2010 04:36 PM
by hawleyj Go to last post
0 84
Creating column by AAA1986
I would like to create a column that automatically adds one for each row. Ex. 2001, 2002, 2003, 2004
March 29th, 2010 02:13 PM
by Ashish Mathur[_2_] Go to last post
1 123
Help with IF stament (getting result FALSE in some cases) by Mark D
Good morning everyone. I have the following calculation that is causing me a problem =IF(G10970%,SUM(G90-G96)*AVERAGE('Base...
March 29th, 2010 01:17 PM
by Jacob Skaria Go to last post
9 121
=vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) giving #value! ???????? by Harvey Tod
Hi I have a problem using vlookup between 2 large spreadsheets. =vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) where a1:a835 ia a list of codes on worksheet 1...
March 29th, 2010 11:50 AM
by Eduardo Go to last post
2 113
Data Validation List from a Dynamic Named Range on Another Workshe by Jeremy
Hello all. I have searched all over the web for an answer to this question and I've come to the conclusion that there is either a problem with the way I've...
March 29th, 2010 09:26 AM
by Roger Govier[_8_] Go to last post
5 293
Conditional Sum - Moving Average by Elton Law[_2_]
Dear Expert, Want to calculate Moving Average in this format. But Sum is conditional Say B2 to G2 are dates like this. Say B3 to G3 are the prices. A3 is...
March 29th, 2010 04:53 AM
by Joe User[_2_] Go to last post
6 170
SUMIFS using a text range by Ziggy
I am still new to Excel 2007. I want to start using SUMIFS for their efficiencies over array formulas. They don’t seem to work the same. I want to sort by Dep...
March 29th, 2010 01:35 AM
by Ziggy Go to last post
2 149
Why can't I use the MONTH function within the SUMIFS statement? by djhunt77
I have a Detail worksheet with three named ranges: Category, DateOfService and Amount. I have a Summary worksheet where I am trying to summaries the amounts...
March 29th, 2010 12:36 AM
by djhunt77 Go to last post
5 195
Changing Content in one coulumn using given content in another by Colin Hayes
Hi All I have a small puzzle. In one column , I have a list of various components , many of which appear multiple times. In another , I have a list of their...
March 28th, 2010 11:28 PM
by Colin Hayes Go to last post
4 177
Post New Thread


Display Options
Showing threads 1721 to 1740 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:13 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.