$$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

Hi, PFA the expense sheet and suggest a formula to solve the problem as mentioned in the attachment. Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

RE: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

:53 PM, smitha.kumari smitha.kum...@speridian.com wrote: Hi, PFA the expense sheet and suggest a formula to solve the problem as mentioned in the attachment. Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ convert row to column or vice versa

Hi, Is there a quick way to convert row to column or vice versa Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

RE: $$Excel-Macros$$ #value in formula

/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Tue, Nov 29, 2011 at 5:52 PM, smitha.kumari smitha.kum...@speridian.com wrote: Hi, Attached is the solved copy of a query by one member of this group. I tried to understand the formula. But when I place a cursor

RE: $$Excel-Macros$$ stop receiving mail in this mail id

receiving mail in this mail id Hi, Please visit here for more details.. www.discussexcel.com On Mon, Nov 28, 2011 at 10:04 AM, smitha.kumari smitha.kum...@speridian.com wrote: HI, I am changing my mail id after two weeks. If I want to stop the receipt of mails from excelgroops in this mail

$$Excel-Macros$$ stop receiving mail in this mail id

HI, I am changing my mail id after two weeks. If I want to stop the receipt of mails from excelgroops in this mail Id. What shall I do? Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526

RE: $$Excel-Macros$$ exls

Really Very much helpful, Mangesh Thank a lot.. Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of mangesh bavalekar Sent: Thursday, November 24, 2011 2:17 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ exls

RE: $$Excel-Macros$$ Excel learning Institute

Hi Noorain, Expecting the Training material at the earliest. Regards Smitha From: smitha.kumari [mailto:smitha.kum...@speridian.com] Sent: Thursday, November 24, 2011 1:32 PM To: 'NOORAIN ANSARI' Subject: RE: $$Excel-Macros$$ Excel learning Institute Thanks a lot Noorain. My

RE: $$Excel-Macros$$ Excel learning Institute

Hi, I am also in search of the same. I am from Trivandrum(Kerala) Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of krishnanm2...@gmail.com Sent: Thursday, November 24, 2011 12:23 PM To: excel-macros@googlegroups.com Subject: Re:

RE: $$Excel-Macros$$ Excel learning Institute

I am in Trivandrum. Me too in search of the same. Please suggest me one possible way? Is Noorain giving any online training? Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526

RE: $$Excel-Macros$$ Indirect formula

see attached sheet with example of below formula. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Tue, Nov 15, 2011 at 12:13 PM, smitha.kumari

RE: $$Excel-Macros$$ Help Required

Neeraj, In Excel 2007, there is only consolidate function. Consolidate by position and category is not available Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aindril De Sent: Tuesday, November 15, 2011 4:09 PM To:

$$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

I need help on: Want to get all the datas or selected datas in different work sheets in to one sheet in the same work book. Please suggest any formula. Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

Hi, I need help on: Want to get all the datas or selected datas in different work sheets in to one sheet in the same work book. Please suggest any formula. Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ convert data in time to number without any change

Hours of an employee worked is shown as 5:00:00 AM. I have to convert it into number 5. Please help. Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

$$Excel-Macros$$ Consolidate data in different work sheets

Hi, I want to know how we can consolidate data in different worksheets into one worksheet. Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 mailto:smitha.kum...@speridian.com

RE: $$Excel-Macros$$ Consolidate data in different work sheets

automatically k = ActiveSheet.UsedRange.Rows.Count Rows(j : k).Copy Sheets(Sheets.Count).Select Sheets(Sheets.Count).Range(a65356).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste Next i End Sub On Wed, Nov 9, 2011 at 10:08 AM, smitha.kumari smitha.kum...@speridian.com wrote: Hi, I want to know

$$Excel-Macros$$ remove a certain text from every sentence

Hi, I want to remove a certain text from every sentence Technology Company:David Technology Company:Arya Technology Company:Jose I need only the name, Technology Company: has to be removed from every cells. Please reply. Regards Smitha -- FORUM RULES (925+ members already

RE: $$Excel-Macros$$ remove a certain text from every sentence

The result should be david and not Technology company Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 mailto:smitha.kum...@speridian.com smitha.kum...@speridian.com From:

$$Excel-Macros$$ formula

If name in a cell is Simon in a work sheet 2 then the designation already allotted for Simon in worksheet 1 should appear there in worksheet 1 or wherever in the same work book. Please show me the formula for that Regards Smitha -- FORUM RULES (925+ members already BANNED for

RE: $$Excel-Macros$$ Consolidate data in different work sheets

Hi Haseeb, This will not consolidate the name , only the hours. Isn't it? Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 mailto:smitha.kum...@speridian.com smitha.kum...@speridian.com From:

RE: $$Excel-Macros$$ Re: formula

. Without that, it will be difficult to understand exactly what you require. Sam On Nov 10, 11:11 am, smitha.kumari smitha.kum...@speridian.com wrote: If name in a cell is Simon in a work sheet 2 then the designation already allotted for Simon in worksheet 1 should appear there in worksheet 1

RE: $$Excel-Macros$$ Re: formula

: $$Excel-Macros$$ Re: formula use vlookup On Thu, Nov 10, 2011 at 12:41 PM, smitha.kumari smitha.kum...@speridian.com wrote: PFA the sheet with name and designations. Required is, if I type the name in another worksheet, the designation column for the name should show as in the attachement