$$Excel-Macros$$ Help Vlookup function duplicate

Hi friends, pfa please help me only  vlookup function use find duplicate value.  Regards,Anil Kumar Maurya -- 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

$$Excel-Macros$$ hlep me

how to use function show all location by country name pfa Regards, Anil Kumar Maurya -- 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

Re: $$Excel-Macros$$ How to Get Data of 527 employees from One Excel Sheet to another Sheet on given proforma

Hi pfa Regards, Anil Kumar Maurya On Tuesday, 4 November 2014 4:50 PM, M.Rafique MRU wrote: Dear Excel Experts! Hi, Once again I need your help regarding subject matter, mentioned above. I need Data of 527 employees data on other sheet to another proforma

Re: $$Excel-Macros$$ Re: split text by pipe sign

$A18))-FIND("~",SUBSTITUTE($A18,"|","~",COLUMN()-2))),"")) Regards, Anil Kumar Maurya On Wednesday, 15 October 2014 4:11 PM, sanjaiy yadav wrote:

$$Excel-Macros$$ MIS Executive

Hi All i am search job for Sr. MIS Executive any jop please sent me. anilmaurya...@gmail.com Thanks & Regards Anil Kumar Maurya Mob. 8882545343 -- 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 f

Re: $$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

Hi Dear Please find attachment file. On Thursday, 20 March 2014 6:12 PM, Vabs wrote: Hi What exactly you are looking for in VBA. Thx On Thu, Mar 20, 2014 at 2:04 PM, Divaker Pandey wrote: Hi Expert, > >can any one please share code to retrieve already applied conditional >formattin

$$Excel-Macros$$ excel deta formate change vertical to horizontal?

Hi plz help me I have a set of data (about 3000 records) that are in the following format: Name: name1 Address: address1 City: city1 Name: name2 Address: address2 City: city2 I want the records to look like the following: Name Address City Name1 Address1 City1 Name2 Address2 City2 ===

Re: $$Excel-Macros$$ Total of values

Hi Pfa Anil Kumar Maurya From: Smitha S R To: excel-macros@googlegroups.com Sent: Thursday, 18 July 2013 12:57 PM Subject: $$Excel-Macros$$ Total of values Hi Team, PFA the work book, I have to get the total values in all the column in another sheet

Re: $$Excel-Macros$$ Help Required

Hi pfa Anil Kumar From: Neeraj Chauhan To: excel-macros@googlegroups.com Sent: Wednesday, 17 July 2013 3:41 PM Subject: $$Excel-Macros$$ Help Required Dear experts,   How to subtract time in hours and minute   10:30 AM -  10:30 PM

Re: $$Excel-Macros$$ Stock Query

Hi pfa From: SAJID MEMON To: Sundarvelan Natarajan Sent: Saturday, 13 July 2013 6:24 PM Subject: $$Excel-Macros$$ Stock Query Dear Experts, Plz give me some suggestion in challenging query of my part of project. Awaiting your positive response Regard

Re: $$Excel-Macros$$ need formula please

Hi pfa From: raghunandan rallapalli To: excel-macros@googlegroups.com Sent: Tuesday, 11 December 2012 5:59 PM Subject: $$Excel-Macros$$ need formula please sir, I need a formula for total sum of each account no wise as given in excel sheet.  Thanks in ad

Re: $$Excel-Macros$$ I want to merge two text cell

Hi pfa From: Dhaval Shah To: excel-macros@googlegroups.com Sent: Wednesday, 6 March 2013 5:21 PM Subject: $$Excel-Macros$$ I want to merge two text cell dear friends i want to merge two text cell in one pls refer the sheet thanks dhaval -- Are y

Re: $$Excel-Macros$$ Simple formula required

From: amar takale To: excel-macros@googlegroups.com Sent: Tuesday, 4 September 2012 2:01 PM Subject: $$Excel-Macros$$ Simple formula required -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel   FORUM RULES (1120+ memb

$$Excel-Macros$$ plz count extra space

Hi Please Help me attachment file. -- 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, like

Re: $$Excel-Macros$$ required Result on Conditions

From: Rakesh Kumar Sharma To: MS EXCEL AND VBA MACROS Sent: Thursday, 4 July 2013 11:42 AM Subject: $$Excel-Macros$$ required Result on Conditions Dear Experts, I want Result on  conditions. Pls find the attachment. -- Regards, Rakesh Kumar Sharma

Re: $$Excel-Macros$$ Formula require

From: Prabhakar S H To: excel-macros@googlegroups.com Sent: Tuesday, 4 June 2013 4:49 PM Subject: $$Excel-Macros$$ Formula require Hi Team,   i want to get formula to find Total value of cars with black color only. pls help.   Rgds, Prabhakar -- Are you

Re: $$Excel-Macros$$ Error in Excel Report

From: Manoj Kumar To: excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 4:47 PM Subject: $$Excel-Macros$$ Error in Excel Report Dear Expert, Please help to sove my Quiry file attached in mail. i need fill all data with "p" how many count in he

Re: $$Excel-Macros$$ required Result on Conditions

From: Rakesh Kumar Sharma To: MS EXCEL AND VBA MACROS Sent: Thursday, 4 July 2013 11:42 AM Subject: $$Excel-Macros$$ required Result on Conditions Dear Experts, I want Result on  conditions. Pls find the attachment. -- Regards, Rakesh Kumar Sharma

Re: $$Excel-Macros$$ Error in Excel Report

From: Manoj Kumar To: excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 4:49 PM Subject: Re: $$Excel-Macros$$ Error in Excel Report On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar wrote: > >Dear Expert, > > >Please help to sove my Quiry file

Re: Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates

file is not open From: Chandra Gupta Maurya To: excel-macros@googlegroups.com Sent: Thursday, 4 July 2013 2:33 PM Subject: Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wann

Re: $$Excel-Macros$$ Value paste the real time data

Hello friend, you have a circular Reference in D6 check it. than try. anil -- -- 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 g

Re: $$Excel-Macros$$ Extract Comma separated Data

Hello friends, after reples all commond plz explen. Thanks Anil -- 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 atten

Re: $$Excel-Macros$$ VLOOKUP FROM A RANGE OF SHEETS

Dear vivek, can u send sample sheet Regards Anil -- 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 n

Re: $$Excel-Macros$$ can we round figer any amount.

thanks both of u it's work fine Regards Anil -- 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

$$Excel-Macros$$ can we round figer any amount.

Hello everybody, I have a queary. can we round figer any amount. exp. Amount Round figer 975567.65 10.00 732530.60 8.00 595328.81 457717.00 405543.09 323739.86 317619.89 317311.64 290630.55 270986.07 Regards A

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

Hello anil, I will try your formula but i could not get same result. how it work plz discraibe. Regards same here -- 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

Re: $$Excel-Macros$$ queary

sorry sir, lack of time i could not explen. I gat data in 901+k 903+a 901+p 905+i 902+l I have to change 901+k=a, 901+a=b, k=a a=b p=c i=d l=e -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Nee

$$Excel-Macros$$ queary

Hello friends, I have a queary plz find attahcment. Thanks & Regards Anil -- 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 q

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

Hello sir, How r u, there is no need of sample sheet, simply u have 4-5 workbook of any data. and now u have to copy all data from 4-5 workbook. than we have to open 1 by 1 workbook and copy in 1 sheet. now i want to know that can i open 1 sheet from that 4-5 workbook copy all data in 1 sheet.

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

I exprot data from busy in 5 workbook. and now i open 1 workbook wnat to copy other 4 workbook data in open workbook -- 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

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

Hello sir, First of all thanks, secondly I don't know vba so can't use it. is excel have any formula. plz tell me. Thanks & Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Hel

$$Excel-Macros$$ Hi friends, I want to know

Hello friends, I have 5 workbook in excel and i want to copy in 1 sheet without open any excel or 1 workbook. is that possible. Thanks & Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urge

Re: $$Excel-Macros$$ subscribe to msaccess google groups....

cannot reach those people for help. Rgds, Anu. On 4/27/12, Anil Kumar wrote: > Dear Friends, > > Can anyone give me the link to Subscribe Msaccess group. > > Anyone's help is most welcome! > > > Rgds, > Anu. > > -- > FORUM RULES (986+ me

$$Excel-Macros$$ subscribe to msaccess google groups....

Dear Friends, Can anyone give me the link to Subscribe Msaccess group. Anyone's help is most welcome! Rgds, Anu. -- FORUM RULES (986+ 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$$ NEED SOME ATT.

Thanks rajan and viper I will try Anil > -- 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 ans

Re: $$Excel-Macros$$ NEED SOME ATT.

On Sat, Apr 7, 2012 at 10:50 AM, anil kumar wrote: > Hi Friends, > > can anybody solve this problem. sample file attached. > > > > Thanks & Regards > > Anil > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, ac

$$Excel-Macros$$ NEED SOME ATT.

Hi Friends, can anybody solve this problem. sample file attached. Thanks & Regards Anil -- 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

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Dear Noorain, thanks for u r help always. Rgrds, Anu. On 3/15/12, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has been consiste

$$Excel-Macros$$ Basics of excel & vba -plz send

Hi Dear members, I am new to this group. thnx in adv. -- 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 ma

$$Excel-Macros$$

-- 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 question in the thre

Re: $$Excel-Macros$$ reqment of greater than formula

Thanks sir, I will follow this formula than i give u msg Thanks again Anil -- 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

Re: $$Excel-Macros$$ reqment of greater than formula

sorry sir, but i want to know what is use of 1 in large formula. and my second queary can solve anil -- 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

Re: $$Excel-Macros$$ reqment of greater than formula

Hello sir, Thanks for response, I attach file. anil -- 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

$$Excel-Macros$$ reqment of greater than formula

Hello friends, I want to a formula of gareter than. any body tell me. Anil -- 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

$$Excel-Macros$$ queary about translate

Hi Friends, I have a excel file which have data in hindi, I have to translate in english, there is any softwear or way to solve my problem plz tell me. Thanks & Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ query about translate

Hello group, there is other way to translate. Anil -- 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

Re: $$Excel-Macros$$ query about translate

I want to translate all name and add. in english anil -- 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

Re: $$Excel-Macros$$ query about translate

Yes sir, this same file, How can i do plz tell me. I have to translate that data in english Anil -- 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

$$Excel-Macros$$ query about translate

hello group, How r all of u, I have a excel file in hindi has some name and add etc. I have to translate them in english, can we do that plz tell me. file attahced Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, lik

Re: $$Excel-Macros$$ hindi version of excel

Hello sir, I have already load hindi font, when i go filter than data change in diffrent lenguge. anil -- 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,

$$Excel-Macros$$ hindi version of excel

Hello friends, any body tell me were i can gat hindi version of excel. plz tell me link anil -- 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 Ad

Re: $$Excel-Macros$$ queary about filter

Hello sir, fist of all thanks, were can i gat hindi verson of excel. anil -- 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

$$Excel-Macros$$ queary about filter

Hello group members, I have a excel file which have data in hindi, I have to short by add. can I use filter or any other way plz tell me. Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Nee

Re: $$Excel-Macros$$ convert jpj in excel

sorry sir, I explain, I have some name and add. in hard copy and I have to print out lebal for post some doc. so i want to that scan that hard copy and convert in to excel file and forment that file according to lebal. so i will not have to type that data in excel. I thing now u understand. Thank

Re: $$Excel-Macros$$ convert jpj in excel

HI LAKSHMAN, u r right I want to convert some jpg file into excel and modify according myself. Thanks -- 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, an

Re: $$Excel-Macros$$ convert jpj in excel

hello sir, I have tryed many time but gat same result. like that file i m atteched below. -- 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 w

Re: $$Excel-Macros$$ convert jpj in excel

Hello sir, Thanks for u r respons. I have tryed but same result. -- 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 attent

$$Excel-Macros$$ anil kumar wants to chat

--- anil kumar wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-ed00186c8a-bc205b15b0-HJTs17g9CL5Q2gFJLre8IdRWfjo Y

$$Excel-Macros$$ jpj file convert in excel file

Hi friends, I need some help, I m trying a sacen file convert in excel file by ocr but I m not able to convert proper, so help me. Regards Anil -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne

Re: $$Excel-Macros$$ I have a queary

Hi vijay, there is no need to attc. file. because as you know that I have 10 branches in other stations and i have to check e-mail, of their details, if i not found their mail than i have to call them. so i want to that i open my file and press a key and all 10 reports marge in my file as sheet an

$$Excel-Macros$$ I have a queary

Hi experts, I have a queary I have 10 branches in differents citys. and I gate report daily in excel about their daily work. so I want to know that is it possible that every staff make their reports and in one time i will gate all reports in one file. If it is possible plz help me. Thanks Anil

$$Excel-Macros$$ anil kumar wants to chat

--- anil kumar wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-ed00186c8a-2c9d1a2514-jUDbAQxFqhloVHQgXkh0spN44cU Y

$$Excel-Macros$$ anil kumar wants to chat

--- anil kumar wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-ed00186c8a-9a18705217-KDNPrlJxRbc1K4HvUzHAJzozFCI Y

Re: $$Excel-Macros$$ Job- Required Excel Expert

Hi Mukesh, Plz send any mail ID -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/g

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hi karan and ashis, Thanks for your soon reply. Anil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ h

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hi Karan, first of all thanks. you have solved my problem. but how i can -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our L

Re: $$Excel-Macros$$ can we change hard copy in excel

Hi sam, fist of all thanks for response. I have some data in trems of hard copy like add. mob. no. etc. and i have to type in excel. so i think that frist i scan that hard copy and than change in excel file by any sofware. I hope you will understand now. Anil -- -

$$Excel-Macros$$ can we change hard copy in excel

Hi frineds, can we change a hard copy of data in excel by scanner. Regards & Thanks Anil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

$$Excel-Macros$$ can I unprotect a sheet

Hello everybody, I have a excel file in which i use protect op. but I have forgot password. becoz i use this file some time not daily. If we can unprotect sheet than tell soon. Anil -- -- Some important links for e

Re: $$Excel-Macros$$ find doubling

Hi suman, I have a address software in which data enterd by other opprters and I think some data is double so i want to export data from there in excel short out double data than i will remove that data from software. so i wanted to printout that double address. Anil --

Re: $$Excel-Macros$$ Fwd: date format help

Hello Dear, I think It's work use this key Shift+Ctrl+3. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

Re: $$Excel-Macros$$ find doubling

Hello suman, thanks for reply, it works and fulfill my needs. but not that way I want. If you have better Idia plz send me. Thanks & Regards Anil >> > -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ find doubling

Dear dguillett and noorani, I don't want to remove double I want show that and copy in other sheet. for removing I use Alt +AM > Thanks & Regards > Anil -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ find doubling

Hello sir, frist of all thanks for reply. I used your formula but it is not work according to my data. I have attched that file. plz see that. Thanks & Regards Anil -- -- Some important links for excel users:

$$Excel-Macros$$ find doubling

Hi everybody, I have a file in which some data is double i want to find that data. I used short key Alt + AM but it is remove double data insted of show data i want to copy that data. Thanks & Regards Anil --

Re: $$Excel-Macros$$ urgent

Dear rajan, I verey thankfull to you. It work Thakns Anil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Linked

$$Excel-Macros$$ urgent

Dear all, I am attach. a file in this file some add. and i want to change all add. in single column. I have given exp. in this sheet. Thanks & Regards Anil -- -- Some important links for excel users: 1. Follow

$$Excel-Macros$$ how to change msword file into excel

Hi friends, I want to know that how to change msword file into excel plz reply verey urgent. Thanks & Regards Anil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

$$Excel-Macros$$ How can i fix my heading

Dear friends, I want to know that How can i fix first row & colam whenever we go down but heading in first row should be not moved. Thanks Anil -- -- Some important links for excel users: 1. Follow us on T

Re: $$Excel-Macros$$ Re: The Most Accurate PDF-to-Excel Converter

2011/8/20 Venkat CV > You are welcome > > *Best Regards,* > *Venkat * > *Chennai* > * > * > On Sat, Aug 20, 2011 at 3:52 PM, bé trần văn wrote: > >> Thank venkat1@gmail.com has provided me the software conversion from >> PDF to Excel, very useful information. >> >> Thank you very much. >> > >

$$Excel-Macros$$ how to change a pdf file in to excel

plz anybody tell me that how to change a pdf file in to excel for modifiy. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Converting .xlsm to .xls

Hi Harpreet, For this you can use the converter that will convert your 2007 version excel file into 2003 version. Thanks & Regards, Anil Kumar. On Sat, Feb 6, 2010 at 8:01 AM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Group, > > I work on Office 200

$$Excel-Macros$$ how to use the reverse vlookup in excel sheet

condition is that this should be use through the reverse vlookup. any body is there for my help. Thanks & Regards Anil Kumar. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and l

$$Excel-Macros$$ Re: Migrating Add-ins to Office 2007

Hello JM The custom addins can be added in Excel 2007 through the Office Button. \ Click on . Anil Kumar Agarwala Anil Agarwala & Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty Fancy Bazar Guwahati : 781001 Assam +91 361 2638864 (Telefax) +91 361 2517820 (Office)

$$Excel-Macros$$ Re: Sales tax discount calculation

Hi Michael You may use =MIN(500, IF(A11<=6000,IF(A11<0,#VALUE!,ROUND(A11*0.012,2)),72+ROUND((A11-6000) *0.009+18,2))) This will give you the minimum of either values. Anil Kumar Agarwala Anil Agarwala & Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty F

$$Excel-Macros$$ Re: Migrating Add-ins to Office 2007

Hello JM The custom addins can be added in Excel 2007 through the Office Button. \ Click on . Anil Kumar Agarwala Anil Agarwala & Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty Fancy Bazar Guwahati : 781001 Assam +91 361 2638864 (Telefax) +91 361 2517820 (Office)

$$Excel-Macros$$ Re: Hii

Hi Ruchi, Why don't you try with 1 in the vlookup instead of 0 thus =VLOOKUP(B2,F3:G99,2,1) I believe you will get the desired result. CA_logo_icai Small1 Anil Kumar Agarwala Anil Agarwala & Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty Fa

$$Excel-Macros$$ Re: Seeking help from Excel Macro experts : (Force to enable Macros, Disable design mode, make the project unviewable)

Dear Hemant, You can protect your VB project with a good password and that would be the best solution to your predicament! No one can then view your code, leave alone modify them. Sorry that I am unable to comment on the registry thing. Anil Kumar Agarwala Anil Agarwala & Co. Chart

$$Excel-Macros$$ Re: Help with Combo Box and Display

Maybe u need a combination of Data Validation and VLookup Function. Please attach a sheet with data so that solutions can be provided. CA_logo_icai Small1 Anil Kumar Agarwala Anil Agarwala & Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty Fancy Bazar Guwa

$$Excel-Macros$$ How to use timer in Excel VBA

use the same in EXCEL VBA if any one know that please send me the the procedure and the code. i m using application.ontime for the same but was not able to do my task. -- Thanks & Regards Anil K

$$Excel-Macros$$ Re: Conversion of value in words from figures

Dear Shiv Pratap There is no built in function in excel to do it. You have to use custom made function for the same which are quite difficult to come by (even ASAP utilities does not provide for one!). CA_logo_icai Small1 Anil Kumar Agarwala Anil Agarwala & Co. Chartered Accountants

$$Excel-Macros$$ Want to learn Array function in Excel

excel can any one give me the web link for the same where i can learn and understand the array function. -- Thanks & Regards Anil Kumar --~--~-~--~~~---~--~~ - Some impor

$$Excel-Macros$$ Searching a Value in Excel Sheet

will give you the value as per your search. *NOTE :* Suppose there is no vlookup and hlookup fuction in Excel then what function i will use to solve my problem (Searching a data in excel file). -- Thanks & Regards Anil Kumar 921390

$$Excel-Macros$$ Re: Leading zeros

;15" is to be displayed as "15", you could custom format the cell/cells using the format cell dialogue box and typing 00 using custom format. Anil Kumar Agarwala Guwahati : 781001 Assam akagarw...@gmail.com -Original Message- From: excel-macros@googlegro

$$Excel-Macros$$ Re: Concatenating Problem

Dear, Use the following formatting options with either concatenate or "&" =concatenate(TEXT(A1,"DD/MM/ h:mm:ss AM/PM"), " ",B1) Or =TEXT(A1,"DD/MM/ h:mm:ss AM/PM")& " "&B1 CA_logo_icai Small1 Anil Kumar A

$$Excel-Macros$$ Re: F4 Repeat No Longer Available in Excel 2007

F4 is working just as fine in Excel 2007 as it was in earlier versions. Kindly recheck. If you changed your laptop/PC see if the function key works with Fn key pressed. Anil Kumar Agarwala Anil Agarwala & Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty Fancy B

$$Excel-Macros$$ Data should not be Duplicate - Using validation in Excel

input data of *Column A *then there should pop up a message for duplicate entry, can we do this through the Validation i don't want to use any macro for this. please do help on this. -- Thanks & Regards Anil Kumar 9

$$Excel-Macros$$ Re: amt in words in excel add-in

hi all, please send this below mention file on my mail id. anil.4u.ku...@gmail.com Thanks & Regards Anil Kumar. On 4/1/09, PUNEET NASA wrote: > > CAN U SEND ME THE SAME > > > On Tue, 31 Mar 2009 harsh shah wrote : > >*Installation > >Copy the attached file t

$$Excel-Macros$$ Unprotect Password of VBA or a excel sheet

. If any one have this tool or this type of file which will can do my above mention task, then please fwd the same on my below mention mail ID: anil.4u.ku...@gmail.com i wolud really appricate to all of you. above need is on ugrent base. Thanks & Regards, Anil Kumar. 0921390

$$Excel-Macros$$ Re: doubt

Hi Dear, This dollar sign indicate the reference. for example A$2 - indicate's Column A with increment with 2,3,4,5 ...n $A2- - indicate's Column A with increment with 2,3,4,5 ...n $A$2 - will fixed the value of a2 cells. Thanks & Regards, Anil Kumar. On 3/31/09, raafi barey

  1   2   >