Re: $$Excel-Macros$$ hi

hi On Sun, Jun 26, 2016 at 10:37 AM, Grkrishna Naidu wrote: > add me in group > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > >

Re: $$Excel-Macros$$ hi all

Hi Sunil, PFA.!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Is there any opening in MIS executive profile?. Actually i also looking the job in same field. Regards, Kapil Gupta On Tuesday, August 2, 2011 7:13:55 AM UTC+5:30, krishna mummina wrote: Sam Are you asking me or to whom you are referring to call you? Here is my number : 09866902757 On

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi sir I am currently working as Junior Software engineer/MIS for the past 2.5 years. My role includes coding in Vb 6.0, SQL server 2005. I do also generate reports as per the requirement, so do have an average knowledge in Excel. But I have to set my future career in MIS dept. so I would

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

My Mail Id : surya.i...@gmail.com On Thursday, May 8, 2014 1:49:39 AM UTC+5:30, Surya Narayanan PV wrote: Hi sir I am currently working as Junior Software engineer/MIS for the past 2.5 years. My role includes coding in Vb 6.0, SQL server 2005. I do also generate reports as per the

Re: $$Excel-Macros$$ hi

HELLO SATENDER, WELCOME TO THIS GROUP AND SHARE YOUR QUERY On Fri, Feb 14, 2014 at 9:03 AM, Satender Rawat satenderraw...@gmail.comwrote: -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ hi all***need code to attacha file in outlook and send it to respective email id***

try the attachment .. see if it helps On Fri, Mar 29, 2013 at 10:37 PM, maksood alam 786maks...@gmail.com wrote: Hi all please send me the code to attach a file in outlook and send it to respective email address. Thanks Maksood alam -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ hi there

Hi Nik first of all please use proper subject line and which type database format you want i..e... Finance or customer record database type please specify . Enjoy Team XLS On Thu, Mar 7, 2013 at 10:26 PM, nm nms8...@gmail.com wrote: Sir, i m into real estate

Re: $$Excel-Macros$$ hi there

sir, pl accept my apology i m begineer in the group, and not familier with excel progarmming too. i need customer recoed database. Thanks NIK. On Thu, Mar 7, 2013 at 11:10 PM, xlstime xlst...@gmail.com wrote: Hi Nik first of all please use proper subject line and which type database

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

please share required field . Enjoy Team XLS On Wed, Mar 6, 2013 at 2:09 PM, kannan excel kannan.ex...@gmail.com wrote: hi friends i want courier management data format in excel regards kannan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

pls share the data On Wed, Mar 6, 2013 at 2:45 PM, xlstime xlst...@gmail.com wrote: please share required field . Enjoy Team XLS On Wed, Mar 6, 2013 at 2:09 PM, kannan excel kannan.ex...@gmail.comwrote: hi friends i want courier management data format in

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

Hi Kannan, PFA.. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Wed, Mar 6, 2013 at

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

Hi Gawli Anil, Please check all mails. It's Kannan (kannan.ex...@gmail.com) Query. I have no query. I am happy to help. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi Sir, Myself sundar from chennai, First i would appreciate on your brief explanation for MIS role, it is very clear to understand. i have been working as HR for past 3 Years, but my role as HR is not satisfying me. I was looking for a change where i don't interact with people much, and so i

Re: $$Excel-Macros$$ Hi

Dear Rajat, You have been added successfully in excel-macros group, Please check and confirm. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http://

Re: $$Excel-Macros$$ Hi

Mihael, Please post ur excel macro query On Thu, Jun 14, 2012 at 8:39 AM, Michael Brumby mikebru...@yahoo.comwrote: this is crazy you should check the out http://www.business15canews.net/work/?read=5074813 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

Yes, you can give comma separated email list. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deba Ranjan Sent: 31 May 2012 10:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

:* 30 May 2012 9:56 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm ** ** Sir, i dont have any tool for breaking password. If you have any set up you

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm Dear Rajan, The file that you have shared is quite awesome. Can you please share us the coding too as you have protect

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

May 2012 10:11 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm ** ** Dear Rajan, The file that you have shared is quite awesome. Can you please

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

Hi Rajan, this is excellent, can you help with the code that you have used. as my requirement is on the same line. On 17 May 2012 18:44, Rajan_Verma rajanverma1...@gmail.com wrote: Try My Excel Outlook J ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** **

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm Hi Rajan, this is excellent, can you help with the code that you have used. as my requirement is on the same line. On 17 May

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *t vinay *Sent:* 28 May 2012 7:47 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments

Re: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this question.

Google is your friend. excel version differences Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Divaker Pandey Sent: Monday, March 05, 2012 8:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this

Re: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this question.

yeah, that is true. Google is our universal friend. but it will be awesome if group members got list of real time problem, or difference expert faces during use of different versions of excel. Divaker On Mon, Mar 5, 2012 at 8:43 PM, dguillett1 dguille...@gmail.com wrote: Google is your

Re: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

if i am not wrong u can use CALL macro function On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer mmun...@ccc.com.qawrote: How to merge the Multiple Macro’s in single program? My question is little jovial – but still it is trying to learn some thing from u masters. Thanx

Re: $$Excel-Macros$$ Hi, Friends I have a ?

Hi Mohammed Muneer, you must be use proper subject line or Use concise, accurate thread titles. for get quick attention or answered. On Mon, Feb 20, 2012 at 12:22 PM, Mohammed Muneer mmun...@ccc.com.qawrote: How to merge the Multiple Macro’s in single program? ** ** ** ** **

RE: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now) if i am not wrong u can use CALL macro function On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer mmun...@ccc.com.qa

Re: $$Excel-Macros$$ Hi friends, now its clear.....

Just a thought. Are you trying to say that if there is a common word in all the lines, you need to know that word? Example I let you go Let me in Who let the dogs out To let and you need the value in your first column to be '*let*'? I'd say caramba! if that's the case And Excel_Lover, you

Re: $$Excel-Macros$$ hi can you solve this

Hi Renuka, Can you more explain your query.. Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Dec 8, 2011 at 6:56 PM, Renukachari Kasee

Re: $$Excel-Macros$$ hi can you solve this

Hi Renuka, Please find the attached file. I have used the below formula to solve. =SMALL(IF(D2:D11=G2,D2:D11),{7,6,5,4,3,2}) Regards, MARIES. On Thu, Dec 8, 2011 at 5:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Renuka, Can you more explain your query.. Thanks regards,

Re: $$Excel-Macros$$ Hi

http://chrisrae.com/vba/whatisvba.html http://www.excel-vba.com/ http://www.excel-vba-easy.com/ http://www.youtube.com/watch?v=t1vdt0FddsE On Fri, Aug 26, 2011 at 10:24 PM, Mohamed Youssouf youssouf.mohame...@gmail.com wrote: I'd like to learn how ti use MACRO --

Re: $$Excel-Macros$$ Hi

Hi, See below links.. http://www.excel-vba.com/ http://www.ozgrid.com/VBA/ http://excelvbatutor.com/ *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 26, 2011 at 8:54 PM, Mohamed Youssouf youssouf.mohame...@gmail.com wrote: I'd like to learn how ti use MACRO --

RE: $$Excel-Macros$$ Hi

You can Visit these sites : www.ozgrid.com www.cpearson.com http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/ www.akoul.blogspot.com www.excelpoweruser.com www.ozgrid.com akoul.posterous.com www.mrexcel.com www.contextures.com www.rondebruin.nl peltiertech.com chandoo.org

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

give me call at 12 tomorrow; or leave sms 028482 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Sam Are you asking me or to whom you are referring to call you? Here is my number : 09866902757 On Tue, Aug 2, 2011 at 5:25 AM, Sam K soura...@gmail.com wrote: give me call at 12 tomorrow; or leave sms 028482 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you very much for the links. Most of them are just a normal reports like using the basic formulas. Is this is all about MIS Executive role to create the reports like this? Waiting for your reply - krrish On Sat, Jul 30, 2011 at 12:06 AM, XLS S xlst...@gmail.com wrote: Please find the

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi Kirish, Just go to Linked in and search MIS Executive and see what are all responsibilities and then you may get clear Picture what they are doing... *Best Regards,* *Venkat* *Chennai* On Sat, Jul 30, 2011 at 11:41 AM, krishna mummina lovemekris...@gmail.comwrote: Thank you very much for

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

vijaykumar and venkat thank you very much for your valuable input. On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear Krishna, The profile of MIS Executive changes with the type organisation.If it is a small organisation MIS Executive role would be to prepare

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Please find the below links http://www.citesales.com/ http://www.ksde.org/Default.aspx?tabid=2836 On Fri, Jul 29, 2011 at 9:05 PM, krishna mummina lovemekris...@gmail.comwrote: Thank you very much for the total input guys. Now, I just want to see some of the example reports and some excel

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi Krish, MIS Executive Role also Same kind of role as you now doing...Reports generation Data Management activities *Best Regards,* *Venkat* *Chennai* On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you venkat, Report Generation and Data Management? If you have some examples, can you please provide those? Thanks in advance, Krrish On Tue, Jul 26, 2011 at 11:57 AM, Venkat CV venkat1@gmail.com wrote: Hi Krish, MIS Executive Role also Same kind of role as you now

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi, In case of MIS Executives the kind of the data sets is very rigid. The data is always in the same format. Mostly the amount of data would also be the same every day/week. The frequency of reports would be also same for them, i.e. the MIS is generated on a weekly, daily or 15 days or quarterly

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you very much sir, Really very detailed explanation. Once again Thank you very much. On Tue, Jul 26, 2011 at 4:28 PM, anandydr ananad...@gmail.com wrote: Hi, In case of MIS Executives the kind of the data sets is very rigid. The data is always in the same format. Mostly the amount of

Re: $$Excel-Macros$$ Hi Everybody

Hey, Please register and download any HR related MIS report http://www.citehr.com/ On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya mail2sanja...@gmail.comwrote: Hi All friends if u have these type others MIS Report file for Sales Department and Finance Department Please forward me. --

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hey Please find below link http://en.wikipedia.org/wiki/Management_information_system On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel,

Re: $$Excel-Macros$$ Hi Everybody

Nice portal and it is offering more solutions related to HR, not just MIS reports.. Thanks, DILIPandey On 7/27/11, XLS S xlst...@gmail.com wrote: Hey, Please register and download any HR related MIS report http://www.citehr.com/ On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya

Re: $$Excel-Macros$$ Hi Everybody

yes Dilip sir, its really very good sit for all type hr related document... On Wed, Jul 27, 2011 at 9:46 AM, Dilip Pandey dilipan...@gmail.com wrote: Nice portal and it is offering more solutions related to HR, not just MIS reports.. Thanks, DILIPandey On 7/27/11, XLS S

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

I some how feel he need to know a bit of database basics... - Clean and organize the database before working on it... - Ensure to know the compatible formula- other features based on version and its disadvantages Regards Venkatesh +91 9841969353 On Wed, Jul 27, 2011 at 9:41 AM, XLS S

RE: $$Excel-Macros$$ HI --help me

1) Duplicate Unique Key 2) Blank Cells 3) Wrong Data/time format 4) Wrong Data Type (Number to String) 5) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Sunday, July 24, 2011 5:51 PM To:

Re: $$Excel-Macros$$ HI --help me

use formula =IF(iserror(ur formula),,ur formula)) On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, I have one questions.Usually while doing reports what are errors you will get ? Thanks --

Re: $$Excel-Macros$$ HI --help me

Dear Vijay, Please find Error remover technique. * Errors-World* Error Type Error Remover Functions *ISNA()* *ISREF()* *ISERR()* *ISERROR()* *IFERROR()* #N/A YES YES NO YES YES #ISREF NO YES YES YES YES #NULL NO YES YES YES YES #DIV/0! NO YES

Re: $$Excel-Macros$$ HI --help me

Hi Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet in one click. Magic. Charlie On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Vijay, Please find Error remover technique. * Errors-World*

Re: $$Excel-Macros$$ HI --help me

Hello All, Thank You very much.. On Mon, Jul 25, 2011 at 12:20 PM, Cab Boose swch...@gmail.com wrote: Hi Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet in one click. Magic. Charlie On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI

Re: $$Excel-Macros$$ HI --help me

Hi Vijay, In Excel You May get errors are #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A if u want avoid this Tou may us IFERROR or IFERROR ISERROR Function *Best Regards,* *Venkat* On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, I have one

Re: $$Excel-Macros$$ HI --help me

http://www.ozgrid.com/Excel/formula-errors.htm http://chandoo.org/wp/2009/04/20/excel-formula-errors/ On Sun, Jul 24, 2011 at 6:12 PM, Venkat CV venkat1@gmail.com wrote: Hi Vijay, In Excel You May get errors are #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A if u want avoid

Re: $$Excel-Macros$$ HI --help me

Hi Vijayajith, It depends which report having what kind of formula / function / macros you are working on. I have came across following errors so far:- 1) Excel Function errors - Can be corrected using ISError function(s) 2) VBA Macros - Can be prevented using Error handlers 3) Linking errors -

Re: $$Excel-Macros$$ HI --help me

It depends upon the mistakes u do. On 7/24/11, vijayajith VA vijayajith...@gmail.com wrote: Hi, I have one questions.Usually while doing reports what are errors you will get ? Thanks -- -- Some important

Re: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

Thanks a lot On Fri, Jul 15, 2011 at 9:44 PM, STDEV(i) setiyowati.d...@gmail.com wrote: *1. **Worksheet.Change Event* * *Occurs when cells on the worksheet are changed by the user or by an external link. This event doesn't occur when cells change during a recalculation. Use the Calculate

RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

Hi, Private Sub Worksheet_Change(ByVal Target As Range) is fired when you enter a value into a cell Private Sub Worksheet_SelectionChange(ByVal Target As Range) is fired when you select another cell or if you change the current selection. In both cases, “Target” represents the

RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

juillet 2011 18:07 À : excel-macros@googlegroups.com Objet : RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example. Hi, Private Sub Worksheet_Change(ByVal Target As Range) is fired when you enter a value into a cell Private Sub Worksheet_SelectionChange(ByVal Target

Re: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

*1. **Worksheet.Change Event* * *Occurs when cells on the worksheet are changed by the user or by an external link. This event doesn't occur when cells change during a recalculation. Use the Calculate event to trap a sheet recalculation. This example changes the color of changed cells to blue.

Re: $$Excel-Macros$$ Hi - Number need to fill randomly

Pls find the attached... Regards, Manoj Kumar On Wed, Dec 8, 2010 at 12:34 PM, Manjunath C cmanjunathchen...@gmail.comwrote: Hi Team, I need to fill the highlighted(brown) coloumn with numbers 1 to 90 randomly by clicking the button Press each time. Finally we need the data as highlighted

Re: $$Excel-Macros$$ Hi Experts, Urgent

hi Pankaj, Can you please tell what formula you are looking for. Could you please express your query in brief. Thanks, Raj On Tue, Oct 5, 2010 at 8:23 PM, Pankaj Kumar rajputpanka...@gmail.comwrote: Hi, Experts Its urgent basis i need u r help, i have a Name list A-Z, I have

Re: $$Excel-Macros$$ Hi

Hi Pankaj, Please find attached excel for solution. Regards, Swapnil. On Thu, Sep 30, 2010 at 9:15 PM, Pankaj Kumar rajputpanka...@gmail.comwrote: Hi, exper it urgent i need u r help i attached my excel sheet -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com

Re: $$Excel-Macros$$ Hi

PFA Vaibhav J www.excel.blog.com Sent on my BlackBerry® from Vodafone -Original Message- From: Pankaj Kumar rajputpanka...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 30 Sep 2010 21:15:12 To: excel-macrosexcel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Hi

Hi Pankaj, In your attached example put the following formula in cell C2 and copy it down: =IF(NOT(ISERROR(VLOOKUP(B2,$A$2:$A$8,1,0))),Match,Mismatch) The above formula matches the entries in the Column B with the column A. Pl let me know if this works for you. Regards, Andy On Thu, Sep 30,

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

Please Check this 2010/9/22 Abhidha Dixit abhidha.di...@gmail.com Dear ALL Please help how can i transpose the data from notepad to excel with the similar colomn gap so that when we copy this again to notebook i shall get the data with the samilar spaces thanks --

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

Hello You can copy the text in to excel and to break excel in the format as it is in not pad you have to you text to columns in the review menu of menu bar.If you text is separated by comma or colon or space or other delimiters you can choose delimited option and choose the symbol that

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

Just open the notepad and find and replace all the spaces with comma and after that close the file and rename the file extension from .txt to .csv see the magic reverse process to get the thing in txt again ITS WILL WORK GREAT 2010/9/22 Abhidha Dixit abhidha.di...@gmail.com Dear ALL

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

If you need the more shortcut then I can develop a macro for that On Wed, Sep 22, 2010 at 4:45 PM, Sanjoy Nath sanjoy.nath...@gmail.comwrote: Just open the notepad and find and replace all the spaces with comma and after that close the file and rename the file extension from .txt to .csv

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

Hi Vijay I want the format as it is in the notepad eg if there is 2 spacebar distance between the columns , and we transfer that to excel it should take the same distance so that if we want to save this excel to notepad again ( after calculation) the same distance of space ber should be

Re: $$Excel-Macros$$ Hi

you have to send your posting from your email-client, not from the group web. On Thu, Sep 16, 2010 at 4:03 PM, dinoabeer umarab...@googlemail.com wrote: Can somebody help. I m a newbie here. how do I upload I file when I post something --

Re: $$Excel-Macros$$ Hi all

http://office.microsoft.com/en-us/excel-help/25-easy-pivottable-reports-HA001034633.aspx http://office.microsoft.com/en-us/excel-help/25-easy-pivottable-reports-HA001034633.aspx http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data

Re: $$Excel-Macros$$ hi

In addition to the above, also please check the following link: http://chandoo.org/excel-formulas/vlookup.html http://chandoo.org/excel-formulas/vlookup.htmlThnx Vinod N On Sat, Aug 28, 2010 at 8:04 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: Hi, Adding to

Re: $$Excel-Macros$$ hi

Press F1 Key and see the examples. On Fri, Aug 27, 2010 at 10:54 AM, Pankaj Kumar rajputpanka...@gmail.comwrote: Hi, Can anyone help me to understand what is Vlookup Hlookup,for a short example how to use it ,, -- *Warm Regards Pankaj kumar M: 9899816107 e-mail:

Re: $$Excel-Macros$$ hi

Dear Pankaj, Please find attachment with simple example of Vlookup Hlookup. - Vlookup always take right value. - Vlookup doesn't take duplicate value. Thanks, Noorain Ansari On Fri, Aug 27, 2010 at 10:54 AM, Pankaj Kumar rajputpanka...@gmail.comwrote: Hi, Can anyone help me to

Re: $$Excel-Macros$$ hi

Hi Pankaj, Vlookup means Vertical lookup that is find the given value in vartical order. vlookup is the way to find the particular data from master file. It gives the data in vertical manner from the right side of the column against which data has to find. Syntax

Re: $$Excel-Macros$$ Hi, need your help - urgent

Good! But instead of copy paste we can use bring to front by keeping all images on same position. On Thu, Jul 1, 2010 at 7:38 PM, ashish koul koul.ash...@gmail.com wrote: hi Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If ActiveCell.Row = 2 And

Re: $$Excel-Macros$$ Hi, need your help - urgent

Hi Rajender, I am not quite sure how would you want to do it. However there is a very simple solution mentioned in the link below, which almost does what you are trying to achieve. http://www.excelforum.com/excel-general/713781-display-an-image-based-on-a-cells-value.html

Re: $$Excel-Macros$$ Hi, need your help - urgent

hi i need help how i can secure a hidden sheet no any one can unhide and modify it. Regards Ni On Thu, Jul 1, 2010 at 7:38 AM, ashish koul koul.ash...@gmail.com wrote: hi Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If ActiveCell.Row = 2 And

Re: $$Excel-Macros$$ hi-help required .

: From: rf1234 rf1234 rfhyd1...@gmail.com Subject: Re: $$Excel-Macros$$ hi-help required . To: excel-macros@googlegroups.com Cc: sarve...@yahoo.com Date: Tuesday, 6 April, 2010, 10:52 AM Hello Dear, Attached workbook has a sample for your problem. Hope it Will Help Happy

Re: $$Excel-Macros$$ hi-help required .

Here is the solution attached you can do it with the help of sumproduct formula or with Sumif Formula Regards Hemant On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh sarve...@yahoo.com wrote: hi i have a worksheet where sizes and qty are maintained for each item in this way 460*12 Pet 31 460*12

Re: $$Excel-Macros$$ hi-help required .

rf1234 rfhyd1...@gmail.com Subject: Re: $$Excel-Macros$$ hi-help required . To: excel-macros@googlegroups.com Cc: sarve...@yahoo.com Date: Monday, 5 April, 2010, 5:03 PM Hello Dear, Following attachment have a solution regarding your problem.                           Hope it Will Help

Re: $$Excel-Macros$$ Hi Please Help ME

Hello Dear, I am unable to understand your problem.Please 1'st explain problem. In your attachment,you have not explain your problem. Please Reply So that we can understand your requirements. On Mon, Mar 22, 2010 at 3:27 PM, anil panchal anil.kan...@gmail.com wrote: Hi All A

Re: $$Excel-Macros$$ hi all

How to use that, its not working for me? what is the use of that sheet? On Fri, Mar 19, 2010 at 11:54 AM, ashish koul koul.ash...@gmail.com wrote: just find it on goole see if it useful to u -- -- Some

Re: $$Excel-Macros$$ hi all

what is it supposed to do? On Fri, Mar 19, 2010 at 9:49 AM, Puttaswamy puttu...@gmail.com wrote: How to use that, its not working for me? what is the use of that sheet? On Fri, Mar 19, 2010 at 11:54 AM, ashish koul koul.ash...@gmail.comwrote: just find it on goole see if it useful to u

Re: $$Excel-Macros$$ Hi Help in Excel

hi harish Ayush saying is true, unless u dont try by urself u will never learn...if you really want to learn ask any specific funtion or formula, we will be happy to make it clear to you for any query you can mail me On 26/01/2010, ayush jain jainayus...@gmail.com wrote: Dude, This forum

Re: $$Excel-Macros$$ Hi Help in Excel

Dude, This forum is to help genuine real life problems of excel and macros users. Your test appears to be quite simple and it was made to test your capability. You will not be able to learn if we will solve it. First try at your end and if you find any problems in specific question, just let us

Re: $$Excel-Macros$$ hi

Your being troubled by array functions. those curly brackets cannot be entered manually. On Fri, Nov 13, 2009 at 3:45 AM, Shraddha Shah shraddh...@sbm-india.comwrote: Hi, We are using the attached file to prepare certain reports for the bank. We need to actually bucket the all the

Re: $$Excel-Macros$$ hi

Hi Use this in X5 =SUMIF($T$5:$T$717,=X3,$M$5:$M$717) And this in Y5 =SUMIF($T$5:$T$717,=Y3,$M$5:$M$717) - SUMIF($T$5:$T$717,=X3,$M$5:$M$717) Then copy the Y5 formula and paste it in Z5 to AF5 Regards Sandeep - Original Message - From: Shraddha Shah To:

Re: $$Excel-Macros$$ hi need ur help

i want to find the value of adjacent row using vlookup my answer should come3 in this case but its not showing that On Thu, Nov 12, 2009 at 12:42 PM, Aindril De aind...@gmail.com wrote: Hi Ashish =IF(EXACT(F7,VLOOKUP(F7,A5:B7,1,1))=TRUE,VLOOKUP(F7,A5:B7,1,1), NO EXACT MATCH) Is the

Re: $$Excel-Macros$$ hi need ur help

Dear Ashish perhaps you need this. Chandra Gupta On Thu, Nov 12, 2009 at 2:18 PM, ashish koul koul.ash...@gmail.com wrote: i want to find the value of adjacent row using vlookup my answer should come3 in this case but its not showing that On Thu, Nov 12, 2009 at 12:42 PM, Aindril De

Re: $$Excel-Macros$$ hi need ur help

Sorry for the misunderstanding Ashish. Following is teh correct formula: =IF(EXACT(F7,VLOOKUP(F7,$A$5:$B$7,2,1))=TRUE,VLOOKUP(F7,$A$5:$B$7,2,1), NO EXACT MATCH) Regards, Andy On Thu, Nov 12, 2009 at 3:48 PM, ashish koul koul.ash...@gmail.com wrote: i want to find the value of adjacent row

Re: $$Excel-Macros$$ hi help please

Hi Ashish, You can simply use the exact match option of vlookup to do this. The following links from MS have the complete explaination: XL: How to Perform a Case-Sensitive Lookup http://support.microsoft.com/kb/214264 How to Use VLOOKUP or HLOOKUP to find an exact match