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
Sort anomoly by Hawthorne 53
My column A, "Account Description" is formatted as General; Column B, Fiscal Year, is formatted as Number. On a two level Sort, Col. A and then Col. B, all...
May 18th, 2009 11:21 PM
by Gord Dibben Go to last post
2 95
Ending in Macros by Evil with a K[_2_]
I am unfamiliar with the writing MACROs I rely specifically on recorded macros. My issue is I format and consolidate a large number of excel files prior...
May 18th, 2009 10:37 PM
by Gord Dibben Go to last post
2 114
Template Instructions by dd53
What do you call the pop up instructions embedded in the templates and how do you remove them when you save your changes? -- love life
May 18th, 2009 10:21 PM
by Gord Dibben Go to last post
4 169
Function Question by Having Issues
I know this should be easy, but I haven't done formulas for a while. I am trying to copy top to bottom of a spreadsheet via formulas instead of copying and...
May 18th, 2009 10:17 PM
by Gord Dibben Go to last post
5 166
autosum and page breaks by forward
autosum works unless I ask it to calculate across page breaks? ie =T1:T100? thanks
May 18th, 2009 10:03 PM
by Gord Dibben Go to last post
1 101
How do you change single digits to recognized double digits? by Evil with a K[_2_]
I asked earlier how to make a column display a two digit number instead of a single digit number (under 10) by adding a zero in front. The answer was to hit...
May 18th, 2009 09:19 PM
by Teethless mama Go to last post
4 135
Excel 2007 Conditional Formatting by Jordan
I am trying to apply conditional formatting to a column of numbers based on the value in the cell. If the number if greater than 1 I would like it to be...
May 18th, 2009 08:49 PM
by Jordan Go to last post
3 105
Making a row blink as a warning. by Anthony
I am setting up an excel sheet, so that it can help me know when instruments need calibartion or PMs. I want to make a row blink or flash.
May 18th, 2009 08:38 PM
by Reitanos Go to last post
2 120
Polynomial Trendline by Royi Avital
Hello. I found the Trendline function in Charts very useful. My question is: Are there equivalent functions? hat I mean, I know about "Trend" and "Linset"...
May 18th, 2009 08:01 PM
by Gary''s Student Go to last post
5 246
Group under Data Group and Outline Data not working. Help. by Michele
Use this function all the time, however, it is not working on one of my spreadsheets. Works on others. Do you know why?
May 18th, 2009 07:45 PM
by Dave Peterson Go to last post
2 240
How to combine, IF, AND, OR Functions by Simony32567
Hi all I need some help combining IF, AND, OR functions (if it is possible) What I am looking to do is: I want all the results to display in F70 I have...
May 18th, 2009 07:31 PM
by Pecoflyer[_346_] Go to last post
2 132
Find unique values using 2 variables by Tony7659
I have 2 columns of data: 1 numeric (with some " " from the formula) and 1 text. I need to find the count of rows with unique values in column 2 and numbers...
May 18th, 2009 07:30 PM
by T. Valko Go to last post
2 226
Copy linked worksheets formula to long by Ani K
How do I copy a folder with many worksheets and workbooks that have very long formulas that are linked.
May 18th, 2009 06:51 PM
by Sean Timmons Go to last post
1 139
count unique values if 2 variables by Tony7659
I have 2 columns of data, 1 numeric (maybe with "" due to formula) and 1 text. I need to count any rows with numeric values in column 1 with the same text...
May 18th, 2009 06:45 PM
by Bernd P Go to last post
3 185
HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL by FUNACH
NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6?
May 18th, 2009 06:44 PM
by Robert McCurdy Go to last post
5 158
formulas by FUNACH
need to average lowest 6 out of 10 cells?
May 18th, 2009 06:23 PM
by FUNACH Go to last post
2 130
Rich Text Boxes by SueDot
Is there a way to insert a rich text box into a worksheet? We need a box that basically works like a Word document - it will mostly be used to created...
May 18th, 2009 05:00 PM
by SueDot Go to last post
2 130
Look up functions by [email protected]
Hi, I am currently in the process of trying to return a value based on a data element being found with a specified date range. One element is the look up...
May 18th, 2009 04:52 PM
by T. Valko Go to last post
2 174
add-ins by Rynosun
I am using vista, there is no tools tab, however, in excel options for add-ins, the analysis toolpak is checked, but still is not appearing on add-ins menu...
May 18th, 2009 04:47 PM
by Sheeloo Go to last post
1 164
Unable to Spell Check in Excel by Microsoft User[_2_]
While Using Spell Check in Excel i am getting the message "Formula is too long" and hence Unable to check the Spell Mistakes. Kindly Reply back with...
May 18th, 2009 03:17 PM
by Sean Timmons Go to last post
1 117
Post New Thread


Display Options
Showing threads 10961 to 10980 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 12:45 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.