I have a spreadsheet with
Date Name Otherstuff
columns.
The spreadsheet is in DATEorder (if that is relevant).
There are multiple identical NAME entries.
What function will give me the latest/highest DATE value for a given NAME
value in a cell?
--
Binyamin Dissen
Sort by name, date descending. First cell for a name will be the latest info.
Use a pivot table to display 1 entry per DSN.
http://chandoo.org/wp/2010/09/27/remove-duplicates-using-pivot-tables/
On Tue, Jan 24, 2012 at 10:49 AM, Binyamin Dissen
bdis...@dissensoftware.com wrote:
I have a
I want it to be dynamic and not require playing with the data.
If a new Date/Name is added with a later Date for Name, I want the latest date
field to be automatically updated.
On Tue, 24 Jan 2012 11:28:09 -0600 Mike Schwab mike.a.sch...@gmail.com
wrote:
:Sort by name, date descending. First
Thanks for pointing to the site.
I found
=SUMPRODUCT(MAX(($B$2:$B$401=L10)*($A$2:$A$401)))
On Tue, 24 Jan 2012 11:28:09 -0600 Mike Schwab mike.a.sch...@gmail.com
wrote:
:Sort by name, date descending. First cell for a name will be the latest info.
:
:Use a pivot table to display 1 entry per
-Original Message-
From: IBM Mainframe Discussion List
[mailto:[EMAIL PROTECTED] On Behalf Of Ed. Benoit
Sent: Wednesday, December 05, 2007 8:48 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Excel Question
Hello All,
Any Excel List that I can ask these questions?
I have some email
John,
What is a paragraph mark? I will attempt this if I can make the change from
comma to a paragraph mark.
Ed. Benoit
Recovery Knowledge
DB2 Automation Is Our Only Business
562-436-3660
**Check out AOL's list of 2007's hottest
products.
PROTECTED]
Sent: Dec 5, 2007 9:47 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Excel Question
Hello All,
Any Excel List that I can ask these questions?
I have some email addresses in a WORD document separated by commas and I
would like to get them in a EXCEL document in the first column. Copy paste
do
Thanks to everyone the problem is fixed.
The replace with a ^p (caret p). is what I used but I thank everyone for the
help.
Ed.
**Check out AOL's list of 2007's hottest
products.
(http://money.aol.com/special/hot-products-2007?NCID=aoltop000301)
Is there a way to do this with copy and paste that I do not know?
PASTE SPECIAL -- UNFORMATTED TEXT
-
Too busy driving to stop for gas!
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL
: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of HUTCHISON Gregory
Sent: Wednesday, December 05, 2007 7:26 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Re: Excel Question
I've done similar to this by following these steps:
1. Name your document .csv instead of .doc or whatever
Either of these two listservs:
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of Ed. Benoit
Sent: Wednesday, December 05, 2007 9:48 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Excel Question
Hello All,
Any
Ed. Benoit wrote:
Any Excel List that I can ask these questions? I have some email addresses
in a WORD document separated by commas and I would like to get them in a
EXCEL document in the first column. Copy paste do not work because Excel
will spread them out to all columns.
(1) Is there a
Hello All,
Any Excel List that I can ask these questions?
I have some email addresses in a WORD document separated by commas and I
would like to get them in a EXCEL document in the first column. Copy paste do
not work because Excel will spread them out to all columns.
(1) Is there a way
wizard and you can manipulate the data using
EXCEL.
-Original Message-
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of Ed. Benoit
Sent: Wednesday, December 05, 2007 6:48 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Excel Question
Hello All,
Any Excel List that I can
PROTECTED] On Behalf Of Ed. Benoit
Sent: Wednesday, December 05, 2007 8:48 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Excel Question
Hello All,
Any Excel List that I can ask these questions?
I have some email addresses in a WORD document separated by
commas and I
would like to get them in a EXCEL
the copy completes, delete your first row
-Original Message-
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of Ed. Benoit
Sent: Wednesday, December 05, 2007 8:48 AM
To: IBM-MAIN@BAMA.UA.EDU
Subject: Excel Question
Hello All,
Any Excel List that I can ask
16 matches
Mail list logo