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
CountIf to determine Date - 3 yrs by Brent E
Good day, I have a series of data including a date col. What is the criteria statement I should use in the CountIf formula to determine the no. of records...
November 21st, 2008 02:36 AM
by Chris Lavender Go to last post
3 146
macros by Amanda
I am trying to do my Excel homework. And they are asking me to record a macro. I am unable to record a macro in Excel, but I am able to record one in Word. I...
November 21st, 2008 02:28 AM
by Barb Reinhardt Go to last post
1 77
Formulas by Saadia
I have an excel spreadsheet, where i keep track of how many estimates were sent out by our estimators, the date it was sent out, approved, started,...
November 21st, 2008 02:27 AM
by Chris Lavender Go to last post
4 168
formulas by milo
hey i am going a sreadsheet for heat loss calcs but can any one tell me how to multiply by the power example: .05^1.3 i tried doing tht in the cells but it...
November 21st, 2008 02:24 AM
by Chris Lavender Go to last post
3 96
If excel sheet protected, combo boxes won't work by kiwimark
Can anyone help. I have an excel sheet with protection turned on, when I do that I can't select data in my combo box drop downs.
November 21st, 2008 02:18 AM
by Chris Lavender Go to last post
2 110
Goal Seek in a Macro by mrogge2895
I am attampting to write a macro where I use goal seek to solve for price based on the desired IRR input. When I bring up goal seek, it forces me to...
November 21st, 2008 12:37 AM
by galimi Go to last post
1 125
November 21st, 2008 12:34 AM
by Shane Devenshire[_3_] Go to last post
3 96
Auto numbering inserted rows. by Sherrill
I need to have newly inserted rows auto-number upon insertion. I've searched for any tips and the closest I can find is the List function on the Data menu,...
November 21st, 2008 12:23 AM
by Shane Devenshire[_3_] Go to last post
1 93
Save Pivot Table Format in 2007 by Joyce
In Excel 2003 you could save a Pivot table format and apply other worksheets to it, can you do that in 2007? If so how?
November 21st, 2008 12:12 AM
by Joyce Go to last post
2 104
Auto Copy/autofill Text from sheet to sheet if meets criteria by Joyce
Hello! Using Excel 2007 I want to automatically take text from one worksheet and display it on a different worksheet if it meets a text criteria. IE, if...
November 21st, 2008 12:05 AM
by Joyce Go to last post
0 94
Printing UserForms by leerem
I have produced several reports which is displayed on a Userforms named Reports1 - Reports7, is it possible to then print these report individually as a...
November 20th, 2008 11:35 PM
by Wigi Go to last post
1 78
Dispaly results, rather than a formula by Donna
I have several worksheets in a file. The first worksheet is what i call "H"... i enter pertinent info that will be used in other worksheets... things like...
November 20th, 2008 11:18 PM
by Donna Go to last post
2 77
Cell format problem by Carey
I am doing pivot table reports in Excel 2002, and the there are several numbers that are not sorting in numerical order. Instead they appear at the top of...
November 20th, 2008 11:18 PM
by Carey Go to last post
2 68
Save changes? even when you've made none by Donna
Everytime I close a certain file, it always asks me if I want to save changes, even though I didn't do anything. I just opened the file, looked at, then...
November 20th, 2008 11:17 PM
by Donna Go to last post
3 79
subtract a range from an added range by Marge
I want to add cells A1:D1 then subtract the sum of cells A2:D2 to get a total and I can't get it to work. Please help!
November 20th, 2008 11:09 PM
by Marge Go to last post
2 90
odd behavior by Rich[_20_]
Hi, I have a problem with a particular workbook I'm building. If I try to amend a formala, instead of the result, the formalu is visible in the cell, and no...
November 20th, 2008 11:02 PM
by David Biddulph Go to last post
2 81
Comparing information on 2 worksheets by Lee
I am trying to compare certain information on 2 different worksheet to make sure both are listed. Is there an easy way to do this. Possible turn the cells...
November 20th, 2008 10:57 PM
by Luke M Go to last post
1 71
Dynamic Chart Question by DoubleZ
In Excel 2007 I have created a dynamic chart. The data is working out just fine, however the horizontal axis labels are not correct. For instance, in one...
November 20th, 2008 10:51 PM
by DoubleZ Go to last post
0 110
count / match by Rachel
Hi, Column A Column B John = return value of 1, if matches, else 2 John Smith Bob I like to have a formula in column b, if item in A1, "John" matches
November 20th, 2008 10:33 PM
by T. Valko Go to last post
1 88
Filtered Counting by Rob
Hello I found an excellent formula to count unique values in a given column and it even modifies the count when they are filtered. Here's the formula I am...
November 20th, 2008 10:27 PM
by T. Valko Go to last post
5 95
Post New Thread


Display Options
Showing threads 31001 to 31020 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 06:12 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.