Perhaps someone can help me with an excel question

2012-01-24 Thread Binyamin Dissen
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

Re: Perhaps someone can help me with an excel question

2012-01-24 Thread Mike Schwab
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

Re: Perhaps someone can help me with an excel question

2012-01-24 Thread Binyamin Dissen
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

Re: Perhaps someone can help me with an excel question

2012-01-24 Thread Binyamin Dissen
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

Re: Excel Question

2007-12-05 Thread McKown, John
-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

Re: Excel Question

2007-12-05 Thread Ed. Benoit
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.

Re: Excel Question

2007-12-05 Thread Lizette Koehler
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

Re: Excel Question (Problem resolved)

2007-12-05 Thread Ed. Benoit
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)

Re: Excel Question

2007-12-05 Thread Ted MacNEIL
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

Re: Excel Question

2007-12-05 Thread HUTCHISON Gregory
: 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

Re: Excel Question

2007-12-05 Thread Hylton Tom P
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

Re: Excel Question

2007-12-05 Thread Elardus Engelbrecht
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

Excel Question

2007-12-05 Thread Ed. Benoit
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

Re: Excel Question

2007-12-05 Thread HUTCHISON Gregory
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

Re: Excel Question

2007-12-05 Thread Big Iron
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

Re: Excel Question

2007-12-05 Thread Hardee, Charles H
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