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
collapse rows into one by Vic
Each occurence of A has 20-30 rows of data appearing in columns B thru K. I need to collapse all rows into one per each occurence of A. Value in A appears...
September 21st, 2009 09:21 PM
by Dave Peterson Go to last post
2 130
blank = no formating, 95% Red, 95% Green by Go Bucks!!![_2_]
I need to conditionally format cells based on their value. These values are in percent. I want the following conditional formating rules: blank = no...
(Multi-page thread 1 2)
September 21st, 2009 09:18 PM
by Go Bucks!!![_2_] Go to last post
13 229
Balance sheet functions? by Behrens
I would like to add 2 columns and display the results in a 3rd column and keep a running balance. A "check" register is really what I would like to set...
September 21st, 2009 09:11 PM
by David Biddulph Go to last post
3 114
If IsError Help by Karin
My formula: =IF(SUM(Q20:R20)S20,"over budget",SUM(Q20:R20)/S20) If there is a division error on the last part, I need to have it return "" Not sure how to...
September 21st, 2009 09:04 PM
by Mike H Go to last post
1 87
2 macro help by puiuluipui
Hi, i have in a macro this part of the code that delete empty rows: Dim lRow As Long With Application ..ScreenUpdating = False ..Calculation =...
September 21st, 2009 08:46 PM
by Joel Go to last post
7 111
Excel 2007 NOT locking spreadsheet by Patrick
I have a few users complaining that multiple users are able to get into spreadsheets and modify them simultaneously. What would cause that to happen and how...
September 21st, 2009 08:16 PM
by Patrick Go to last post
0 100
Subtracting dates from two columns by Shannan
Hi, I am trying to find a formula that will subtract the dates from two columns and give me the difference in months. I had " =MONTH(AD15)-MONTH(Y15)", but...
September 21st, 2009 07:58 PM
by Bernard Liengme[_2_] Go to last post
5 106
How to recover an overwritten a file by mistake? by nsd
Hello, I have mistakenly saved / overwritten a file. I mean while savinga file I chose another file's name and when the computer asked that the file already...
September 21st, 2009 07:58 PM
by nsd Go to last post
3 259
Maintaining text data format in a pivot table by Eric
I am creating a simple pivot table with one field of values, numbers to be summed, and a second field, occasional two letter alpha codes which are...
September 21st, 2009 07:33 PM
by Eric Go to last post
0 121
macro-file could not be found by puiuluipui
I haved a macro that copy information from a closed workbook. If the macro doesn't find the closed workboo, i receive an error '1004': file......could not be...
September 21st, 2009 07:31 PM
by puiuluipui Go to last post
2 120
Take one sales order and compare all ship dates for that order. by Mudassir Ahmed
Hello I am pulling my hair for a solution for this problem. I have a data sheet with information on ship-dates for each ship-to address. Each ship-to...
September 21st, 2009 07:28 PM
by Luke M Go to last post
1 111
divide and round up by Pammy
I have a formula: c5/4 I want a formula to divide: c5/4 then round up to a whole number. example: if the answer is 17.3 I want the answer to be 18.
September 21st, 2009 07:01 PM
by Eduardo Go to last post
2 115
Duplicate cells by Yvonne L.
I need three different cells on the same worksheet to say the same thing. For example: I type a name in one cell and the other two cells duplicate the...
September 21st, 2009 06:53 PM
by Eduardo Go to last post
1 101
Embedded Excel Objects in PowerPoint resize after editing by Barb Reinhardt
Since going to Office 2007, we've seen a lot of issues with Excel objects resizing in PowerPoint once they are edited. Does anyone know of a way to ensure...
September 21st, 2009 06:41 PM
by Barb Reinhardt Go to last post
0 114
Text function MID, RIGHT, LEN by tomjoe
Hi I try to extract part of a text: I want to extract the numbers 300, 200 and 5 in the column to the right of the textstrings under. MY WORLD - AUSTRALIA...
(Multi-page thread 1 2)
September 21st, 2009 06:08 PM
by tomjoe Go to last post
11 195
how do i set up opening a file from a cell in excel spreadsheet by Scott
I am trying to link files to a spreadsheet, I want to be able to type a file name into a box and then have a formula or macro to open up that file. these...
September 21st, 2009 06:01 PM
by Jacob Skaria Go to last post
1 136
Pivot Table - add new group to original data by Phippsy
When you group in a pivot table and create a new fieldin the field list can this field be added to the original data?
September 21st, 2009 06:00 PM
by Jim Thomlinson Go to last post
1 108
Scripting Help by Jeremy
I am using a color function =ColorFunction(A2,A9;AA9). Is there a way to write a script or something like to where if the wrong color is selected you could...
September 21st, 2009 05:57 PM
by Jim Thomlinson Go to last post
1 113
Using nesting in the 64 IF function in Excel 2007 by Garry R
I'm trying to have 20 arguments in the IF function and it will only let me do 7. I thought excel 207 allowed 64. What am I doing wrong?
September 21st, 2009 05:46 PM
by GINN Go to last post
4 133
Function to put worksheet name in cell returns text, need number by Pennyc
I found the following great formula on this website to put my worksheet name into a cell on that worksheet. (this is in Cell L2 of each...
September 21st, 2009 05:44 PM
by Pennyc Go to last post
5 106
Post New Thread


Display Options
Showing threads 13001 to 13020 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 10:39 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.