$$Excel-Macros$$ Urgent help required

Hi, Please find attached excel sheet named Errors Bifurcation. In this sheet there are many columns in which errors have been reported seperated by commas. I want that all the errors seperated by commas should appear in seperate rows with the data for Target ID and Tranaction ID. For example: In

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

*Congrats Rajan!* On Wed, Jan 4, 2012 at 10:37 AM, Asa Rossoff wrote: > Congratulations, Rajan! You bring a lot to the group -- you're very > generous with your time and expertise. > > ** ** > > Much respect. > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mai

Re: $$Excel-Macros$$ Could you please explain why are we using -- in this formula

Thank you very much my dear friends, for yours quick reply. Thanks N.Sundarvelan 9600160150 On Wed, Jan 4, 2012 at 12:12 PM, NOORAIN ANSARI wrote: > Dear Sundarvelan, > > The -- is used as an unary operator to convert a boolean value ie, > TRUE/FALSE in to 1/0. > > So to negate this, we use un

Re: $$Excel-Macros$$ Could you please explain why are we using -- in this formula

Dear Sundarvelan, The -- is used as an unary operator to convert a boolean value ie, TRUE/FALSE in to 1/0. So to negate this, we use unary operator -- with TRUE or FALSE to give 1 or 0 We can also use ++ ,0+1,*1 In fact you can also use a multiplier or a divisor of 1 -- Thanks & regards, Noor

RE: $$Excel-Macros$$ Happy Birth Day

Happy birthday, Noorain! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Monday, January 02, 2012 6:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Happy Birth Day Hello Group, Today we have birthday of One of

RE: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congratulations, Rajan! You bring a lot to the group -- you're very generous with your time and expertise. Much respect. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Tuesday, January 03, 2012 10:21 AM To: excel-macros Sub

$$Excel-Macros$$ Prices from NSE website

Hi, Is there any way to extract current / closing price of a particular share from NSE website in an excel sheet? Thanks, Sharad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

$$Excel-Macros$$ Re: Could you please explain why are we using -- in this formula

Hi Have a look at this: http://www.mcgimpsey.com/excel/formulae/doubleneg.html Kris -- FORUM RULES (986+ 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 will

$$Excel-Macros$$ Could you please explain why are we using -- in this formula

Hi Friends, Could you please explain why are we using -- in this formula. =IF(ISNA(OFFSET($A$1,MATCH(0,MMULT(-- TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),ROW(INDIRECT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1)),"",OFFSET($A$1,MATCH(0,MMULT( -- TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),RO

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

आपकी अभूतपूर्व सफलता में,ना हो कभी बिभाजन जी. Excel-Macro World का आप बने रहे महाजन जी. दुआ है मेरी आप यूँही छाये आसमान पर , Congratulations मेरे ओर से प्यारे-दुलारे राजन जी. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Keep EXCELling !! -- FORUM RULES (986+ 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 will not get quick attention or may not be answered. 2) Don't post a

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congt, Ranjan Verma. Keep the good work going. Wish you happy and pros new year Sanjib On Tue, Jan 3, 2012 at 11:50 PM, Ayush Jain wrote: > Hello Everyone, > > Wish you a very happy new year !! > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > December'2011 > He h

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Guys, been back from the UK after giving some excel training at the client headquarters. And then had to rush to Kerala to spend a few days vacation with family. A very prosperous, healthy and wealthy year to all of you. And again, wish you great Excel days. Will be back in Delhi next week. Hey Ra

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congratulations Rajan..!! Keep up the good work. Have a wonderful year ahead. Regards, DILIPandey On 1/3/12, Ayush Jain wrote: > Hello Everyone, > > Wish you a very happy new year !! > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > December'2011 > He has posted 105

$$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Hello Everyone, Wish you a very happy new year !! Rajan Verma has been selected as 'Most Helpful Member' for the month of December'2011 He has posted 105 posts in December2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived thi

Re: $$Excel-Macros$$ Book to learn Access 2007

thanks a lot.. On Tue, Jan 3, 2012 at 8:09 PM, Rajan_Verma wrote: > Download this book: > > http://www.4shared.com/office/kSyv-Z27/MS_Access_2007_Data_Analysis.html** > ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Subhash Yadav > *Se

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

hi is there any update...? -- 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 will not get quick attention or may not be answered. 2) Don't p

Re: $$Excel-Macros$$ Re: Text manipulation

I like it better than mine but cleaned it up a bit Sub Zeunasc1() 'cleaned up a bit Dim r As Long For r = 1 To Cells(Rows.Count, 1).End(xlUp).Row If Range("A" & r).Value Like "obj*" Then objgrp = Cells(r, "a").Value Else netobj = Cells(r, "a").Value Cells(r, "c").Value = objgrp & netobj End

Re: $$Excel-Macros$$ Text manipulation

One way Option Explicit Sub lineupobjecttextSAS() Dim lr As Long Dim i As Long Dim cl As Long Application.ScreenUpdating = False lr = Cells(Rows.Count, 1).End(xlUp).Row With Cells(2, 2).Resize(lr) .Clear For i = 2 To lr If Left(Cells(i, 1), 7) = "object-" Then Cells(i, 2) = Cells(i, 1) & Cells(

Re: $$Excel-Macros$$ How to export data from Excel to Access 2003

Another one. http://www.excelfox.com/forum/f13/export-data-excel-access-table-ado-using-vba-182/ Kris -- 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

Re: $$Excel-Macros$$ Happy Birth Day

Once again, NOORAIN, happy birthday~~ 2012/1/3 NOORAIN ANSARI > Thank you very much to all of you. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.blogspot.com/*

RE: $$Excel-Macros$$ Book to learn Access 2007

Download this book: http://www.4shared.com/office/kSyv-Z27/MS_Access_2007_Data_Analysis.html From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Subhash Yadav Sent: Jan/Tue/2012 07:48 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Book to learn Acc

Re: $$Excel-Macros$$ Happy Birth Day

Thank you very much to all of you. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Jan 2, 2012 at 8:22 PM, Rajan_Verma wrote: > Hello Group,

$$Excel-Macros$$ Book to learn Access 2007

Can any body provide book to learn MS Access 2007? Thanks, Subhash -- 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 will not get quick att

Re: $$Excel-Macros$$ User login and logout time

This may SEEM like a simple request, but it is WAY too involved to complete simply. There a MANY, MANY questions that need to be answered in order to BEGIN. First of all, Network Administrators can easily create reports of this type of activity. The Windows Authentication process logs each netwo

$$Excel-Macros$$ Re: Text manipulation

Actually came up with a very simple vb macro: endrange = Range("A65000").End(xlUp).Row For r = 1 To endrange If Range("A" & r).Value Like "obj*" Then objgrp = Cells.Range("A" & r).Value Else netobj = Cells.Range("A" & r).Value Range("H" & r).Value = objgrp & netobj End If Next >From t

$$Excel-Macros$$ User login and logout time

Hi Rajan, Please see the attached excel mail and i want the mentioned user names login time and logout time based on their employee ID's. Please do the needful, if you have any concern please leave me a msg. Regards Lokesh.M -- FORUM RULES (934+ members already BANNED for violation)

$$Excel-Macros$$ Staff planning template

Hi All, Need your help to develop a staff planning template (pls refer file attached) I have 3 Team Leads who submit data about proposed assignment and clients, its status, person involved, etc as per the input format sheet. >From the data received from 3 individual TL, every week I need to cons

RE: $$Excel-Macros$$ How to export data from Excel to Access 2003

Hi, Please visit the link of Mr.Excel http://www.mrexcel.com/forum/showthread.php?t=344088 Regards Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of maulik desai Sent: Jan/Mon/2012 08:45 To: excel-macros@googlegroups.com Subject: $$Excel-Ma

$$Excel-Macros$$ Job

The sender of this email is registered with Naukri.com as Software Data India Ltd. Experience required for the Job: 3 - 4.5 years Annual Salary of the Job: 3.0 - 4.0 Lacs Job Location: Gurgaon Dear Candidate, > > We have excellent job opportunity for you to work as a Risk Analyst. Kindly find th