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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Max only if the last month is hte highest by Jim
Hello, When referencing a row of data (say, A:K), I know I can =MAX for the highest number on this row. What I would like is a formula that will return the...
February 4th, 2010 12:22 AM
by Jim Go to last post
4 96
Linking blank cells by --Viewpoint
I created a workbook for others to use. The first sheet in the Excel workbook has general information that I linked to cells on other worksheets. However,...
February 4th, 2010 12:21 AM
by Gord Dibben Go to last post
1 113
Formula to sum values extracted from string by Paul Martin[_3_]
Hi all I'll preface this by pointing out that I do NOT want to use text to columns, nor a VBA solution. I'm looking for a formula alternative - maybe an...
(Multi-page thread 1 2)
February 4th, 2010 12:20 AM
by Paul Martin[_3_] Go to last post
10 267
Can I use a named range in SUMPRODUCT? by Joe M.
I am trying to use a named range in SUMPRODUCT to shorten my formula. My named range is called Data_Sel_WA. My formula is:...
February 4th, 2010 12:18 AM
by T. Valko Go to last post
2 120
If Question by Kiwi
Hi everyone Hope this isn't a silly question (as think I may have made it harder in my head than it needs to be! given all the formulas I'm putting in are...
February 4th, 2010 12:04 AM
by T. Valko Go to last post
4 119
refer to whole column by Ken
Hi! How do I refer to a whole column by a number of a cell? For example, if a number of a certain cell is 1, then the column will be A:A. If a number of a...
February 3rd, 2010 11:58 PM
by Jim Thomlinson Go to last post
2 127
Sumif() help by sjmdhd
I have two worksheet, and I want to do a Sumif() function in sheet 1 but the data is in sheet 2, I had no problem using this function in excel 2003, however;...
February 3rd, 2010 11:49 PM
by Fred Smith[_4_] Go to last post
1 110
Does Excel file retain link to template? by Sherlock
In Word a document based on a template retains a connection to that template. Is that also true in Excel? Or does an Excel file based on a template stand...
February 3rd, 2010 11:48 PM
by Gord Dibben Go to last post
1 100
February 3rd, 2010 11:46 PM
by Gord Dibben Go to last post
1 124
Variance Calculations by Jim
Hello, Thanks in advance for the help. I have a worksheet that lists account names in column A. In column B I have sales from January, column C is sales...
February 3rd, 2010 11:45 PM
by Joe User[_2_] Go to last post
2 93
Changing Multipule Graph's Source Data by TysonE
So I have 8 graphs on one tab that reference data on another. I highlighted both tabs, click copy, and I was hoping the graph's source data would move itself...
February 3rd, 2010 11:41 PM
by TysonE Go to last post
0 171
"What-if" formula for either a manual entry and automated entry by MZ
A formula calculates a tax bracket based upon taxable income and one of four filing statuses; I would like to be able to either manually enter an amount of...
February 3rd, 2010 11:29 PM
by Niek Otten Go to last post
3 148
How do I edit my chart in 2007?? by Tia
I have been using Excel XP and I would enter my data, get my chart and paste it into word. Then I would be able to edit the chart. Now, when I get it into...
February 3rd, 2010 11:24 PM
by Tia Go to last post
0 91
Tuesday by JDay
I have a spreadsheet where i need to count the number of the letter "T" in a row. One row in particular however, will default to "Tue" as though I am...
February 3rd, 2010 10:58 PM
by Otto Moehrbach[_2_] Go to last post
1 99
SUMIF with multiple columns in sum range by Joe M.
I have an array that I need to sum multiple columns depending of the value in Col D. The ws containing the array is called 'data'. I must sum cols F,J,N,R,V,Z...
February 3rd, 2010 10:50 PM
by T. Valko Go to last post
3 136
Searching by Rich
Hi, I posted a message yesterday...yet cannot find it this morning...it would be really useful if I could simply search for "questions posted by me". Simple...
February 3rd, 2010 10:47 PM
by John Go to last post
2 199
Excel 2007 table formatting by Cindy[_8_]
Hi - I can't figure out why this is happening - but some of our Excel 2007 worksheets with Format table options applied --- the formatting gets messed up...
February 3rd, 2010 10:46 PM
by Cindy[_8_] Go to last post
0 103
Inserting date from formuls by TechGuy
Hi all, I have a data verification drop down created and I am trying to make the date poplate in certain cells depending on my drop down choice. The main...
February 3rd, 2010 10:30 PM
by Gord Dibben Go to last post
1 85
fraction into date by pm_sam
hi all members... I have excel 2007 and when I enter a number like 6/33 it turns it into Jun-33. this number 6/33 is being copy from one note 2007 and pasted...
February 3rd, 2010 10:30 PM
by Bill Sharpe Go to last post
3 102
Lost Arrow key navigation by Julio
I used to be able to navigate from cell to cell in a worksheet using the up, down, left, right arrow keys. I'm not sure how I changed it, but now when I hit...
February 3rd, 2010 10:21 PM
by Mike H Go to last post
1 160
Post New Thread


Display Options
Showing threads 6001 to 6020 of 139764
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:28 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.