Search results

D2 contains the numbers.

Hello , I have an excel sheet in which i have created a tracker where i need to calculate the 4hrs on monthly basis. (Eg:in Jan its 4 hrs ,Feb-8hrs like it should automatically addup 4hrs for every month in D2 Cell). If any formula is there can someone helpme with the formula. Name...

Hello .. I have the data in Sheet1 and i want the Consolidation data for each person's in Sheet2. (like What is the Total counts for Ramesh,Rohan etc...) So in Sheet2 - Column2 what will be the best formula to use.. Names Products Total Counts Ramesh Pen 5 Rahan Cartsheets 3...

I have a 4 different Department in my office, and each department has 10 employees under them .So I want to use a formula that shows me the Total number of hours completed in Each department(consolidate of all 10 employees)for all 4 different department. So I want to use the formula in C2...

Thanks Prazad... Now Its working fine... Thanks For ur help...:)

Thanks Vijay... But In C2 the Attended and Pending is not showing(Its showing the Blank Cell). can you pls help me in this too..

Hi.. I have the Trainig Sheet, in which i want use the " If Condition". Name of the Staff Session Name Status Notes Raj Rakesh Subodh In D2 cell there should be formula with the option that if i select- "Attended" in cell C2 then In Notes section it should automaticall show...

Hi Kevin... No, On Quaterly basis the trainigs hours should be 8hrs....or else can i make it like this or can u have any other option.Bit the @ year end it should complete 32hrs or can be more also. Name of Employee Jan Feb March Total Shekhar 8hrs Rakesh...

Hi i have created 1 Excel sheet for my team where in there are 10 different sheets(Sheet1,Sheet2,Sheet3.... Sheet10). There is 1 Sheet which has consolidate for all 10 of them in 1 sheet (i.e Consolidated). So i need to us a formula in which it should show : Training Requirement =32 hours a...

Hi Hui....I didnt know that ... Thanks for the Info. and ur needful...:) I ll check on it...

Hi... I have an excel sheet where in i have the data : A1 B1 C1 A2 B2 C2 A3 B3 C3 . . . A50 B50 C50 my question is can we have any option to create Send email option in the same sheet, where in we click on that(Send Email) option it should automaticall go to mail. because each...

Hi Deb.. Thanks for ur help... It has helped a lot in learning...:)

I have excel files (~50 files) with the same format. Is there any way to combine all them into one excel file? They are all in one folder.

Thanks to everyone for your kind response. Now i can see that its very easy ;). Thanks .... Thanks to all ....... Have a Gud Day..:)

no Hui.... i am not getting it .... Do i need to type that formula in Cell - B1 ..? Can u pls help me by step by step......

Hi, can u pls help me with the formula or steps for creating rolling month in Excel 2007. e.g. starting month dynamic so that rest of the months in the plan can automatically rolled. like if i change any of the month in cell(A1) the next month in (B1)should automatically change..