Re: $$Excel-Macros$$ vlookup with 2 criteria

2010-05-09 Thread madhu nair
send a sample sheet buddy On Sun, May 9, 2010 at 12:07 AM, nino wrote: > hi, > does anyone have idea or solution to solve search over 2 columns range > where both criteria needs to be met. > e.g. if you have database with 3 columns. column A is account, column > B is cost centar and column C is

Re: $$Excel-Macros$$ vlookup with 2 criteria

2010-05-09 Thread Ravi Megharaj
You can concatenate Column A and Column B to get the unique value. Then do a vlookup to get the exact value. Once performing this operation, you can delete the concatenated column. Hope this helps Ta Ravi On Sun, May 9, 2010 at 12:04 PM, madhu nair wrote: > send a sample sheet buddy > > > On S

$$Excel-Macros$$ Fw: Maximum Date

2010-05-09 Thread DheerajBankoti
Please ignore earlier attached file. Please find the correct attachment. Regards - Forwarded by Dheeraj Bankoti/P&E/PLL on 05/09/2010 11:53 AM - Dheeraj Bankoti/P&E/PLL 05/09/2010 08:17 AM To excel-macros@googlegroups.com cc Subject Maximum Date Dear All, I have a spreadshe

Re: $$Excel-Macros$$-Macro to Prepare Letters

2010-05-09 Thread Atul Kesaria
Hello Andy, I can use mail merge, but thats a manual process and I want to use different format for for preparing letters which might go above 1000+ letter. Thge problem using mail merge manually is that it again require formatting and whicd adds up to more time in preparing letters. Looking forw

Re: $$Excel-Macros$$ Fw: Maximum Date

2010-05-09 Thread deepak kumar
Hi Dheeraj, Why don't you sort the data with Date column in decending order... Thanks On Sun, May 9, 2010 at 12:53 AM, wrote: > > Please ignore earlier attached file. Please find the correct attachment. > > > > > Regards > > > - Forwarded by Dheeraj Bankoti/P&E/PLL on 05/09/2010 11:53 AM -

Re: $$Excel-Macros$$ VBA DATE

2010-05-09 Thread deepak kumar
Hi Sundar, You can do it with conditional formatting, I've attached a work to show you how to do it, you just need to check the formula in conditional formatting option. Thanks On Fri, May 7, 2010 at 5:02 AM, Sundarvelan N wrote: > Hi Friends, > > Can any one help me to solve the below conditi

Re: $$Excel-Macros$$ Maximum Date

2010-05-09 Thread Dilip Pandey
Already answered thisone let me know in case u missed d same. Thx, diLipandey On 5/9/10, dheerajbank...@punjlloyd.com wrote: > Dear All, > > I have a spreadsheet containing quite a lot of data, one of the columns is > date & one of the data. > My user would like to see the latest rows (as this ma

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

2010-05-09 Thread dza7
Guru, I actually want to see both of those line items as percentages of sales which is to say, take gross margin $ and divide it by sales. Same for operating income. Thanks! -- -- Some important links for excel user

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

2010-05-09 Thread dza7
here you go http://www.mediafire.com/download.php?nvt1ymtzjdy thanks for your help! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

Re: $$Excel-Macros$$ VBA DATE

2010-05-09 Thread Sundarvelan N
Hello Friends, I need to do this using VBA Coding. Please help me Thanks, Sundarvelan On Sun, May 9, 2010 at 8:38 PM, deepak kumar wrote: > Hi Sundar, > > You can do it with conditional formatting, I've attached a work to show you > how to do it, you just need to check the formula in conditiona