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
Calculating the number of entries between 2 times by Bonzai
I am working on a Dispatch records workbook. I am trying to get counts of entries between 2 time frames. Example, How many entries between 8:00AM and 9:00AM,...
January 11th, 2010 07:23 AM
by T. Valko Go to last post
2 98
If date in range is before today by mjones
Hi All, I'm getting #VALUE! with this formula. =IF('AP-AR'!B43:'AP-AR'!B297TODAY(),"AP-AR needs updated","") I've probably made a right mess of it, but...
January 11th, 2010 06:28 AM
by T. Valko Go to last post
3 90
VLookup with multi-condition by anthony alvarez
I am doing a vlookup with regard to time keeping A B C D ID Date Time Status 0001 01/01/2010 7:25AM IN
January 11th, 2010 03:00 AM
by T. Valko Go to last post
2 140
Count if equal to first non error cell by John
Hi I tried to post this once so apologies if this is second post... I want to count the number of times 3 or -3 occurs in range A8:A15 depending on whether 3...
January 11th, 2010 02:56 AM
by John Go to last post
0 123
Same cell but different worksheet by mjones
Hi All, Can I make a cell the same as the cell, but in a different worksheet. It's a text field. For example A1 in worksheet Marketing Report should be the...
January 11th, 2010 01:47 AM
by Dave Peterson Go to last post
3 92
FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS by PAR80
DOES ANY ONY HAVE THE FORMULA FOR CALCULATING MIN MAX LEVELS FOR INVENTORY CONTROL
January 11th, 2010 12:52 AM
by Herbert Seidenberg Go to last post
3 171
count text occurance in range by Stehy
I am working in Excel 2003 and would like to enter a formula counting the number of times a specific word (sometimes in a sentence) appears in a range of...
January 10th, 2010 10:55 PM
by Garyj Go to last post
3 83
array frequency data search by bishee
Hi. I need to list, in order of frequency, the five most frequently occurring numbers from a cell series (say A1:J10). I have been stumped for weeks on...
January 10th, 2010 10:54 PM
by Lars-Åke Aspelin[_2_] Go to last post
1 88
freeze pane option not available by dave f
The freeze pane option is not highlighted on my toolbar. Consequently, I cannot select it for use. As best as I can determine the worksheet is not procted.
January 10th, 2010 09:45 PM
by Gord Dibben Go to last post
1 114
count the presence of a date as 1 by WLWTNG
I am building a sales tracking chart which includes a date when an item is sold. I need to count the number of sales based on whether or not a date has been...
January 10th, 2010 09:29 PM
by Dave Peterson Go to last post
2 111
get an average of 3 cells, if they all have numbers, in excel. by rudyjudy
In excel I need to average 3 cells, only if they all contain a number. and if they don't contain a number, don't display an error.
January 10th, 2010 06:43 PM
by CellShocked Go to last post
2 100
Trying To Put IFs into a Function by SkippyPB
Ihave one thing I do in a formula that I don't know or haven't figured out how to make it work in a function. The formula looks like...
January 10th, 2010 06:30 PM
by Per Jessen Go to last post
2 127
Automatic Sorting? by Ted[_15_]
I have a worksheet. Row 1 contains column headers Row 2 is blank Rows 3 through row 548 contain data in columns A through W First sort condition: Column F,...
January 10th, 2010 06:01 PM
by Otto Moehrbach[_2_] Go to last post
6 100
How can I add the new record from another list to current one? by PattyS
I receive updated lists from others and have used VLOOKUP to add a "closed date" to an existing record, but I need to know if I can recognize if a completely...
January 10th, 2010 03:56 PM
by Otto Moehrbach[_2_] Go to last post
1 105
SumProduct not right by Steve
This formula is summing ALL the incidences in the N column of what's in E2. I want it to sum ONLY those that are in E2 but also also matching what's in...
January 10th, 2010 03:41 PM
by Steve Go to last post
7 187
how do I copy only visble cells in office10 by Tantalus24
i can't remember how this is done in this version
January 10th, 2010 08:09 AM
by Ashish Mathur[_2_] Go to last post
3 94
How do I keep the "today()" function from updating by Len Chaston
I have a macro that adds a new line to our construction budgets. It puts the date of the change by using the today function to put that day's date in the...
January 10th, 2010 04:23 AM
by Rick Rothstein[_2_] Go to last post
2 113
Editing time that has its colon removed by rhhince[_2_]
I have a large CSV file that has the time column stripped of its colon meant to distinguish hours and minutes. ie. 9:20 is displayed 9200. 23:55 is...
January 10th, 2010 03:22 AM
by Rick Rothstein[_2_] Go to last post
1 111
Matching and combining information on two separate worksheets by moparfamily
Is there a way to do the following? One worksheet has the following information 02 - Sandee 03 - Scott 156 - Kali 300 - Tom The other worksheet has
January 10th, 2010 02:14 AM
by Ashish Mathur[_2_] Go to last post
2 107
subtotal function using criteria by dbroc
I'm trying to use the subtotal function to total figures in a list based on a technician's name. For example, use the subtotal function instead of the...
January 10th, 2010 01:46 AM
by Ashish Mathur[_2_] Go to last post
5 93
Post New Thread


Display Options
Showing threads 4001 to 4020 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 05:55 PM.


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