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
Help Calculating Partial Months between 2 dates. by sirscottyog
Hi there. I am trying to obtain the number of months (to 2 decimal places) between two dates: w4 is 4/4/09 x4 is 6/30/09 Any ideas? Searched extensively but...
April 16th, 2009 03:29 AM
by Ashish Mathur[_2_] Go to last post
2 84
SUMIF formula with non contiguous cells by Billy B
I have been trying, without any success, to write a SUMIF function using non contiguous cells and need some help. Here is the formula I am working...
April 16th, 2009 03:14 AM
by Ashish Mathur[_2_] Go to last post
2 106
Importing Data Wizard by John L[_2_]
Gday All,I have searched your great disscusion group but cannot find a answer to this question .When I use the Import data wizard some data does not come ,it...
April 16th, 2009 03:08 AM
by John L[_2_] Go to last post
6 142
Multiple results of Unique Values by VickiMc
Hi Guys! My Formula looks like this for identifying unique records =IF(K20,0,IF(COUNTIF(L$1:L2,L2)=1,MAX(J$1:J1)+1,"")). What I wanted to know is if there...
April 16th, 2009 02:34 AM
by Ashish Mathur[_2_] Go to last post
3 110
Deleting rows or columns by Darrell
When deleting rows or columns on a work sheet, the information is lost (ie: #REF) on the connecting worksheet
April 16th, 2009 01:56 AM
by Alan Go to last post
1 75
How does one use a formula to bring over the formatting as well by Bud
Hello I am using the following formula in hopes of copying the data over including the format into another worksheet called Early. In the worksheet called...
April 16th, 2009 01:50 AM
by Alan Go to last post
1 78
Calculate Interest Rate by Mark Parent
If I have opening and closing balances, and the number of equal monthly payments made, can I calculate the 'effective' interest rate?
April 16th, 2009 01:34 AM
by JoeU2004 Go to last post
2 85
how do I look for cells showing dates less than a certain date? by Annie and Naseem @ Ecojustice
I've constructed a table with dates of employee departures and need to "sort?" all of those who left over 7 years from the current date. This has to be done...
April 16th, 2009 01:15 AM
by Bernie Deitrick Go to last post
1 84
Display a number in feet inches and fractions of and inch by Michael Peace[_2_]
I have a list of measurements in decimal inches and I want to display them in feet, inches, and fractions of an inch. I.E. 75.522" would be displayed as 6'-3...
April 15th, 2009 11:34 PM
by Glenn[_6_] Go to last post
1 99
Adding a pre-fix to each item in a cell by nasadell
I have a column that contains cells that either have: nothing (blank), one word, or multiple words separated by commas. I need to add a pre-fix to each word...
April 15th, 2009 10:51 PM
by Glenn[_6_] Go to last post
1 85
Help Calculating Time by tech1NJ
I have a problem displaying the time (minutes) correctly beyond 60 minutes. Fox example: B29 = 3/17/09 4:10 PM - cell formated as DATE and TYPE 3/17/09 4:10...
April 15th, 2009 10:04 PM
by tech1NJ Go to last post
5 83
Calculate Date by brownmre
Can an add function be tweaked to compute a date value that does not equal a Saturday or Sunday. Example: Start date = 4/17, days added = 2, answer = 4/19...
April 15th, 2009 09:05 PM
by T. Valko Go to last post
6 72
Return column header as solution to lookup by Tessa
I want to search for the minimum value in each row and then return the column header for the answer. For...
April 15th, 2009 08:59 PM
by Tessa Go to last post
3 65
Cell format for an array formula containing text by Pete
I have the following array formula: {=IF(G16=0,0&" days",AVERAGE(IF((DrugList!F3:F72=FY!G3)*(DrugList!F3:F72=FY!G4),DrugList!W3:W72))&" days")} it returns...
April 15th, 2009 08:56 PM
by Pete Go to last post
2 75
Vlookup with multiple workbooks by Sally
Is there a way to do a VLOOKUP when there are more than 2 workbooks in Excel ? and how? When I try using this formula I get an error that says "#VALUE!". ...
April 15th, 2009 08:44 PM
by Luke M Go to last post
1 91
Copy worksheet from one workbook to a master workbook by mvannatta
I have a master workbook that has multiple worksheets. each worksheet has a companion workbook. Currently, I open the companion workbook and manually copy...
April 15th, 2009 08:32 PM
by mvannatta Go to last post
3 59
Pearsons by skimball
I always get an error message when attempting to do an array for pearsons.
April 15th, 2009 07:51 PM
by skimball Go to last post
4 77
External reference to a Column by AshMorK
Hi, I have the following formula in wb1 that only works when referenced wb is opened: SUMPRODUCT(--(MONTH('Histórico...
April 15th, 2009 06:51 PM
by AshMorK Go to last post
0 55
Confirmation Security by Babs in Ohio
I would like to send a spreadsheet with one worksheet displayed and a sign-off on that page. Once the person has signed-off other worksheets with then be...
April 15th, 2009 06:20 PM
by Babs in Ohio Go to last post
0 66
IF Statements by Ben Joseph[_2_]
I have in my spreadsheet a number for Budget and a space for putting in amounts spent. I have an IF statement which displays the words "YOU HAVE EXCEEDED THE...
April 15th, 2009 06:14 PM
by Ben Joseph[_2_] Go to last post
2 50
Post New Thread


Display Options
Showing threads 12101 to 12120 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:17 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.