RE: $$Excel-Macros$$ Re: Ned Maxif

2010-09-07 Thread Dave Bonallack
You're welcome. Regards - Dave. Date: Tue, 7 Sep 2010 05:45:29 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Re: Ned Maxif To: excel-macros@googlegroups.com Thanks so much. This worked perfectly. From: Dave Bonallack To: "excel-macros@googlegroups.

Re: $$Excel-Macros$$ Re: Ned Maxif

2010-09-07 Thread None
Thanks so much.  This worked perfectly. From: Dave Bonallack To: "excel-macros@googlegroups.com" Sent: Sun, September 5, 2010 2:40:20 AM Subject: RE: $$Excel-Macros$$ Re: Ned Maxif Hi, Please see the attached for a possible solution. Rega

RE: $$Excel-Macros$$ Re: Ned Maxif

2010-09-05 Thread Dave Bonallack
Hi, Please see the attached for a possible solution. Regards - Dave. Date: Sat, 4 Sep 2010 08:40:35 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Re: Ned Maxif To: excel-macros@googlegroups.com Thank you for the response. Unfortunately, the data can't be s

Re: $$Excel-Macros$$ Re: Ned Maxif

2010-09-04 Thread None
Thank you for the response.  Unfortunately, the data can't be sorted.  It needs to stay in the order entered. From: "Kishan Reddy, K" To: MS EXCEL AND VBA MACROS Sent: Fri, September 3, 2010 10:56:47 PM Subject: $$Excel-Macros$$ Re: Ned Maxif

$$Excel-Macros$$ Re: Ned Maxif

2010-09-04 Thread Kishan Reddy, K
Sort the data (column A ascending & Column C Descending) for example you are having data from A2 to C100 In sheet 2, column C use Vlookup function (in C2) =vlookup(a2, $A$2:$C$100, 3, false) Regards, Kishan Redyd, K On Sep 3, 10:48 pm, None wrote: > I have a sheet that has 2 columns of data.