Find the last, 2nd last and 3rd last data in a column
I have data listed in several colums and need to create a formula to
detail the last (most recent) 2nd last and 3rd last piece of data in
I have used the following formula to display the last but cant edit
this or create another formula to get the 2nd and 3rd last pieces of
Thanks in advance
If there are no empty cells in the range:
last cell: =INDEX(A:A,COUNTA(A:A))
Bernard V Liengme
Microsoft Excel MVP
r...Check out that critical update from Microsoft Corporation
Content-Type: multipart/related; boundary="dhlafoghz";
Content-Type: multipart/alternative; boundary="deplkaudlpt"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three new vulnerabilities.
Install now to continue keeping...Query from day of week
I need assistance in creating the formula to select one week ago Wednesday
through Thursday of the current week. This query needs the ability to be run
on any day of the week. Below is the formula I have in place but it returns 8
days ago through yesterday. If this is run on Wednesday it works correctly
but I need it to be run on any weekday.
>=Date()-Weekday(Date())-2+1*(Weekday(Date())=4) And <=Date()-Weekday(Date())+3+1*(Weekday(Date())=1)
My apologies but I stated "one week ago Wednesday through Thursday" below but
it should read "one week a...Payroll Posting Issue #2
We are trying to process payroll on Dynamics GP 9.0 and our posting
process slows down all of sudden. It prints like 3 payroll reports and
then it takes a long amount of time before it starts processing and
printer the remaining reports. We even has all the user log off of
great plains and close all applications on client terminal where we
faced this issue.
We also noticed an issue with posting GL's where the application slows
down and it takes a while until it's done with the process.
Had anyone faced an issue similar to this one? Any suggestions on
what's going on on this one?
...Exchange Server Missing in the Group
I just noticed the Exchange Domain Servers Security Group Only shows 1
Exchange 2003 in there as its member.
I have 3 more and they are Exchange 2007? 2 are Cluster Nodes and 1 is
Adding the rest of the servers manually would not hurt - right?
It shouldn't but they don't need to be there. Exchange 2007 creates new
groups. They should be there.
Ed Crowley MVP
"There are seldom good technological solutions to behavioral problems."
"WildPacket" <WildPacket@discussions.microsoft.com> wrote in message
new...How can I display worksheet summary page ie title/size/last updat.
I'm running MSExcel 2003.
I am often working with large workbooks with mutiple worksheets. It would be
v helpful if I could see/sort and print off a summary that shows worksheet
properties similar to Explorer eg:
worksheet last update size
names 1/2/04 64k
companies: 5/2/03 893k
I wrote this sometime ago and it works as a workbook_open event (Needs to be
placed in the ThisWorkbook code module). It could be adapted to work
otherwise though. It adds a sheet and lists all the built-in and c...good documentation on the new task scheduler under windows 2008 server?
i have been using task scheduler successfully for a number of years
under windows 2003 server. i am now trying out the new version under
windows 2008 server. on the one hand it looks as though there are some
great new features. on the other hand, some very basic things seem
hard to find and frustrating.
my web searches for documentation have so far turned up very basic
stuff that hasn't helped me much. can anyone recommend any good
documentation? is this the best news group to post specific questions?
Better use the Technet Forum f...Auto posting a payment transaction miported via eConnect
Our website allows a customer to pay off their oustanding balance via a
credit card. When we successfully take their money, we import a payment
transaction into Great Plains via eConnect to document the event.
Our problem is that the payment transaction appears as an unposted
transaction in GP. We trust the source of this document, and would like the
payment transaction to be posted in GP ASAP.
Can we post the transaction as part of the eConnect document? If so, how? If
not, then are there are third-party apps that provide this functionality?
Thanks in advance
You can create a macro in G...Subtract working days
I'm tring to calculate todays date and subtract a number of working days
and have the answer in date format.
A1 = 02 November 05
B1 = 5
C1 = Would result in 27 October 05
Any help would be appreciated
teeb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=13172
View this thread: http://www.excelforum.com/showthread.php?threadid=480981
> I'm tring to calculate todays date and subtract a...Exchange license does not appear in Server license list
I have just recently migrated from exchange 2000 to 2003 except this time
echange is not running on a DC. But on the DC under license there is not the
drop down to add exchange license-exchange is running on a member server
within my domain-how do I get the drop down to show exchange 2003 or just
On Fri, 17 Feb 2006 16:13:28 -0800, Gordon
>I have just recently migrated from exchange 2000 to 2003 except this time
>echange is not running on a DC. But on the DC under license there is not the
>drop down to add exchange lice...Microsoft Mail Transport
Is there any way to allow the use of the Microsoft Mail
transport with Outlook 2002. Everything I have read on
the Microsoft web site says it is unsupported, but doesn't
mention if it is possible to use. Our office is using a
Microsoft Mail Post office but we have some computers
using Outlook 2002 and some using Outlook 2000 (which is
able to utilize the Microsoft Mail transport). Any help
would be appreciated.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows ...Newsgroup microsoft.public.dataprotectionmanager will stop working from June 30 onwards.
As many of you already would have read about newsgroup deprecation.
DPM newsgroup will be deprecated on June 30 onwards. To discourage activity
on newsgroup and to encourage everybody to move to Technet forum, from now
onwards DPM team will not be actively verifying that the customer queries
are answered in newsgroup. Everybody who is using the newsgroup to get
queries answered please shift to technet forum before newsgroup services are
Technet Forum website:
You need a Live ID to ...I get an error message on outlook cannot connect with web server .
alll of a sudden I caan't update the calendar I posted on office live. It
says outlook cannot connect to web server? I downloaded the recent share
point server after this message, but it is still happening....help.
Known issue -
Go to office.com and sign in with the same Live ID you use to publish your
calendar and select "Save my e-mail address and password". Restart Outlook
and the browser. It should now work for either publishing or updating a
subscribed calendar, at least until you sign out of Office Online and/or
I’m not sure what the secret is - ...Post cards Am I able to type addresses on all four cards before
I am doing a mailing without being able to mail merge. Can I type names on
the post cards before printing. I know I can one at a time but have 4 to a
sheet. If so please let me know how.
Arrange, Layout Guides, type your outside margins, Grid Guide tab, 2 columns,
spacing 2 times the margins, two rows, spacing 2 times the margins.
Mary Sauer MVP
"Georgia" <Georgia@discussions.microsoft.com> wrote in message
>I am doing a mailing without being able to mail ...CRM Server Down: Authentication Error
If you have a solution please advise me soon:
After IT install some hotfix + .Net famework 2.0 + Service pack for .Net
Frame work 2.0 and our server stop working.
The error message is:
Microsoft CRM could not log you on to the system. Make sure your user record
is enabled and that you have been assigned at least one security role. For
more information, contact your system administrator.
What I have done:
1. Backup _MSCRM & _METABASE
2. Reinstall CRM Server with the same org_name
3. Restore the backup of _MSCRM & _METABASE
But system keep the same...How long will my capital last
If I had a capital sum of say �100,000 and I was taking an annua
income of 5% and I was getting 3.5% interest annually - Can you help m
demonstrate how long my capital last?
Message posted from http://www.ExcelForum.com
If, by 5%, you mean 5% of the original investment (=A35.000 each year), =
your money will last for approximately 35 years at 3.5% interest.
See Excel Help for more info on NPER().
"Durhamr" <Durhamr.firstname.lastname@example.org> skrev i meddelandet =
news:Durhamr.yajun@excelf...Multi-select listbox question
I have a multi-select listbox and wish to obtain data from the last clicked
record in the listbox (you'll notice that if you make multiple selections
then only the last-clicked record has a dotted line around it). What, if
any, listbox property identifies this record as last-clicked?
Posted via a free Usenet account from http://www.teranews.com
...change color of bar on multi-day event shape
Is there a way to change the color of the "bar" across the top of a
multi-day event shape?
I can change the fill color, but not the bar is always blue.
On Tue, 16 Mar 2010 22:43:11 +0800, "Jennifer Virley"<email@example.com> wrote:
>Is there a way to change the color of the "bar" across the top of a
>multi-day event shape?
>I can change the fill color, but not the bar is always blue.
Open the Drawing Explorer window (menu View -> Drawing Explorer
Look for the appropriate shape on the ...Microsoft outlook 2000
How do I set up the server info, ect to make my Outlook mail work? I have
Windows 7 installed.
Michael R. Cook
First of all, Outlook 2000 is not fully compatible with Windows 7,
same as with Vista:
Your mail service provider will typically have a web page that shows how
to set up mail service with popular mail clients like Outlook.
The newsgroup to which you posted is for the Windows Mail program.
You are more likely to find Outlook experts in the Outlook newsgroup:
http://social.answers.microsoft.com/Forums/en-US/categor...why is my last digit converted to zero?
I'm using Excel 2003 and when I enter a 16-digit number or cut and paste a
16-digit number, the last digit is converted to zero. This does not happen
with 15 digits or fewer.
Excel's numeric precision is 15 decimal digits.
If you need to calculate with the number, you probably won't miss anything.
If the number is a key, such as a creditcard number, add an apostroph
(single quote, " `") before it; it will not show, but it will cause the
number to be treated as text.
Another way is to format the cell as text before entering the number
I am running DPM 2007 with the latest patches. When backing up server 2008
System States, the size varies greatly. I see that the backups include a VHD
in the WIndowsImageBackup folder.
On a given day the size may be 8GB and that would be consistent for several
days. Then for several days it may be as low as 600MB and then jumps to
something in the gigs again.
What accounts for the variability in the size?
Are there any scheduled/un scheduled backups are happening on the local
system other than the DPM doing the system state backup?
Praveen D [MSFT]
This p...Need help in searching last occurrence of string in text file
I am not good in file handling in excel macro..i need some help from
I have one huge text file and i want to search last occurrence of
string in that file and then cut the data after that searched line
till end of file and paste it into a new text file.
Any help appreciated. thanks in advance.
How huge is "huge" (in Megs)?
Rick (MVP - Excel)
<firstname.lastname@example.org> wrote in message
> Hi ,
> I am not good in file handling in excel macro..i need some help from
> I hav...Last logged on by
Using exchange 2003.
When I look under Adminstrative groups -> Server -> "name" -> First storage
group -> mailbox store -> mailboxes you can se all the mailboxes that
you have and last logged on by. Under last logged on by I can se that one
person (me) have logged on on to diffrent acconts, even if I havent don it.
WHAT is this?
Did you use your account as the service account for anti-virus or spam?
Also, IIRC, even if you view someone's Outlook Calendar, it would mark the
mailbox as being logged on by you.
Regards...Posting Problems- massive reports, same doc number over and over
We have encountered a problem twice now while posting. Once was in SOP and
the other was Cash Receivables.
The problem is it is generating massive reports with the same document
number, same credit, debit and net amounts and different customer numbers and
different dates. Document dates should only be for last couple of days but
instead go back years. There do not appear to be any other symptoms and it
does not generate an error.
It's GP 7.5 SQL. Has been running good for about a year and there have been
no recent changes or events to the system.
Any insight is appriciated.
...Upgrade 5.5 to 2k3 but cannot use free-busy on new server
Dose anyone know hot to fix problem with free/busy scheduler.
We are running Exchange 5.5 just because the free/busy have not replicated
to the new server.
Our replication dose not work anymore. Can't access public or system folders
in Exch2k3 from Exchange Manager sw.
Once Exch.5.5 is switched off we don't have scheduler information in
Outlook, otherwise everything seams to work.
Many thanks for your help.
Did you setup the system folder replication using the 2003 Exchange
System Manager tool?