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...Multiple Chart replication
I have a worksheet that contains six small pie charts but
am having great difficulty in obtaining the same chart
size throughout. Formatting each chart individually is
taking a long time and it obtaining an exact size
replicacation is proving to be an uphill task.
any pointers or tips would be gratefully appreciated!
I wrote an article in Tech Trax e-zine about pie charts, and there's
some useful macros near the end. One of them helps make the charts the
same size. Here's the article:
Jon P...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.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
...Months auto-filter with year twist
I made a new toolbar with 12 buttons, each running a macro:
Selection.autofilter Field:=12, Criteria1:="=??/04/????"
Selection.autofilter Field:=12, Criteria1:="=??/05/????"
for may, etc.
but this gives me this month of all years.
i need a toggle button, that once pressed will put "2005", for example
in this macros inswtead of the ????. and i will make one for 2006 a
yadaaa's Profile: http://www.excelforum.com/me...Auto fit wrapped and merged cells
Using Excel 2003 if you have a number of cells that are merged and wrapped
how can you get the rows to auto fit height - I am sure this used to work on
previous versions of excel but does not seem to now (similarly for columns).
Is there a fix for this or an option I need to select or deselect?
See this macro from Jim Rech:
"elmo2" <email@example.com> wrote in message
> Using Excel 2003 if you have a number of cells that are ...Event iD 2601 2604 2501
These errors have been popping up every fifteen minutes. They started a
couple of days and won't go away. This is Exchange 2007 standard and there
is no clustering.
Event Type: Warning
Event Source: MSExchange ADAccess
Event Category: General
Event ID: 2601
Time: 10:43:24 AM
Process MSEXCHANGEADTOPOLOGY (PID=1980). When initializing a remote
procedure call (RPC) to the Microsoft Exchange Active Directory Topology
service, Exchange could not retrieve the SID for account
<WKGUID=DC1301662F547445B9C490A52961F8FC,CN=Microso...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
...Exchange Event ID 565
I've recently performed a swiing migration from sbs2000 to sbs2003
standard. Everything has been runnig fine except i have recently notice
a large number of failed security events; on a daily basis there can be
between 500-1000 approx of the same event. I have searched the web a
fiar bit over the last week but anything i can find is on eventid.net
but is slightly different errors.
i have also noticed there have been other people asking about this
error in this group but no fix as yet.
Can anyone point me to any further resources? Any help appreciated.
Object Server: Microsoft ...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...Generate tasks for new hires
I am using Outlook 2003. On our staffing team, we have 5 people who
complete several tasks when we have a new person joining the firm. For
New Manager John Doe, beginning 11/15/05
assign mentor for John Doe
add John Doe to employee database
assign performance manager for John Doe
I'm sure there must be an Outlook tool/add-in that can help with this.
Ideally, I'd like to be able to enter in the name of the new hire and
start date, and have the tasks automatically generated and sent to
each person. Hopefully the tool would inse...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...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...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...Strange Auto Change Going on
I have an issue - when ever I enter HSA (apprevation for Health Savings
Account) into a cell, it seem to automatically change it to HAS. This
occures in upper case or lowe case entries.
Is there something strange goining or I have I inadvertently done someting
so Excel things HSA needs to HAS????
Look under tools>autocorrect options, it believes you have a typo when
typing has. Note that any change will change it for the whole office suite.
You can also press space and then ctrl z to undo the "corrections"
"DataGuy" <Dat...Replicating Code!!!
Hi there folks,
I am currently creating a student achievement spreadsheet and I a
using ticks in each cell to state if the student has passed the unit o
I am using a simple VBA code to have any cell, within a specifie
range, ticked upon selecting it. If the cell within the specifie
range, already has a tick, the code will remove it. The trick to th
code is the use of the letter "a" in a cell that has had it's fon
formatted to marlett!!
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target,...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 ...Public Folder Replication #22
Just migrated from Exch 2000 to 2003. If I want to set or remove Public
Folder replication I have to do this for each and every public folder. Is
there any way to automate this?. We have quite a few PF's and it's a real
...Event ID 1023
I keep getting the following error in my Exchange server event viewer
approximately every minute :
Event Type: Failure Audit
Event Source: MSExchangeIS Private
Event Category: Logons
Event ID: 1023
DOMAIN\Administrator was validated as
but was unable to log on to
Does anyone know how to rectify this ? couldn't see anything in knowledge
base....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 ...Getting Shell Task ID from lost process
I am experiencing problems when using the Shell function in that
periodically the returned task ID connection is lost.
The external task/application launched via the Shell is still active,
but the task ID becomes invalid.
I seem to remember that somewhere in Access there used to be a way of
scanning all active processes on the machine and interrogating their
details in order to "grab" the appropriate process again. However, I
cannot remember the technique or the add-in that does this.
Can anyone remind me of the technique please?
I am using Access 2003 on Win...Auto Fill Options #6
Until today, the default of my auto fill options was copy cells; in addition,
I never saw the auto fill box, ever. I've disabled the show paste and show
insert options so the box doesn't appear but it defaults to fill series and
adds a day to each date I drag and drop. Holding down the control key
overrides the fill series default but I'd like to go back to copy cells as
the default. Can it be done?
I think it depends on what you have selected.
If I put 1 in A1, select just A1 and drag that fill handle down, excel copies
If I put 1 in A1 and 2 in A2, select A1:A2 a...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...