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
convert hours and minutes into days by Joshua
I have a formula in a cell that adds up a bunch of hours and minutes and is in the :mm format, it gives me a total of 48:00 How do I get display that...
June 14th, 2009 11:22 PM
by David Biddulph Go to last post
4 130
SumProduct Query by hardeep.kanwar[_9_]
Hi! Experts What is the Difference Between these Sumproduct Function It show the Same Results What is the Difference Between "--" in First Function and "*"...
June 14th, 2009 09:57 PM
by JoeU2004 Go to last post
6 115
Divide by the minimum non-zero number in a range of cells by Opus
I need to find the minimum non-zero number in a range of cells that contains some zeroes. So that I can divide by the minimum number. Any ideas? If I just...
(Multi-page thread 1 2 3)
June 14th, 2009 08:27 PM
by JoeU2004 Go to last post
22 220
Conditional Currency by Loadmaster
Cell A1 has the number of hrs I have flew in the past two months. In order to maintain my currency I must fly at least 30 hrs in any 3 months period. Should...
June 14th, 2009 07:17 PM
by Allllen[_2_] Go to last post
5 87
max value from multiple rows of similar information by Karesel
- A B C D 1 BROOK PINE 5/25 47 2 BROOK PINE 5/26 21 3 BROOK PINE 5/27 33 4 BROOK PINE 5/28 49 5 BROOK PINE 5/29 19 6 WHITE SNOW 5/25 23 7 WHITE SNOW 5/2...
June 14th, 2009 06:12 PM
by T. Valko Go to last post
5 103
runtime error 2147221005(800401f3) by deen
Hi I'm facing problem in ecexl once i open the work book , this below error runtime error 2147221005(800401f3) Invalid class string
June 14th, 2009 04:43 PM
by JLatham Go to last post
1 136
repeated values by sood
I have 16 coulmns and 239 rows containing telephone numbers. I want to know whether there are repeated telephone numbers in a column or row.
June 14th, 2009 04:24 PM
by Allllen[_2_] Go to last post
1 75
YEAR MONTH DAYS COUNTER by ad2ad79
Hi, I have a sheet in which I want to count the year then month and then days for employee. i.e Name Date of joining Date of leaving Absent Total JOHN ...
June 14th, 2009 02:42 PM
by Don Guillett Go to last post
8 113
Formula Help by Diana
Is there a way to hide a formula within a cell and have the cell show the final answer?
June 14th, 2009 03:12 AM
by T. Valko Go to last post
1 64
Max Min Differnce in a Range by Albert H. Bell[_2_]
I have two formulas that I want to create. I have data from an assembly equipment tester that has the following columns A B C ...
June 14th, 2009 02:43 AM
by Albert H. Bell[_2_] Go to last post
6 96
Adding to numbers by Lori
Hi All, I know this is probably a very simple function, but I can't for the life of me make this work!!! I have a column with all different numbers. I need...
June 14th, 2009 02:08 AM
by T. Valko Go to last post
2 88
2003 Excel by CC Bulinski
This is my data: CB 101 CC 201 CA 105 CC 123 CB 122 CA 109 Question: How do I sort the information given to tell me how many CA's I have and so on??
June 14th, 2009 12:13 AM
by Bernard Liengme Go to last post
3 121
If part of a cell = "NVA" then insert "Norfolk" in return cell by RNCKWMN
Column C has various 8 character codes (city & state abbreviations). One # and 7 alpha. If the 2nd, 3rd & 4th characters = "NVA" then I want it to return...
June 13th, 2009 08:53 PM
by Francis Go to last post
4 92
Number of total calculation functions by appsinoffice2003
Dear Experts of Microsoft Office... What is the total number of calculation functions in Excel 2010? Any new ones compared to 2007? If possible, I'd...
June 13th, 2009 08:42 PM
by Shane Devenshire[_3_] Go to last post
3 110
Excell rank= I need to reverse the order by Dennis Noble
Formula Rank=(A1:A9,A$1:A$9,1) this is working well but! I need to reverse the order to high # equal 1st not last
June 13th, 2009 08:36 PM
by Shane Devenshire[_3_] Go to last post
3 79
Dependent List "Index" Problem by Benjamin
I'm using the template from: http://www.contextures.com/xlDataVal15.html I'm having a problem getting the pulldown menus to move to say start at Cell G8 and...
June 13th, 2009 05:36 PM
by Benjamin Go to last post
2 119
YEAR MONTH DAYS COUNTER by ad2ad79
Hi, I have a sheet in which I want to count the year then month and then days for employee. i.e Name Date of joining Date of leaving Absent Total JOHN ...
June 13th, 2009 04:28 PM
by Shane Devenshire[_3_] Go to last post
2 86
cell formulas by Lynn
I have an Excel spreadsheet of a price list with various columns of currency that I need to increase +3% and a separate sheet increased +6%. It's originally...
June 13th, 2009 03:31 PM
by Gord Dibben Go to last post
3 92
Excel cannot complete this task with available resources by PSM
I have a presentation spreadsheet (SS) that until recently worked fine. It requests the user enter a recipe by listing codes and quantities. By VLookup it then...
June 12th, 2009 11:26 PM
by Bob Bridges[_3_] Go to last post
1 97
Sumif or Sumproduct? by alarson01
I simply can't figure this out... I have multiple locations that I need to find specific criteria and sum: A B C ...
June 12th, 2009 11:07 PM
by Bassman62 Go to last post
3 108
Post New Thread


Display Options
Showing threads 10141 to 10160 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 12:55 PM.


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