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
row height issue by Mike SoCal
I insert a row height of 15.75 and excel changes it to 15.60 automatically on my new machine. I need to be able to create the 15.75 row height but cannot. ...
April 13th, 2010 06:48 PM
by Gord Dibben Go to last post
1 169
Average using Sumproduct by Basenji
Using Excel 2003, I need to find the average age of males who have had a specified procedure before March 31, 2010. D3:D11 are ages. E3:E11 are gender....
April 13th, 2010 06:33 PM
by Joe User[_2_] Go to last post
4 166
Rounding by Cynthia
How can a get a number to round in the formula bar when it is already rounded on the worksheet. Ex: Formula Bar says 16651107.5346 and the worksheet has...
April 13th, 2010 06:12 PM
by Cynthia Go to last post
4 173
Change the weekends by Sadad
Dears, I want to calculate the working-days of my subordinates and I usually I use the function NETWORKDAYS but in this country the weekends are Saturday and...
April 13th, 2010 05:37 PM
by Mike H Go to last post
1 167
Conditional IF formula using multi-dimensional arrays by iperlovsky
I am attempting to find a value in a 30 column (1000+ row) array that is conditioned on finding an exact value match in adjacent column and a not-to-exceed...
April 13th, 2010 05:15 PM
by iperlovsky Go to last post
2 146
How do I set NETWORKDAYS to regard friday and saturday as weekend by Shay.C.
The NETWORKDAYS function regards Saturday and Sunday as weekends. I need to set Excel to regard Friday and Saturday as the weekend.
April 13th, 2010 05:13 PM
by Sadad Go to last post
2 164
Date Diff - excluding working days by Scott_goddard
Hi all, Does anyone know how i can return the difference between two dates that across weeks, months and years and only count working days?
April 13th, 2010 04:53 PM
by Rick Rothstein[_2_] Go to last post
2 153
Median with Criteria by Demosthenes
Hello, I want to write a formula that calculates the median of a set of values specified by some criteria. For example, if you have the following in A and...
April 13th, 2010 04:26 PM
by Demosthenes Go to last post
2 199
Vendor List by Andri
Dear Expert, Please help to create the list automatically. Here is the situation, for simflify, i just take the Vendors Columns Only. Supplier (we assume G1...
April 13th, 2010 03:53 PM
by Andri Go to last post
7 171
ISNA VLOOKUP does not recognize 63023 by Nain
Hello I need help. The formula listed below works for all the employee numbers on my spreadsheet which are in column B except for the employee number 63023....
April 13th, 2010 03:30 PM
by Dave Peterson Go to last post
4 156
Adding totals from different columns by Eskercat
Hi I have a column called year group, one called total attendance and one called possible total. I would like to create the total % attendance for the group...
April 13th, 2010 03:06 PM
by Ashish Mathur[_2_] Go to last post
1 219
stock control template by Gary L[_2_]
does anyone have a stock control template i can download
April 13th, 2010 03:04 PM
by Eduardo Go to last post
1 165
Auto-insert same value each Monday in cashflow worksheet? by Scribble
This will seem like kindergarten to some of you... While constructing an Excel worksheet as a simple cashflow aid, I would like to tell the sheet that on each...
April 13th, 2010 02:41 PM
by Scribble Go to last post
0 164
Hyperlink won't open in excel by JBrits
I get a message in excel when I try to open hyperlink in excel that says "This operation has been cancelled due to restrictions in affect on this computer....
April 13th, 2010 02:33 PM
by JBrits Go to last post
0 138
Combining text from multiple cells by mgerken79
Help please. I'm trying to combine text from multiple cells using the following formula. =B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3 Column I is where...
April 13th, 2010 02:12 PM
by Don Guillett[_2_] Go to last post
6 124
Sum amount of days in another coloumn by Scott_goddard
Hi all, I am using the below spread sheet Task Working days Start date End date 1 7 days 28/05/2010 07/06/2010 Analysis 1 2...
April 13th, 2010 12:51 PM
by Jacob Skaria Go to last post
8 131
Array Formula Help Needed by nelly
Hi Guys I need an array formula which counts the number of instances range Comp1 has a value greater then zero AND Range Comp2 has a blank value. Sounds...
April 13th, 2010 12:43 PM
by nelly Go to last post
5 195
Look for Min and second Min by Elton Law[_2_]
Dear expert, Have posted a similar message before, but look like no one replied. Lat me try the last time as I found the previous post was not clear...
(Multi-page thread 1 2)
April 13th, 2010 12:28 PM
by Steve Dunn Go to last post
13 576
Removing multiple duplicate events by Father John
Hi I have a spreadsheet that has a complete address in one column (a) In column (b) (B1:B165) I have the name of the suburbs I wish to remove from col...
(Multi-page thread 1 2)
April 13th, 2010 11:24 AM
by Ron Rosenfeld Go to last post
10 257
Help with formula by Brandon
I want to return the first date in which the sum of the previous columns first exceeds inventory on hand (total). Should return 4/5 on this...
April 13th, 2010 10:48 AM
by Stefi Go to last post
1 135
Post New Thread


Display Options
Showing threads 1321 to 1340 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 01:04 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.