$$Excel-Macros$$ Re: The Great MphasiS Empoyee Hunt

2010-02-16 Thread gurumurthy sastry Kondury
Please also note that the details of the venue are mentioned in the attachment. They will be screening and interviewing on the spot with offers being given THE SAME DAY. All this is happening on 20th Feb. So Hurry up. On 2/16/10, gurumurthy sastry Kondury wrote: > Hi All, > > I ha

Re: $$Excel-Macros$$ How to skip non working days to calculate number of days betewwn dates ??????

2010-02-22 Thread gurumurthy sastry Kondury
You can use the network days function. Please tell me if it clarifies your doubt. Guru On Mon, Feb 22, 2010 at 5:37 PM, Abdul Rasheed wrote: > > > How to skip non working days to calculate number of days betewwn dates > ?? > > Such as sunday or any vacations came between working days. > >

Re: $$Excel-Macros$$ How to skip non working days to calculate number of days betewwn dates ??????

2010-02-23 Thread gurumurthy sastry Kondury
Hi Anand, You just add +2 to the end of the formula ( In this attachment in Cell C5). Guru. On Tue, Feb 23, 2010 at 8:50 AM, Anand Desai wrote: > Dilipji, > > If we need to consider 1st and 3rd Saturday as working, please guide. > > Thanks in advance > Anand > > On Mon, Feb 22, 2010 at 11:33

$$Excel-Macros$$ Help on a Formula in Excel

2009-04-03 Thread gurumurthy sastry Kondury
Hi All, Please help me with the below query. Suppose I have a folder Named "FOLDER". This folder has 50 Files. I have been maintaining a *Spreadsheet* with the names of all these files. Now I want to pull the data in the Cell 'T100' of each and every file to the *spreadsheet* against each respect

$$Excel-Macros$$ Re: Macros in Outlook

2009-05-12 Thread gurumurthy sastry Kondury
Hi All, Please note that the below attachment is working fine. But when there is not attachment, then If the cells ( Attachment & Doc ) are blank then the body is found missing in the mail. Please help. Thanks & Regards, Gurumurty Sastry K H On 4/10/09, Subu wrote: > > > It was me who shared

$$Excel-Macros$$ Re: Help on VB Password

2009-06-15 Thread gurumurthy sastry Kondury
Hi, I have an Excel sheet with VB Project. But I am not able to edit it as this VB Project is a password protected and the guy created this macro is not with the Org. rt now. Could anyone please help me in this regard Best Regards, Haigreev --~--~-~--~~~---~--~~

Re: $$Excel-Macros$$ Identify unique dates for employee

2010-04-28 Thread gurumurthy sastry Kondury
Hi Chetan, May be you can Use If condition like below : =IF(F2>0,1,0) - If the entry is in cell F2. Cuz you put any value more than 1, it will give you only 1 as required. Hope this works. Best Regards, Haigreeva. On 4/28/10, Chetan wrote: > Can anyone help me on this issue > > On Apr 26, 5:

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

2010-05-07 Thread gurumurthy sastry Kondury
Hi, Just see the attached file and confirm If this is what you are looking for. Best Regards, Guru On Tue, May 4, 2010 at 8:57 PM, dza7 wrote: > Hello, > > I have a challenging pivot table issue that I hope I can get some help > on. > > Here is the spreadsheet I'm working with: > https://www.y

Re: $$Excel-Macros$$ VLookup on Data Table

2010-05-12 Thread gurumurthy sastry Kondury
Hi Uugandhi, Its better if you could pls attach the file provided its not confidential. Best Regards, Haigreev On 5/12/10, uu wrote: > What I would like is under column "D" to be able to select one store > number at a time from the data sort filter. What I would like to do > is > have a VLoo

$$Excel-Macros$$ Excel hours and minutes calculation *********URGENT **********

2010-06-17 Thread gurumurthy sastry Kondury
Hi dave, In the same way If I want to know the exact number of working hours between 19:45 PM yesterday and 16:50PM today ( Considering the user is working in second shift from 15:00 PM to 00:00 AM ). Thanks & Regards, On Thu, Jun 17, 2010 at 7:33 AM, who wrote: > Hi, > Below starts in Cell A1

Re: $$Excel-Macros$$ Help...Vlook up

2010-06-18 Thread gurumurthy sastry Kondury
Hi, Try using =CONCATENATE(C2&D2) in Column E and then the Vlookup in F. It should work. Best Regards, Guru. On Thu, Jun 17, 2010 at 2:54 PM, Regina Medhanie wrote: > Thanks you. I try your suggestion and give both cell the same format > but still I get # N/A. The cell I am refering contains

Re: $$Excel-Macros$$ activate sum display function

2010-06-18 Thread gurumurthy sastry Kondury
Hi, If you are speaking about Status bar that you cant find the sum, Then right click on Status Bar and select SUM; Hope ur issue is resolved Best Regards, Guru. On Thu, Jun 17, 2010 at 2:23 PM, anu naik wrote: > Hey Guys, > I need help in a matter > > > While using excel ,the sum is display

$$Excel-Macros$$ Split the column into four columns ** URGENT **

2010-12-20 Thread gurumurthy sastry Kondury
Hi, I have a complete column like the below which has a reference number, a text and two values for the text. I want to split this data into four different columns ( B C D E). Please help. 1.01 Vinculados a Compromissos de Recompra 726.223 300.412 Thanks & Regards Guru. --

Re: $$Excel-Macros$$ Description while using Macro Functions in Excel

2011-01-03 Thread gurumurthy sastry Kondury
Hi Rajesh, If your question is "to use the function in one Cell ( Say B1) and to show the description of the Function in the next cell ( say C1) ", then use your function in Cell B1, and put the same function in Cell C1 leaving one space. See Example below =IF(logical_test, value_if_true, value_