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...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...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.email@example.com> 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
...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
...Outlook 2007 Reminders
I am using Outlook 2007 with XP Pro.
Once in a while when I start Outlook all of my prior Outlook Calendar items
show up in the reminders as due. I then say dismiss all and eventually the
over 1000 reminders are cleared. Then everything is fine (even after
several reboots) until sometime later when the reminders again show up as
I would appreciate any help.
Try starting Outlook one time with the /cleanreminders switch. =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact...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...sell Final Fantasy XI gils,sell lotro gold,FFXI,lotro gold trade onwww.allgametrade.com
After playing Final Fantasy VII, I really was not expecting much from
FFIX. Fortunately, I
was very wrong. Final Fantasy IX is probably one of the best Final
style RPG games in a long time, if not ever. As a result, this is one
of those games that I
don't see myself putting down for some time to come, even after
spending countless hours
writing this guide. However, while I could fawn all over the game for
quite some time, I
shall spare you that for now.
As with any Final Fantasy game, FFIX is fairly long. While it is
possible to get to the end
in less than 12...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...Ex 2003 sp1 stops responding
Yesterday we experienced the problem described in KB830829,
Event ID 9646 : maximum of 848 objects of type "objtMessage" after one user
bulk deleted thousands of spam mail.
We have increased this value from default 250 earlier trying to get rid of
the error messages. But yesterday Exchange stopped responding after having
Microsoft say this is a known problem, does anyone know if they have a fix
for this (server stop responding).
We have put the value of "objtMessage" back to default 250, since I dont
know if it is the increased value which caused t...First and Last Problem
For some reason First and Last are giving the wrong data in a Totals
query. I assume that somehow the data is not ordered correctly in the
main table, but it does show correctly in the datasheet view. For
example if I group the sample database below by Name and Year, First
of Location should be B, unfortunately it shows up in the query as
Name Year Stint Location
Ed 1999 1 B
Ed 1999 2 A
Ed 2000 1 A
Name Year Stint Location
Ed 1999 1 B (But shows up as A)
Ed 2000 1 A
Any ideas from someone who has seen thi...How can I generate a file dependent on linker output, which the linker then needs to generate the final dll using VS2005?
I need to process the map file that's generated by link on a C++ project, in
order to generate the the .DEF file I really want to link with.
Effectively, I want to make only some of the exports from my DLL available,
and also I want to reference them by ordinal only. For those of you who
have looked at how MFC works, will recognize this as being similar to the
method in MFC80.def
I can't really see any way to do this, as there doesn't seem to be any
simple way to run the link command again with similar arguments to those
However, I did come up wit...Extract last name from Last, First
I know this has to be a common question, but I can't find the answer...
Using VBA, I need to extract the last name from the format:
the cell contents extract to a variable the value of
JONES, AMY JONES
ADAMS, HARRY ADAMS
Your help would really be appreciated!
I don't know how you are using it, but this shows how to get it in a
Dim lName As String
lName = Left(ActiveCell, InStr(ActiveCell, ",") - 1)
...Not Remember Last Login Account
Is there something to tell Dynamics GP 10 to not remember the last logged in
account? Everytime I log into their system as SA to do some update they call
and ask me what to put in the username field. If they have to type it each
time surely they will remember.... ARRRRGGGGHHHH!
Have a look at my post
Otherwise wait for the next release of the Support Debugging Tool which ...Goto Last Cell function
I have an application where I would like to create a
function that goes to the last cell in a spreadsheet. I
can get this to work if I manually use the
<Goto...special...last cell> function, but when I put this
command into a macro and increase the length of the
spreadsheet, the macro will only go as far as the last
cell when the macro was saved.
Here's a slick formula from Harlan that will return what's in the last
cell in a column,
if you need the whole column use A65535 inste...Concatenate first:last! worksheet
I need to concatenate 150 rows in 50 different worksheets for a totals page,
and may need to add additional worksheets in later versions. So, I need P7
in all 50 worksheets to be concatenated on P6 in the totals page, P8 in all
worksheets to be concatenated on P7 in the totals page, etc. I am wondering
if it's possible to use something like first:last! to concatenate the
worksheet range, making it possible to include additional sheets added in
before the current last worksheet.
I am using "&" for the concatenate function now as I have more than 30
sheets ...How do I change the mispelling of my last name in my emails?
For some reason, my last name is mispelled in my emails. Who or how do I
correct this problem?
If it a POP3 or IMAP account, you can make the change in the account
properties at tools,accounts, view or change accounts - you need to select
your account and change it. If it's an Exchange account, you need to speak
to your administrator.
On 4/24/06 9:08 PM, in article
> For some reason, my last name is mispelled in my emails. Who or how do I
> correct this problem...the Last occurance
I need to now how I can get the last Row number of last occurance of an item
in a list, for example:
I want a formula to return me row number 4 after looking up A.
On Thu, 18 Feb 2010 15:51:01 -0800, peyman <email@example.com>
>I need to now how I can get the last Row number of last occurance of an item
>in a list, for example:
>3 ...LAST, FIRST to First Last
I have data in LAST, FIRST and used this formula...
Is there a way to change it from all caps to just capitalized names.
currently - DOE, JOHN
change to - John Doe
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
"Erinayn...remove last character in a series of different length part #'s
i have a series of part numbers in a column in xl that vary in length but
all end in "v'. I want to remove just the "v". I tried text to coulmns and
all the functions i know.
If the v only shows up in the last character, maybe just
select your range
with: leave blank
If you don't want to do that, maybe a helper column of cells:
and delete the original column
> i have a series of part numbers in a column in xl that vary in length but
> all end in "...How to index the data of last column
How to index the data of last column
if the column contains blank data
1 2 _ 3 4 _ 8 5
if didn't use temp data
is it possible to get the "5" by one formula?
Thanks a lot
Man, that is confusing. :confused: What are you trying to do?
Mallycat's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35514
View this thread: http://www.excelforum.com/showthread.php?threadid=553002
Array formula, to be validated w...Reminders, Tasks and Appointments in 2003
I just upgraded to OL 2003 and don't always have it open or active when I
have an appointment, task or reminder set to alert me of something I need to
take of at that time.
Is there a way to set OL to "go off" even if it is not open or active?
Thanks very much.
No, the program has to be Open to work. You can try a third party program
that will keep a stub of Outlook open to notify you of new mail and
Try this page for a list of suitable candidates:
Milly Staples [MVP - Outlook]
Post all replies to the group t...I finally found SEO Services
After using 10 different seo companies over the last 2 years for all
my sites the only one that got me the conversion rates like I wanted
was http://seoservicesextreme.googlepages.com/seoexpertservices this
SEO firm. Really, I thought their prices were outstanding, by that I
mean expensive but after two months of service, it was worth every
dollar. Here is their pricing, http://seoservicesextreme.googlepages.com/seoexpertservices
So I called them How do you think their rates compare?
...WMP Opens up to the last played video
When I close Windows Media Player and re open it, the last played video is
brought back up paused at the point when I closed Windows Media Player. Is
there a way to disable this?
no, and one must be very careful with this problem.
"mavalent" <firstname.lastname@example.org> wrote in message
> When I close Windows Media Player and re open it, the last played video is
> brought back up paused at the point when I closed Windows Media Player.
> there a way to disable this?
I was wondering if you could help me with my problem.
If you have data in your worksheet and you say delete all the data in the
last row, when you say F5 (Goto) "Special" and select "Last Cell" then it
will always go to the data row that you have just deleted. There seems no
way to get the "Last Cell" to update to where the last data is. Does anyone
know to resolve this issue please.
Thanks in advance.
Deleting the data won't impact the "Last Cell". The "Last Cell" doesn't
refer to the current data. It refers to the la...