get lowest positive number
I have a cell that has number ranges from -37 to 88, what is the formula to
show the lowest positive number.
try this. It is an array formula so must be entered/edited with
ctrl+shift+enter and will not work on full columns.
"Tommy" <Tommy@discussions.microsoft.com> wrote in message
> I have a cell that has number ranges from -37 to 88, what is the formula
> show the lowest positive number.
> Thank You
No...Displaying Text, not numbers, in Pivot Table
Hello all. I posted this in the general section but I think it also could
apply to here since I am new with using Pivot Tables.
Currently I have a database in excel which has been made into a pivot table.
It is just a simple catalog of some books. The row fields are organized as
category, field, sub field and then title. The data items are a brief
summary, catalog number, and where the book is currently located (in the
office or someone else has it).
My problem is all of the items in the data field are currently being
displayed as numbers, which are all 1s since it gets that specific with t...Sales Return with Lot Number
I have spent almost 4 days now tryingt o figure out whats wrong, search
every document realated to Sales Return , SOP Integration...... but of no
I am trying to integrate the Returns in SOP Transaction Entry Screen using
Integration Manager. we are running GP10 with SP1.
Item No: TEST101
UofMSchedule Master Table:
EACH = 1 = EACH
CASE = 10 = EACH
PACK = 20 = EACH
I am able to integrate all the items with lot as return Returned Qty = On
if the item UOM = EACH (which is actullay Base UOM).
But if the same item is returned in C...Receivables Statement Ranges
How can I get the User Defined Field 2 into the drop down box for Ranges on
the Print Receivables Statements page? I see the customize User Defined
Field 1 in there but not the second after I have customized it and added data
into the field. Is there something I am missing? Thanks!
No, the first field is automatically provided in the search but not the
second. This would require a modification by a programmer
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublicat...lable ranges in Excell
I am working with a customer list that I composed in excell
to allow me to set up mailers & keep track of their address,dob etc I need it
in out look so I can sink my new ipack so I dont have to enter all this data
buy hand. In out look it says that you can import the data but it will not as
it comes up with " the microsoft file .......................................
has nonamed ranges of tha data you want to import". I found where to name
the rnages ( next to the address bar in excell but I am not sure of what to
do. The office assent is pointing me to make them a "...Creat a chart to show peak usage times for a resource
I'm no genius at Excel (2002 or 2003)and I could really use some help
on the best way to display some data I have.
What it shows is the usage of a training drop-in room, with details of
the arrival time and period spent / per user / per day. There seems
far too much data to put into a chart in any way that I can think of,
but I really would like to be able to illustrate the spread and volume
of clients throughout each day.
Please can anyone give me simplistic information on how best to creat
this as a visual report so that we can easily summarise usage
Any ideas would be ap...Need to change pic viewer in Excel
When I was running XP Home I could open a link to a picture in Windows FAX
viewer. But in running XP Pro the picture opens in IE which causes multiple
browser windows to close if viewing several linked pictures.
This is an Excel newsgroup. You should post your question to a WindowsXP
Pro newsgroup. HTH Otto
"rgroff" <firstname.lastname@example.org> wrote in message
> When I was running XP Home I could open a link to a picture in Windows FAX
> viewer. But in running XP Pro the picture opens in IE which...numbering macro
In a database of say 10 columns and 100 rows, how do I record a macro
o Insert a new column to the left of column A, then
o in the new column A, number the rows that contain data in
Note: The numbering should start from 1. Since row 1 has the database
heading & row 2 has the column headings, the numbering (no. 1) should
start from row 3 and continue down to the last row that has data in
For i = 1 to 100
If Cells(i,"B").Value <> "" Then
Cells(i,"A&q...counting numbers 04-09-10
I have a Query like This. Pls Give your Suggestions.
Sunil 1 I need to count the numbers against name which number is more
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> Hi All,
> I have a Query like This. Pls Give your Suggestions.
>...Counting characters in a range of cells
Is there a way to count to number of times a given charachter occurs in
a range of cells?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
If it's a worksheet function you want, try
which is an array formula, so enter with Ctrl-Shift-Enter.
If you want to do it in VBA, use
Application.Evaluate("SUM(LEN(A1:A5)-LEN(SUBSTITUTE(A1:A5,""e"",""...IMAP service started but the protocol needs to be started under SysMGR
I have a W2K3 and Exchange 2003 server with no error messages in the event
viewer. Even though IMAP is listed as started under
Services, I had to go to Exchange System Manager to go to the server, select
protocols and then start. There are no error messages in the Event viewer -
can anyone tell me how to start this service automatically? It is currently
set for automatic in Services but that isn't doing it (even though it says
If you stop the service with the virtual server online it should be online
when the service is again started. You might have to refresh but it shoul...I want to format a number cell without the decimal and without ro.
I need to format the number cell so that it will still show the numbers after
the decimal, but not show the decimal point at all. It must also display
leading zeros, which is not a problem. I just need a way to strip the
decimal from the number.
If if needs to stay a number with the same value, I don't think you can do it.
If you can change the value Just multiple the number by ten to the number of
If it can be text set up a new column and use
> I need to format the number cell so that it will sti...Need help with a project sheet, need date to show/not show based o
I have the following formula in cell S2
This takes a date in cell B2 and adds 31 days to it and displays it.
What I need to do is to NOT have cell S2 show any date if anything is in
I'm not very adept at Vis Basic if that what it will take to do it.
No need for code
> I have the following formula in cell ...Need help with SQL
SELECT DISTINCTROW OUTLOOK_APPROVEt1.To, OUTLOOK_APPROVEt1.Subject,
OUTLOOK_APPROVEt1.CountOfImportance INTO OUTLOOK_APPROVEt2
WHERE Received >= date_sub(curdate(), interval 1 month) and Received <=
date_sub(curdate(), interval 1 day)
WITH OWNERACCESS OPTION;
I am having trouble with the Where portion. I would like for this query to
reveal all the emails over the past physical month. Example February 1st I
would like to be able to collect the data for all of January. Any help would
be greatly...add number of duplicate fields in a row or column and have total
I have a log of jobs done on a photocopier, and need to bill people for what
they have used.
the log is very long and have the user name and the number of colour and
number of Black and White copies they have done.
I need to know how much colour and how much black and white jobs have been
done by each user.
hope someone know a way thanks
or am I better to use Access ?
THe assumptions made
People in A1:A20
Type in B1:B20, C for colour, B for B&W
Quantity in...I need to know on the structure of data of Manufacturing Order Processing
...Balance showing as #####
I have a simple set up - date - debit - credit - balance. My total has now
gone to over 10,000 and it is showing up as ######## - how do I correct this
in very simple terms please as someone helped me in setting this up and I am
not too familiar with Excel 2003.
"Terri" <email@example.com> wrote in message
>I have a simple set up - date - debit - credit - balance. My total has now
>gone to over 10,000 and it is showing up as ######## - how do I correct
>this in very simple terms please as someone helped ...If Count is not in a certain range, delete Rows
I have a spreadsheet that is 59752 x 2, with the one column Contact ID A and
the other column Contact Link ID. It is like an instant messaging system. It
looks something like this:
I want to count by different values in column A, and any count that is not
within one of several ranges, those rows get deleted. So if the range is 3-5
contacts, then I want to keep the set of 1s, but delete the set of 2s. My
ranges are 4-5 contacts, 30-41 contacts, and 100+ contacts.
I am also brand new to macros, but I have experience with some other coding ...Display ranges from one worksheet to another
I am running excel 2003. I have been given the task
of creating a workbook where on one main sheet
I want to display named ranges from up to 4 other
worksheets based on the user selection.
The ranges are work weeks and we want to be
able to display 8 weeks at a time for resource
planning. Can someone point me in a
direction where I can find a way to do this?
Check Ron's site under the Copy/Paste section.
"Opal" <firstname.lastname@example.org> wrote in message
IS there anyway you can enter the re-order Number at the Matrix Stage of an
Item, instead on every Item individually?
If you enter it on the Purchase Order side it doesnt update the Individual
...Web Service Reference not showing XSD
I just started playing around with web services. When I reference my Web
Service in my project, the XSD classes don't get referenced (they don't
show). When I switch to class view in my WEb Services rpoject I see them
fine. But not when the web service is referenced. What's missing?
...number setting for workbook e.g. i want , instead of . in number
I want my excel should display number in US format not i German format.
How to change number display setting for whole excel file.
Date, Time, Language, and Regional Options>
Regional and Language Options>click 'Customize' button
If this post helps click Yes
> I want my excel should display number in US format not i German format.
> How to change number display setting for whole excel file.
...Number cells won't reformat / sort
I'm dealing w/ a spreadsheet composed of cut-and-pasted rows from 2
sources (A and B) both originally exported from Filemaker at different
When trying to sort the data by a "Record Number" field, the 2 datasets
remain split and will not integrate.
In other words, instead of the sort result being something like:
They look like this:
The 2 groups remain separate and sort individually.
It gets stranger, though. If I reformat the column to, say, a percent
or a currency r...Can Excel 2007 open a numbers file?
Just wondering if there's an add-in that will let Excel open a numbers file,
What is a numbers file?
Gord Dibben MS Excel MVP
On Wed, 20 Jan 2010 15:17:01 -0800, fnight
>Just wondering if there's an add-in that will let Excel open a numbers file,
If you're referring to Numbers, part of iWork for Mac computers, I am not
aware of such an add-in.
The usual workaround is to use Numbers to save the file in a format that
Excel can open.
The web page http://www.apple.com/iw...Sent Faxes in CRM 3 don't show in History?
I'm using CRM 3 under SBS 2003.
When I send a fax using the "New activity / Fax" option within a contact
record it sends successfully. . However there is no record of it stored in
the contact history?
If I check the fax console on the server the fax has been sent (also
verified by receiving person) however it doesn't get logged in the history. I
can't seem to find any record of it except on the Fax Console on the server??
Anyone else have this problem or no how to solve it?
ps: As a workaround I thought I might be able to automatically route faxes
sent back th...