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
Involved VLookup Function by andiam24
Hello, I'm using the following formula to pull a value from one of three worksheets based on the criteria: - lookup value is within the range 0.2 and...
May 20th, 2009 12:20 PM
by andiam24 Go to last post
3 141
Help on Formula by Karthik
I've data copied from a .CSV file and pasted it to an excel sheet. Column A-G is copied from .CSV File and Column H is calculated using formula (=D1/F1/24) to...
May 20th, 2009 09:31 AM
by Max Go to last post
5 293
Making a formula to copy cells in a particula way by Dingerz
Hi I have hundreds of cells like this. All the way down a column H8D-70GDT3322 H8D-70GDT3330 H8D-70GDT3331 H8D-70GDT3400 I want it to look like this (SEE...
May 20th, 2009 07:14 AM
by Max Go to last post
4 197
"num#" errors .. how to average a group with a "num#" error by Byron
doing a monte carlo simulation and many times it will register an error specifiaclly a num# error .. I then average and do other stuff to the calculations,...
May 20th, 2009 04:32 AM
by Teethless mama Go to last post
3 225
Excel 2007 crashes when perform SAVE AS to Excel 97-2003 by Bagia
For some reasons, I cannot perform SAVE AS to Excel 97-2003 format whenever I copy a worksheet that contains pie charts with data to a new workbook. First...
May 20th, 2009 04:21 AM
by Bagia Go to last post
0 181
Multiple Insert Copied Cells routine by Matthew
Many times I find myself having to repeat the Insert Copied Cells routine, but once you copy a set of rows, and choose the Insert Copied Cells from Right...
May 20th, 2009 03:46 AM
by Rick Rothstein[_2_] Go to last post
1 206
Help with SMALL formula. by Scott
I have a range of 144 rows. A1:A144 contain names, B1:B144 contain values. I've successfully used the SMALL formula to sort the data 1 through 144, but I'd...
May 20th, 2009 02:44 AM
by Max Go to last post
6 198
Last Cell Reset Command- Built In by Matthew
In Excel 2003, someone wrote an Add-In that cleaned up empty formatted cells and reset the last cell. It worked pretty well. After upgrading to Excel 2007,...
May 20th, 2009 01:34 AM
by Matthew Go to last post
0 200
How do I access the read-only box on my disc? by How to uncheck read-only from my disc
The read-only box on my excel spread sheet is not checked. But when I save it to my disc, then enter changes on it, I get a message that the folder is...
May 20th, 2009 01:04 AM
by Sheeloo Go to last post
1 155
Editing conditional formatting formula, arrow keys insert range. by Bob Arnett
Whenever I am entering or editing a conditional formatting formula, if I try to move to another place within the formula using the arrow keys, a range is...
May 20th, 2009 12:56 AM
by Gord Dibben Go to last post
3 144
countif using two conditions by NWO
Hello. I read all of the COUNTIF , AND threads but did not find a solution to my problem. - I have a column of dates on one worklsheet - I'm trying to...
May 20th, 2009 12:47 AM
by Max Go to last post
1 147
How do I repeat specific rows on some pages and then change for ot by Worker Bee
How do I repeat a specific row for 18 pages and then change the repeating row for 7 other pages in the same worksheet?
May 19th, 2009 11:52 PM
by Gord Dibben Go to last post
1 278
How to handle something like this by DK
I have a log at work with safety items. I log persons name, glove, safety glass, ect. My "objective" is to create some type of excell sheet to gain tallys of...
May 19th, 2009 11:40 PM
by DK Go to last post
0 161
Hide a formula result until cell has been filled by Sammy
Hello, I'm new to excel, I'm trying a simple formula (=40-C3-0.2) & I'm wondering if it is possible to hide the result of my formula until I had added an...
(Multi-page thread 1 2)
May 19th, 2009 11:26 PM
by Higgy Go to last post
13 359
macro looping error by pm
I have a spreadsheet that has 6 tabs and need to read the data in a specific column (D) in each sheet...if the cell is not blank then store the data in a new...
May 19th, 2009 11:24 PM
by pm Go to last post
7 172
File size in Excel 07 by Pip Langford
I have a report that I export from an accounting software package. The report is not large. I have just upgraded to Office 07 and when I export the report...
May 19th, 2009 11:18 PM
by Pip Langford Go to last post
0 138
making a pricing matrix by Aaron
To all, I'm trying to make a formula that will compute a selling price based on my matrix to work on a whole list of costs. THe problem is that the...
May 19th, 2009 10:27 PM
by Aaron Go to last post
3 125
How do I format the date so that I have the name of the day abrevi by Elbridge Gerry Puckett
I know how to obtain Tuesday, May 19, 2009 for today's date. But how can I change the Tuesday to Tues? Or Friday to Fri, etc. Thanks! - EGP
May 19th, 2009 10:03 PM
by FSt1 Go to last post
2 205
GRAB VALUES FROM COLUMN A WHERE COLUMN C = 302 by Gluefoot
I need to lookup the values in sheet 1 column A where the corresponding value in column c = "302" I don't want it to grab any values that are blank or not...
May 19th, 2009 09:41 PM
by T. Valko Go to last post
1 159
SUMPRODUCT by ColleenK
Hi, I am new to using the sumproduct formula, would someone be able to tell why the following is not working: =SUMPRODUCT('Detail...
May 19th, 2009 09:22 PM
by ColleenK Go to last post
0 175
Post New Thread


Display Options
Showing threads 19861 to 19880 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:15 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.