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
What is the most straightforward (elegant) way to write this formu by ewillig
Rows = projects and Columns = components needed for this project. I am looking to make 2 calculations on each project. The first is the overall time...
April 8th, 2010 05:15 PM
by ewillig Go to last post
5 78
Multiple IF statement by J.Scargill[_2_]
Hi guys, A little help required please. I have a worksheet that looks like this; J L 10 Y 1 11 Y 2 12 N ...
April 8th, 2010 04:28 PM
by Paul C Go to last post
1 98
Pivot Table Totals by Mick Henn[_2_]
Is there any way that i can add an extra column to a pivot table that I can add a function into? We have 2 internal quality checks for our product. I have...
April 8th, 2010 04:23 PM
by Mick Henn[_2_] Go to last post
6 135
Return of value when copying a formula by Stinky
I've created a v simple in order to get data from one spreadsheet to another. However, when I copy the function across the spreadsheet, it is returning the...
April 8th, 2010 04:01 PM
by Dave Peterson Go to last post
4 80
Printing problems with hidden rows by Banker
I have a sheet with 5 templates divided by page breaks. When only 2 templates are needed, I hide the rows that I do not wish to be printed so it will only...
April 8th, 2010 03:52 PM
by Banker Go to last post
1 142
Hiding rows and printing by Banker
I have the print area set to A1..H340 with 4 manual page breaks inserted. I have hidden rows 200 thru 340 and when I print, I still get 5 pages - two pages...
April 8th, 2010 03:51 PM
by Banker Go to last post
1 119
trouble with closed workbook by Bob L[_2_]
I have a few spreadsheets that are linked to other workbooks. Everyone says that you cannot get data from a closed workbook. Here is what I have. I have...
April 8th, 2010 03:29 PM
by Bob L[_4_] Go to last post
2 104
Function Lookup by Heather
=IF(Routing_Count_04072010!A:A = "COB",Routing_Count_04072010!B:B,0) I can use the above as long as the fields do not change and it works perfectly. When...
April 8th, 2010 02:54 PM
by Bob Phillips[_3_] Go to last post
3 131
speeding up calculation: replacing array formula with databasefunction? by Amedee Van Gasse
Hi, I could use some advice on optimizing a formula. I currently have the following array formula in the cells of column...
April 8th, 2010 02:53 PM
by Bob Phillips[_3_] Go to last post
9 132
Better Workday function. by XKruodo
Hi, Few days back i posted...
April 8th, 2010 02:38 PM
by Chip Pearson Go to last post
2 191
Repeating rows not wanted by Opal[_3_]
I am running Excel 2003 and not sure why this is happening. I have a 2 page report and there is a header plus I have flagged two rows to repeat at top (12 &...
(Multi-page thread 1 2)
April 8th, 2010 02:08 PM
by Opal[_3_] Go to last post
11 351
Working Days of Week and DUE DATE for PAYMENT by XKruodo
Hi, A class has 2 batches for students. Monday, Wednesday, Friday and Tuesday, Thursday, Saturday. Sunday a holiday. Students can join in between months....
April 8th, 2010 01:10 PM
by Ron Rosenfeld Go to last post
2 175
to Sohail by Stefi
If you don't write anything in the message body, your post can't be replied to! http://tinyurl.com/8n4fz by Bob Phillips You could download Laurent...
April 8th, 2010 12:33 PM
by Stefi Go to last post
0 158
How do I count # of cells with same value other column? by aganoe
In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I want to count the # of cells in...
April 8th, 2010 11:30 AM
by aganoe Go to last post
4 152
How do i compare and remove common names from 2 excel work sheets by Andrew
Task is to compare 2 excel worksheets containing humngus list of companies names' (approx word match only in each sheets); sort out and remove the common...
April 8th, 2010 09:02 AM
by Andrew Go to last post
0 125
Depreciation Spreadsheet by Michele
Hi I'm having a little trouble calculating some formulas in my depreciation budget worksheet. What I need to be able to calculate is when an asset is only...
April 8th, 2010 08:53 AM
by Roger Govier[_8_] Go to last post
3 137
Data moving 3 by climate
Hi I need to a code, when run it on any sheet, copy of column X paste to a file (R.xls) in sheet1 and locate on column H respectively. in otherwords, first...
April 8th, 2010 07:28 AM
by climate Go to last post
1 151
April 8th, 2010 04:58 AM
by Gord Dibben Go to last post
1 107
excel crashes when changing web query by Graeme
Hi, In excel 2003, i have a file that pulls in data via Data / Import External Data / New Web Query. I've been using the file for about 3 years, and now...
April 8th, 2010 04:52 AM
by Graeme Go to last post
0 116
Formula to Return age by JLatham
see http://www.cpearson.com/excel/datetimews.htm scroll down just a few lines and he has a formula for determining age in years, months and days. "Mark"...
April 8th, 2010 02:04 AM
by Gord Dibben Go to last post
1 149
Post New Thread


Display Options
Showing threads 1461 to 1480 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 10:06 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.