RE: $$Excel-Macros$$ Please help to make my project good.

Hi Karan, Use this formula, =OFFSET(IF($A$2=Administration, Business and Office Work,'Administration, Business and Of'!A1,IF($A$2=Building and Construction,'Building and Construction'!B1,'Catering and Hospitality'!A1)),'Building and Construction'!$I$2,0) And copy in all your gray cells

RE: $$Excel-Macros$$ Calculate Due dates

I think Ashish is right use this, Still try with this mmm' Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mr excel Sent: Wednesday, May 11, 2011 8:37 PM To:

Re: $$Excel-Macros$$ Please help to make my project good.

pfa On Thu, May 12, 2011 at 12:31 AM, Mahesh parab mahes...@gmail.com wrote: Hi check whether attach file helps. On Wed, May 11, 2011 at 3:51 PM, karan 1237 karan1...@gmail.com wrote: Respected Sirs/Mam, I need your help making my project good. Please find attachment. I will be very

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 12 Messages in 8 Topics

hi to all thanks in advance here iam attaching one file i need like that but idont know how to do this can u help me any one Pl thanks regards On 12 May 2011 05:58, excel-macros+nore...@googlegroups.com wrote:   Today's Topic Summary Group:

$$Excel-Macros$$ Copy paste data for dynamic data_need Excel Macro Solution

I have got following data in excel. I need to copy 1st number in given row for e.g. 122532 should be copied against 100 for 4 times similar way 321654 should be get copied against 200 for 3 time like way. ( Problem is that I'm not sure how many times 100 or 200 nos. comes ) kindly suggest me

$$Excel-Macros$$ How to change Date format

Hi friends, Plz help to change date format when downloaded report from 1st of every month to 9th of the month will be like DMMYY . I have no issue in changing the format using text to column from 10th date because it will be in DDMMYY. I have attached the sample sheet for your reference.Plz

$$Excel-Macros$$ fixing Format of pivot table noit working

Hi guys is there anyway to format a pivot table and it´s stays that way whether i insert or take the options from and columns labels and row labels because when i change the design of the pivot it put´s everything back to standard like Sum of Jan instead of Jan like i what i tried to do with a

Re: $$Excel-Macros$$ Consolidate data

Hi, Thank you everybody send reply, all are perfect answers. Regards Rajesh kainikkara On 5/11/11, ChilExcel chilexcel...@gmail.com wrote: Please see attached file By Chilexcel 2011/5/10 Rajesh K R rajeshkainikk...@gmail.com Hi Experts Pls check the attached file and tell me how to

Re: $$Excel-Macros$$ HELP SECOND MAIL

Hi Mahesh, firslty thanks for your great favour it is working fine but some times it happen to ask the path2 name i created one folder with dump and created one sub folder as Working then i placed the Before After Entry sheets dump.xls , Global Company Code List .xls in both dump folder and

$$Excel-Macros$$ Re: How to change Date format

Use this in E2 and drag down =DATE(2000+RIGHT(B2,2),LEFT(RIGHT(B2,4),2),LEFT(B2,LEN(B2)-4)) On May 12, 5:14 pm, Prabhu prabhugate...@gmail.com wrote: Hi friends, Plz help to change date format when downloaded report from 1st of every month to 9th of the month will be like DMMYY . I have no

$$Excel-Macros$$ if with 3 criteria

Hi Experts, Pls find the attached file and solve the issue regarding if function. Regards Rajesh kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Re: How to change Date format

another variant =DATE(20RIGHT(B2,2),MID(TEXT(B2,00),3,2),LEFT(TEXT(B2,00),2)) On Thu, May 12, 2011 at 8:58 PM, GoldenLance samde...@gmail.com wrote: Use this in E2 and drag down =DATE(2000+RIGHT(B2,2),LEFT(RIGHT(B2,4),2),LEFT(B2,LEN(B2)-4)) On May 12, 5:14 pm, Prabhu

Re: $$Excel-Macros$$ if with 3 criteria

Hi Rajesh, I am not clear with you problem, yes u can use And function for multiple criteria. for example =IF(AND(B4=1212,C4=1117),E4,G4) the content in yellow are the two conditions thanks On Thu, May 12, 2011 at 8:51 PM, Rajesh K R rajeshkainikk...@gmail.com wrote: Hi Experts, Pls find the

Re: $$Excel-Macros$$ if with 3 criteria

On Thu, May 12, 2011 at 8:21 AM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts, Pls find the attached file and solve the issue regarding if function. Regards Rajesh kainikkara -- -- Some important

$$Excel-Macros$$ Re: if with 3 criteria

=IF(D2=200,0,IF(D2=500,7.5,12.5)) On May 12, 8:21 pm, Rajesh K R rajeshkainikk...@gmail.com wrote: Hi Experts, Pls find the attached file and solve the issue regarding if function. Regards Rajesh kainikkara  If function .xls 18KViewDownload --

Re: $$Excel-Macros$$ if with 3 criteria

Another solution, hope it helps. Christo On Thu, May 12, 2011 at 5:21 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts, Pls find the attached file and solve the issue regarding if function. Regards Rajesh kainikkara --

Re: $$Excel-Macros$$ if with 3 criteria

The solution already provide in the previous email .. Regards Santosh Bahuguna On Thu, May 12, 2011 at 9:12 AM, irfan khan oops.k...@gmail.com wrote: Hi Rajesh, I am not clear with you problem, yes u can use And function for multiple criteria. for example