MIN formula help
I want to know what the Max and Min numbers are using the following
formulas. The Max formula seems to work without any problem, however
it's the Min that I have a problem with.
If I only have numbers in cells A2:A8 and the lowest number is 150,
then in that cell that I have the following MIN formula in should show
me 150. Instead it's blank because I still have two remaining cells
in my range (A9 and A10).
How can I fix this. Any and all help is greatly appreciated..
MIN/MAX ignore empty cells.
>Instead it's blank because I ...Min bal requirement
My checking account has a minimum balance requirement of $250 to waive the
service charge fees, so I want to keep the minimum in the account. Any
recommendations on how to balance to the statement? Should I deduct the $250
from the check register & try to remember this every month when I balance to
subtract the $250 from the bank's balance? Is there an easier way?
=?Utf-8?B?S2VsaUI=?= <KeliB@discussions.microsoft.com> wrote on 08 Sep
2007 in group microsoft.public.money:
> My checking account has a minimum balance requirement of $250 to
> waive the servic...how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43
how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68 minutes
and 43 seconds)
In article <5F13B001-9B6B-4D5D-BD81-ACAAF5799CF6@microsoft.com>, "=?
Utf-8?B?dmVsZSBQaGFudA==?=" <vele Phant@discussions.microsoft.com>
> how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68 minutes
> and 43 seconds)
=MINUTE(C31)+SECOND(C31)/100 where C31 contains the time in hh:mm:ss.
Note that XL may format the cell containing the formula with a time
format. If so, change it to 'General'.
www.tushar-m...Rounded Rectangle Required
Using Publisher 2003, how do I create a border with radius corners, a
rounded rectangle, around a text box?
I say text box, but I plan to boarder the entire page. I'm making the
text box as big as the page.
(||) Nehmo (||)
Run Publisher and on the left select "Autoshapes//Basic Shapes". There you
will fiind a rectangle with rounded corners. Using this Autoshape, draw you
border. You can then adjust the radius of the corners using the little
Hope this helps,
"Nehmo" <email@example.com> wrote in message
I have a few fields at the Account level that have a constraint (Requirement
Level) of Business Required. I no longer want these fields to be required.
When I open the Attributes and try to change the Requiremet Level to No
Constraint and then try to save the changes to the attribute, I get an error
that says to contact my sys admin.
Has anyone a solution to this?
I am presuming you are using an account that has permission to make the
MCDBA 2000 | MCITP DBA 2005
> I have a few fields at the Account level that ...Require selection from combo on checkbox?
Hi - is it possible to set a form to require a selection from a combo if a
check box is set to true?
I've tried using the validation rule set to the check box name, but it
Since we're not there, we don't have any way to know HOW you "tried using
the validation rule ..."
If this were mine, I'd add a validation check in the form's BeforeUpdate
event that ensured that there was a selection made in the combobox if the
checkbox were true (and "Cancel"ed the update if there wasn't).
By the way, you can make it easier f...Version 8 functions that no longer require 'sa'
Can you please provide a list of functions/tasks that previously could only
be performed by 'sa' but now can be performed by DYNSA or other users.
The GP v80 What's New pdf contains this information: (Not much of list but
the only thing I've found specifically addressing your question)
-- Reduce dependence on “sa” user
Dependence on the "sa" user has been reduced. (The "sa" user is the system
administrator account for SQL Server.) Most tasks that could be completed
only by the "sa" user in previous versions now can be completed by ...SDI MAX/MIN childframe?
In an SDI application (NOT MDI), is it possible to HIDE/SHOW the child
frame, or max/min the child frame?
Thanks in advance
On Mon, 18 Jan 2010 18:24:46 -0800 (PST), rockdale <firstname.lastname@example.org> wrote:
>In an SDI application (NOT MDI), is it possible to HIDE/SHOW the child
>frame, or max/min the child frame?
>Thanks in advance
No. It doesn't even make sense to consider this. It *is* possible to change the view
(there's even an MSDN article on how to have multiple mutually-exclusive views in SDI) but
simply hiding the frame makes no sense. What do ...IE8: Additonal Favorites toolbar required. How?
Is it possible in IE8 to make the Favorites toolbar line to go to two or more
lines? I have a number of favourites added to the tool bar and now they go
over to the ">>" extension on the RHS, so it is another click to access them.
I was wondering if this toolbar could be made to go onto two lines. So far I
have been unable to find a way to do it.
See if my video gives you some tips in managing your Favorites Bar.
I use the Add to Favorites bar button to add new links at the top of the
F...Email a Merged Worksheet or just required cells
XP Prof. Office 2003 Please help; I have created a Purchase Order Workbook.
Two worksheets; ws1 holds the spreadsheet information (which is entered via a
Userform). ws2 Is a friendly, easy layout form which shows one selected order
looks like a paper order & simply calls the cell information from ws1 by row
(unique No.). I can print this information (B8:L34) and everything works
well. I would like to be able to email an order and as you can simply do
this by viewing the desired order, selecting "file/send to/mail
recipient/this sheet only" I would think that creat...Question about If using Min
My question is regarding using IF statements with MIN or MAX I am takin
a class and our spreadsheet deals with a car dealership and sales. I a
having problems with creating an IF statement, using MIN, to displa
who sold the least cars. I was able to create one for the MAX number o
Here is the MAX statement which works displaying �Hill�
What I need to know is; How to find the address of the value returned by the
Assuming that the data is in column c check column is B.
=Address(min(if(b1=B6:b29,row(B6:b29),3))) entered as an array
> What I need to know is; How to find the address of the value returned by the
> MIN function?
it is not volatile and can be entered normally
"PeterAtherton" <PeterAtherton@discussions.micros...RMS Database requirements
We're thinking of installing RMS in our shops.
Am I right in thinking its needs SQL server or can it run with MSDE
2000 or even better the new SQL Server Express?
You can run RMS on MSDE which is what RMS comes with. But it really all
depends on how many lanes you are going to be running as there is a 2GB
limit to the MSDE, how many transactions you will do in a day and how many
people will need to be accessing the database on a regular basis. Now for
most retailers that have 1 - 4 lanes (this is just an approx), MSDE will be
more than enough, but for some they may...CRM 3
I have a client who wants to upgrade Outlook 2000 to 2003 but not the
rest of the office suite, will this have any limitations or challenges
in regards to the CRM 3 Outlook Desktop client?
You should be fine to go ahead and do that. You may want to remove
Outlook 2000 from the Office 2000 suite first and then do a fresh
install of Outlook 2003, it might just minimise on possible
Brad I would check with the Outlook MVPs too - there are many merging
issues between Word and Outlook when you run disparate versions.
Judy Gleeson [MVP ...Run-time error 424 Object required
Anyone know what causes this error and how to fix it. Whenever the login
screen is required to come up either after a transaction or when hitting rf9
to secure the error pops up and RMS crashes. I am running RMS 2.0 w/ SP2.
Oddly enough I had the issue on a few of the machines and reindexed the
database as I recently upgraded from 1.3 and some of the terminals were fixed
while some new ones started having the issue.
...blue screen every 10 min please help
I keep getting this
Problem Event Name: BlueScreen
OS Version: 6.1.7600.2.0.0.256.48
Locale ID: 1033
Additional information about the problem:
OS Version: 6_1_7600
Service Pack: 0_0
Files that help describe the problem:
Read our privacy statement online:
If the online privacy statement is not available, please read o...Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins?
I've been fiddling and fiddling for some time now this evening but I
seem to be missing something completely today. In the past I've dealt
with adding/subtracting times formatted the same way as the end
results, so they've worked from the get-go.
In today's case, I have a spreadsheet that I'm using to calculate best
fits for movies transferred from VHS to DVD via a DVD Recorder. My
DVD Recorder deals with hours and minutes but my internet source gives
total running time in minutes only.
How do I get Excel 2000 to add up a column of minutes and then give
the results in a...Does the 'Expires After' message option require Microsoft Exchange on sender side, reciever or both?
This is a multi-part message in MIME format.
I have asked this question in two Outlook newsgroups and nobody has been =
able to give me a definite answer.=20
Does the 'Expires After' message option require Microsoft Exchange on =
sender side, receiver side, or both? Thanks.
<!DOCTYPE HT...Requir excel
On Sun, 6 Sep 2009 11:11:01 -0700, Brijesh
To the original poster:
Please enter a quesion in the body of your emai; if you don't the web won't
let us reply, instead it displays the following error message.
"An error occurred while sending your post
We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later."
This means, that to respond we need to start a separat...Problem with a MIN function
Please can someone explain to me why this doesn't work:
I've got dates in both ranges - and both ranges also contain blanks. I don't
understand why this formula does not return what I want!! I'm trying to get
the earliest date in A46:A52 where there is a blank in the corresponding
cell in B46:B52.
I've checked the formula (including the F9 option in the formula bar to view
each part) and it's got me beat!
try the arraz formula
>---...rights/privileges required for Backup/Restore
We are getting ready to disable the builtin\administrators group per a
SOX requirement. We use a 3rd party tool to backup our SQL databases
(TDP for SQL), that currently uses "local service". Is this
sufficient to back up our databases after we disable the builtin
accounts, or will my backups break? If not, what are my options?
Here are the ones I see:
1: Set up windows account, and add it to the sysadmin role at the
2: Set up windows account, and add it to the backup operator role in
each database on the machine.
Does the backup operator also ...Outlook requires user, domain and password on openning.
When I open Outlook 2000 under Windows 2k/XP, the system requires me
to input user, domain and password to access my mailbox.
How can I do to make the system getting this information authomatically
from my login?.
�Problemas con las news?
Webnews, el acceso m�s r�pido y fiable
User IP: 188.8.131.52
...Min in a week/min between dates
I have a sorted list (descending) of business days in column A, Monday
to Friday excluding holidays, and in column B, the related data I
need to work with.
I need a formula to find the min value of every week (mon to friday).
Due to holidays, the range of the week is not always 5 cells, and I
can not "hard coded" like =min(B2:B7)
The min value should be in column C in the same row of the last
business day of that week.
Any help is appreciated..
Thanks for your time
=IF(WEEKDAY(A6)=6,SUMPRODUCT(($A$1:$A$21<=A6)*($A$1:$A$21>=A6-4)*($B$1...template required for book
I've just done a book which runs to about 110 pages and suddenly I've
realised it's not in proper A5 format but A4. I've done it in 12 point
Does anyone have a template I can use to convert it to A5? Thanks
Why not just change the page size? Assuming Word 2007, check the "Page
Layout" tab and then the "Size" button in the "Page Setup" group.
I'm not sure why you are mentioning templates in this context. Although
templates can specify the paper size, they cover a much broader aspect of
formatting. I doubt you want to change...Look for Min and second Min
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 enough.
I'm looking for the min and the second lowest (after the first min is found).
In thie case, I hope I can use function to sort out 24.59 after the lowest
18.25 is formed.
18.25 is easy ... just the problem of 24.59 ....
Try the SMALL & LARGE functions.