$$Excel-Macros$$ Re: Introduce Yourself !!

Hi Guys, I am Deepu Dubey, working as Team lead-MIS in The Lalit Hotel Group, having experience of 3 years in field of MIS. My interest are learning new things on each day and i am music freak. I 24yrs old. On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and

$$Excel-Macros$$ Help on Vlookup

Hi all, Need your help on attached excel sheet as my vlookup formula is not reflecting the value. -- 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

Re: $$Excel-Macros$$ Help on Vlookup

hi, PFA On 17 June 2016 at 12:52, vikas khen wrote: > Hi all, > > > > Need your help on attached excel sheet as my vlookup formula is not > reflecting the value. > > -- > 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 pag

Re: $$Excel-Macros$$ Help on Vlookup

Thanks deepak for urgent help Regards, On Jun 17, 2016 13:03, "deepak kumar" wrote: > hi, > > PFA > > On 17 June 2016 at 12:52, vikas khen wrote: > >> Hi all, >> >> >> >> Need your help on attached excel sheet as my vlookup formula is not >> reflecting the value. >> >> -- >> Are you =EXP(E:RT)

$$Excel-Macros$$ need help on finding the vales in attached sheet

Hi Team, Need your help on finding the value in attached sheet. Request all of you to kindly help me on this please find attached sheet for the reference. -- 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 for

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

Please Help me on this _ On Jun 17, 2016 14:43, "vikas khen" wrote: > Hi Team, > > Need your help on finding the value in attached sheet. > > Request all of you to kindly help me on this > > please find attached sheet for the reference. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hey Folks, Am Devendra aged about 25, working a Sr. Executive-OPS in a pioneer brand in E-Commerce sector. Have 4+ years of experience in MIS & Operations.My interest are learning new things & spreading them in my peers. am also a music lover. On Fri, Jun 17, 2016 at 12:30 PM, Deepu Dubey wrot

Re: $$Excel-Macros$$ Help on Vlookup

pfa attached without helping column. Vikas Verma Thanks & regards, www.MrExcel4U.com On Fri, Jun 17, 2016 at 12:22 AM, vikas khen wrote: > Hi all, > > > > Need your help on attached excel sheet as my vlookup formula is not > reflecting the value. > > -- > Are

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

What array are you talking about?Your file says:"If E2 value is in Array then it should reflect in F otherwise count as a not found" So, since column E is labeled as "id", then I suspect you want to look in an array of ID's.The only other ID heading is column "B" which is "Employee Id"But those

$$Excel-Macros$$ Formula required

Dear Sir please help me by resolving the issue. -- *Rajesh Kumar Agarwal* *9811063001* -- 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 con

Re: $$Excel-Macros$$ Formula required

Hi, PFA On 17 June 2016 at 17:56, Rajesh Agarwal wrote: > Dear Sir > > please help me by resolving the issue. > > -- > *Rajesh Kumar Agarwal* > *9811063001 <9811063001>* > > -- > 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 Face

Re: $$Excel-Macros$$ Formula required

plz provide more clearity?? about your query Thanks & regards, www.MrExcel4U.com On Fri, Jun 17, 2016 at 5:26 AM, Rajesh Agarwal wrote: > Dear Sir > > please help me by resolving the issue. > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > Are you =EX

$$Excel-Macros$$ JAVA/UI DEVELOPER@Chicago, IL

Hi, Hope you doing Well !!! Here is our *Implementing partner **Requirement*, Please go through the below requirement and send us suitable consultant with their *updated resume, rates and Contact details ..* *Role: * *JAVA/UI DEVELOPER Location: **Chicago, IL* *Work Duration: 6+ months* *Int

$$Excel-Macros$$ Need VBA code for Date format change

Hi Experts, I have workbook with approx 300 rows.In this work book column A:A contain date with "dd.mm." format. Need to change this on "dd-mm-yy" Number format. Thank you for advance. Thanks, Krishnasamy.M -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIM

Re: $$Excel-Macros$$ Need VBA code for Date format change

Do you know if the cells contain actual DATES or if they are text strings? To check: try changing cell format to short date, or General.if they look different, then they are true "dates" and you simply have to change the date format to what you want to see. If they are NOT dates, then you need  t

$$Excel-Macros$$ Data Validation

I need to setup validation for a named range based on the value in say cell G5. The rule being as follows: IF cell G5 = 25,000.00 the validation rule is, the named range values <=25,000.00. On the other hand if cell G5 = 25,001.00 the validation rule for the named range is >= 25,000.00. Violati

$$Excel-Macros$$ CORE JAVA LEAD@San Jose, CA

Hi, Hope you doing Well !!! Here is our *Implementing partner **Requirement*, Please go through the below requirement and send us suitable consultant with their *updated resume, rates and Contact details ..* *Role: CORE JAVA LEAD Location: **San Jose, CA* *Work Duration: 6+ months* *Intervi

Re: $$Excel-Macros$$ Data Validation

Can you give me a couple sample files describing what you want?  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - Joh

Re: $$Excel-Macros$$ Need VBA code for Date format change

Thanks for you're reply and it's working. There is any way to do this via VBA for all cells in a columns. Thanks, Krishnasamy.M. On Jun 17, 2016 8:48 PM, "Paul Schreiner" wrote: > Do you know if the cells contain actual DATES or if they are text strings? > > To check: try changing cell format t

$$Excel-Macros$$ office 2010 file is currently in use. try again later error when saving

Hi all, Similarly I'm facing the subject issue on my Excel file. Kindly share you're experience and knowledge and solution. Note :-This workbook in shared folder. Thanks, Krishnasamy.M -- 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 off

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

Hi Paul, Please find the details in the attached sheet. Regards, Vik On Fri, Jun 17, 2016 at 5:53 PM, Paul Schreiner wrote: > What array are you talking about? > Your file says: > "If E2 value is in Array then it should reflect in F > otherwise count as a not found" > > So, since column E is

Re: $$Excel-Macros$$ Need VBA code for Date format change

Sure,the VBA version is DATEVALUE()the string must be in a valid date format for your Windows version. So, if when you enter a date in Excel, it is displayed as mm/dd/ format,then you need to "build" a string in this format. like:Sub MakeDate()     Dim nRow     For nRow = 1 To 30     If (

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

You're looking for a function like:=IFERROR(VLOOKUP(F2,D:D,1,FALSE),"No Record Found") Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long

Re: $$Excel-Macros$$ $$Excel-Macro$$ Import Data from PDF to Excel $$

++Adding Excel File On Sat, Jun 18, 2016 at 10:44 AM, Deepu Dubey wrote: > > > Hi Guys, > > I have a pdf file which need to be update on daily basis in an excel > file(Attached). > > I have to update only one thing from pdf file. > 1. Occ% column > > Can we get an macro to complete the same. > >