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

ogspot.com/ <http://noorain-ansari.blogspot.com/> http://noorain-ansari.blogspot.com/ On Tue, Nov 29, 2011 at 5:52 PM, smitha.kumari 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 in

$$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$$ Formula to sum a range of cells satisfying a particular criteria

: Tuesday, November 29, 2011 2:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria An easy solution would be Sumif Function. See attached. Regards, Manish On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari wrote

$$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 Pr

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

stop 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 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 Id. What shall

$$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$$ 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 Noora

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

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 smitha.kum...@speridian

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$$ 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@

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:

$$Excel-Macros$$ Indirect formula

Hi, Any one please explain why these quotes are used in this formula =SUMIF(INDIRECT("'"&B$5&"'!A:A"),$A6,INDIRECT("'"&B$5&"'!I:I")) Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

$$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 th

$$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 titl

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

groups.com [mailto:excel-macros@googlegroups.com] On Behalf Of smitha.kumari Sent: Thursday, November 10, 2011 10:01 PM To: excel-macros@googlegroups.com Subject: $$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

$$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, Formula

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

: $$Excel-Macros$$ Re: formula use vlookup On Thu, Nov 10, 2011 at 12:41 PM, smitha.kumari 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 Regards Smitha/ Senior Finance

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" 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 or > w

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 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 violati

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 smitha.kum...@speridian.com From: excel-macros@googlegroup

$$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 alread

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

t used row 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 wro

$$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 smitha.kum...@speridi