$$Excel-Macros$$ Help MS Excel

2018-09-25 Thread Eric Paz
Hello, I would like to know if excel can sum all the numbers inside one single cell. Like: Cell A1 is : 3.123,5 so the sum of these numbers are 3+1+2+3+5=*14* -- 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

$$Excel-Macros$$ Need Help - Data validation selection from drop down list to auto-populate a range of cells below it

2017-02-05 Thread Eric Butash
plish this? <https://lh3.googleusercontent.com/-muaDzDLuvUA/WJcrLvKqK1I/AZ4/GVxXYOBn9kY3P5o5SCMmDtKAGE8kmmY_wCLcB/s1600/Screen%2BShot%2B2017-02-05%2Bat%2B8.39.35%2BAM.png> Thanks, Eric -- -- *DISCLAIMER: E-mails and any attachments from the Highland

$$Excel-Macros$$ Complex Look-ups

2009-10-15 Thread Eric
ering any erroneous formulas. Does anyone know of a better, more elegant way to retrieve data from several worksheets to create a single data table? Thanks, Eric --~--~-~--~~~---~--~~ -- S

$$Excel-Macros$$ Re: Calculating renewal dates

2009-09-07 Thread Eric
iply this number by the number of years in the contract term ( 2 years ). . This gives you the number of full years to add to the original contract begin date. Very nice and elegant. Thanks again for the help with this. -Eric On Sep 6, 6:41 am, "Daniel" wrote: > Try (beg

$$Excel-Macros$$ Calculating renewal dates

2009-09-05 Thread Eric
5/6/20045/6/2010 5/7/20045/7/2010 5/24/2006 5/24/2010 6/6/20026/6/2010 6/25/2004 6/25/2010 7/28/2004 7/28/2010 8/2/20028/2/2010 8/10/2006 8/10/2010 Any ideas or suggestions would be greatly

$$Excel-Macros$$ Re: convert zip code or state to time zone

2009-03-10 Thread Eric Li
Hi Michelle, I don't know such a formula. Maybe you could find a Database containing Zip Code, Area Code & Time Zone. Then write some SQL to get what you wa