Oldest date for Duplicate Cust. #
I'm trying to get the oldest date associated with a
customer number, and in the Cust# column, i'll have many
duplications of the same customer number.
Let's say A is "Date", and B is "Cust#".
(I won't be able to allow my users to sort the data, so
i'll need a formula that returns either the oldest date,
or the cell which contains the oldest date.)
Any help is much appreciated!
Nevermind. I found it using Google/Groups.
>I'm trying to get the oldest date associated with a....pdf save as settings
Hi, In Office 2007 Pro is there a way to change the settings such as
preventing content copying etc. when saving a file to pdf? I have been
trialling Open Office, alongside Office 2007 Pro (full version not a trial),
which allows access to these settings but I can't see a way to do it in MS
MS Office doesn't do that.
> Hi, In Office 2007 Pro is there a way to change the settings such as
> preventing content copying etc. when saving a file to pdf? I have been
> trialling Open Office, alongside Office 2007 Pro (full version not...Joining text with a formula in cell #4
just to complete the thread...
I found the answer.
You have to change the format of the cell to custom 0.00"*"
this is the only way it will show only 2 decimal places
Thanks for the hel
Mustard Head's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1630
View this thread: http://www.excelforum.com/showthread.php?threadid=27700
The problem of a date code... I need to address this so that fo
example, 5/6/04 can be correctly entered as either 5th of June or 6t
of May, depending from where the date emanted.
Message posted from http://www.ExcelForum.com
Couldn't you format the cell as mmmm dd, yyyy so that the user sees what date
they entered in a non-ambiguous manner right away?
Or maybe provide 3 inputs: Month, day, and year.
You could combine them elsewhere.
"adn4n <" wrote:
> The problem of a date code... I need to address this so that for
> example, 5/6/04 can be c...Web query timeout setting.
I fill an Excel table using data that I take from an Internet
Unfortunately, this site is very slow and so I often get a "query did not
provide any data" error message.
How can I increment the default web query timeout limit?
Thanks in advance,
...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <firstname.lastname@example.org> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
&...Qrp Date functions
Where do I find the various functions to modify the Reports
like cast(DatePart(Dd,[Transaction].Time) as nvarchar) and others
and what they mean????
Found the information at MSDN Transact-SQL Reference
"Barry L" <email@example.com> wrote in message
> Where do I find the various functions to modify the Reports
> like cast(DatePart(Dd,[Transaction].Time) as nvarchar) and others
> and what they mean????
Subject: Extending formulas
For my application that uses Excel for calculations. I need to be able to extend the forula base of Excell with complex scientifc functions. Is there a way to add new functions to the Excel function base?
MS has provided Visual Basic for Applications (VBA) to customize Excel
with new functions, commands, forms, menus, etc.
Tools|Macro|Visual Basic Editor
From the VBA editor
Then write your functions in VBA. Details of writting functions in VBA
is a very big topic,
may help y...I would like to know how to set up a 'fill in the blanks' form?
I would like to set up a templet of sorts to fill in the blanks for
I am entering clients into a 2007 Excel spreadsheet. How do I make the entry
turn color when 14 days have passed?
This is a multi-part message in MIME format.
As part of the "client" entries, do you enter the date the client was
entered? This would be the key in doing this task.
In a cell on the worksheet you could enter the formula for today's date
like this =TODAY().
Then use the con...Ctrl+D not working on outlook messages
Any idea why?
> Any idea why?
And what are you expecting to happen?
"alltimefav" wrote in message
> Any idea why?
So instead of hitting Ctrl+D to delete an item, what happens when the
item is selected and you hit the Del key, or the "X" toolbar button,
or right-click on the item and select Delete?
Did you really expect a detailed response for such a vague question?
You didn't even bother to say what "not working" means, like the item
does not get delete...Short time vs short date
In my form I have a fldOutOfRoom which the user inputs a short time into the
field, i.e, 0900.
I have the following code in the open event of another form called frmRNnotes:
If DateDiff("h", Forms!frmPtDemographicNew!frmVisitNewEdit.Form!OutOfRoom,
Now) >= 1 Then
Me.cmdRNnotesEdit.Visible = False
This code gives the RN one hour to complete a note and then he/she can no
longer edit the note.
What I want to know is the Short Time format going to let the cmdRNnotesEdit
button be visible everyday within one hour of the of the original time? That
is, is the short time just a tim...I want to add a mail account without setting a SMTP server. Is it possible?
I want to add a second mail account that is outside my company.
Since the company firewall does not allow us to connect to SMTP-servers I
to add this account without setting the SMTP propertiy.
I cannot specify the company server as it is an Exchange server and the
outside one an IMAP one.
Currently I have specified the outside SMTP server since outook does not
allow me to add an account wihtout setting this.
I keep getting annoying error messages as my computer can't connect to the
Any one know a way around this?
The company server has SMTP enabled, u...Date Calculation
I have a DB which tracks training of employees. The grace periods allowed
with the training is that new training can be completed within 90 days of the
expiry date without changing the anniversary date (e.g. the training is due
on 1 April 2010, the employee conducts the training on 2 January 2010 but
gets to keep the 1 April anniversary date).
The table I am working with is mainly based on the date of training and the
training type (which determines whether the training expires on the 1st of
the 13th, 25th or 37th months or if it keeps the same date); what I w...Need to add to current formula
I have this formula that will cause values to change based on the mont
that is referenced in the formula ($L$1). Currently the formul
I need to add August, September, October, November, & December to thi
formula but excel is not allowing me.
Does anyone know how I can get around this? Oh by the way
November thru April =2, May and October=4 and June thr...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
I have two sheets Data and Summary
The "data" sheets macro extracts data from external file and paste into
Everytime the m acro is run to get latest data...
The macro delete all contents of the "data" and then paste new data into the
Is there a way.. I can put a date on the "summary" sheet, when was the time
the macro was run ( or in other words.. the data updated)
This little macro records the date in the selected cell and formats it:
Dim d As Date
Dim s As String
d = Now()
s...Date function quit working
I have an Access 2002 application that I have been running on Windows XP SP2
I just installed the application (running in Access Runtime) on a Windows
Vista Home Premium machine. Now, anywhere I used the =Date() function, it
fails and just shows #Name?
I also have a subform on one of my forms that has now gone blank. It also
uses the date function.
I had this problem when I converted to Windows XP several years ago and
updating the OWC10.dll to version 6619 fixed both issues.
However, everything I have read says that reference file makes no difference
to the Access...Macro to change default setting on startup
I am in need of a macro that can change a default setting in excel and for it
to run on startup
The task is:
uncheck Update links on save
Below is the recording of the macro:
..RelyOnCSS = True
..OrganizeInFolder = True
..UseLongFileNames = True
..DownloadComponents = False
..RelyOnVML = False
..AllowPNG = False
..ScreenSize = msoScreenSize800x600
..PixelsPerInch = 96
..Encoding = msoEncodingWestern
..SaveHiddenData = True
..LoadPictures = True
....Date format 04-11-06
Is there a possibility that the dates used in all the entities are not in
the default format mm/dd/yyyy but in dd/mm/yyyy.
I already adapted the Organisatonal settings, that only adapts the journal
but nog the dates of an appointment.
Does anyone have an idea?
I am using Excel 2000 with Windows XP.
I am having a problem. I am on Sheet 2 of my workbook.
I have SSN on a sheet named Employees in the same workbook.
I need to take the numbers on the Employees Sheet and transfer it to the
I know how to do this. It just won't work.
This is a copy of my formula. =SUM(Employees!C3)
This should take the SSN that is in the C3 cell on the employees sheet and
place it at the cell where the formula is typed.
When I put this formula in the cell I am getting just a "0".
Niek Otten...formula auditing/macro
Can anyone give me the sytax to goto - special - precedents so I can create a
macro so I can assign to a hotkey and dont have to go through 4 steps ?
With A1=1 and D2=2*A1, and D1 as active cell:
I recorded a macro for these steps:
And the macro contained just one line:
Bernard V Liengme
remove caps from email
"ynissel" <firstname.lastname@example.org> wrote in message
> Can anyone...SQL query / Formula for Reorder Point?
Is it possible to issue an SQL command(s) that would:
1. Set the Restock Level for all items to be equal to the current on-hand
quantity for each item.
2. Set the Reorder point for all items to be equal to 1/3 of that items
I'm currently doing this manually, or using a formula in excel when items
are initially imported into the DB, but there are still several thousand that
need to be retro-fitted like this...
Thanx in advance!
UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted)
UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0)
Ne...How to Identify Records with Overlapping Dates
I need to be able to systematically identify any instance where there are
overlapping date ranges in a data set. I need to pull records like those
listed below out of a larger data set. I previously posted a question similar
to this and was advised to pull the same table in a query, match on Member
Number, and qualify that the product code from TableA did not match product
code in TableA_1 where the Begin Date TableA was < Term date TableA_1 and
TableA_1 Begin Date < TableA End Date. Which worked great for me finding
overlapping records where the product was different, bu...copy values generated by conditional formula in one sheet to the other work sheet as values
I have data generated by conditional formulae in work sheet1 in
columns A to J. If the condition is satisfied the cell will display a
realnumber, if the condition doesn't satisfied the cell will display
Now I wanted to copy the cells which have the real numbers in
sheet1 to sheet2 as values(as we do with paste special and paste the
values) Do we have any formula or other method to copy the cells in
sheet1 to sheet2. can anybody helpme out in this issue.
Thanks and Regards
Select your range to copy