Re: $$Excel-Macros$$ Need minium date

2013-03-04 Thread Paul Schreiner
There was no attached file. Are the dates true Excel dates? That is, if you changed the cell format to "long Date" would  today's date change to: Monday, March 04, 2013 ?? If so, then the values in column  A are numbers. (Excel Dates are the number of days since 1/1/1900) So, =MIN(A2:A99) would

Re: $$Excel-Macros$$ Need minium date

2013-03-04 Thread Aamir Shahzad
share your file On Mon, Mar 4, 2013 at 5:06 PM, Manoj Kumar wrote: > Dear Paul, > > Thanks for quick reply.. > > Date format is correct according to excel. > > i need minium date again C2.. > > > Regard > Manoj > > > On Mon, Mar 4, 2013 at 5:30 PM, Paul Schreiner wrote: > >> There was no attac

Re: $$Excel-Macros$$ Need minium date

2013-03-04 Thread Paul Schreiner
the =min() function would give you the minimum date. are you trying to say that you want the minimum date that has the name that matches the value in C2? I realize that you are having trouble attaching the file. Send it to me directly and I'll attach it in a response.   Paul ---

$$Excel-Macros$$ please provide me some basic training materials of Excel

2013-03-04 Thread Indrajit $nai
Hi all, please provide me some basic training materials of Excel . thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed

Re: $$Excel-Macros$$ please provide me some basic training materials of Excel

2013-03-04 Thread xlstime
try this http://www.free-training-tutorial.com/ On Mon, Mar 4, 2013 at 8:35 PM, Indrajit $nai wrote: > > Hi all, > please provide me some basic training materials of Excel . > thanks in advance. > > -- > Indrajit > > talk2indra...@gmail.com > > Disclaimer: > This electronic message and any files

Re: $$Excel-Macros$$ please provide me some basic training materials of Excel

2013-03-04 Thread Maries
Hi, http://www.youtube.com/user/excelisfun http://people.highline.edu/mgirvin/ExcelIsFun.htm On Mon, Mar 4, 2013 at 7:32 PM, xlstime wrote: > try this > > http://www.free-training-tutorial.com/ > > On Mon, Mar 4, 2013 at 8:35 PM, Indrajit $nai wrote: > >> >> Hi all, >> please provide me some

$$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-04 Thread Paul Schreiner
I may regret asking this, but here goes: Using Office 2010: I have Excel templates that are used to create documents and store the data in an Oracle database. The Oracle database has data from "released" and "archived" or "historical" documents. These documents are saved as PDF's and stored

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-04 Thread Sam Mathai Chacko
This has most of it http://www.excelfox.com/forum/f13/execute-sql-excel-vba-66/ Regards, Sam On Mon, Mar 4, 2013 at 11:50 PM, Paul Schreiner wrote: > I may regret asking this, but here goes: > > Using Office 2010: > > I have Excel templates that are used to create documents and store the > dat

Re: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

2013-03-04 Thread David McLaughlin
Wow That is neat. Thanks I need to try and remmember that. On Thursday, July 26, 2012 12:56:39 AM UTC-4, अनिल नारायण गवली wrote: > Dear Tony, > > U can use without macro > Just select the range and press ctl+G of press F5 function key . > Then click to blank cell and use Alt+E+D select the

Re: $$Excel-Macros$$ Arrow Up & down Query +Sign (+) & (-)

2013-03-04 Thread >>Excel Beginner<
Hi amar, Please find the attachment. *Regards,* * * *Excel Beginner* On Mon, Mar 4, 2013 at 11:50 AM, amar takale wrote: > Dear Experts Team > I have small query in excel,i give detail information in Attached sheet > Pls sloved my query > Amar > > -- > Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-04 Thread David Grugeon
Hi Paul Helen Feddema's book Access : Working with excel covers all this and much more. If you want it for $10 instead of $17 you have to subscribe for the free newsletter Access Watch. http://shop.office-watch.com/awe/fasttrack.aspx On Tuesday, 5 March 2013, Paul Schreiner wrote: > I may regre

$$Excel-Macros$$ MIS Job in Ienegizar

2013-03-04 Thread pankaj sangotra
Job Description * Should have good knowledge of Work force management * Prepare Weekly, Monthly reports on Excel sheets * Preparing MIS Reports using various Excel Formula Vlookup, Hlookup, Sorting and Pivot Table * Prepare data on MS Excel * 24/7 shifts *Good knowledge of Macros Walk in In

Re: $$Excel-Macros$$ MIS Job in Ienegizar

2013-03-04 Thread David Grugeon
Why did you post this? Rule 5) Jobs posting is not allowed. You have done this before. Please do not do it ever again. Regards David Grugeon On 5 March 2013 12:15, pankaj sangotra wrote: > Job Description > * Should have good knowledge of Work force management * Prepare Weekly, > Monthly

$$Excel-Macros$$ Re: Need minium date

2013-03-04 Thread Prince
=MIN(A2:A5) and change the format of cell as --- d/m/ as you required Regards Prince On Monday, March 4, 2013 5:20:16 PM UTC+5:30, Manoj Kumar wrote: > > Dear Expert. > > > Please help to find minium date in attached file.. > > A1 has date and B2 has name but I need in minium date in D2 > >

Re: $$Excel-Macros$$ Data Validation

2013-03-04 Thread Prince
one more point i want to add in Rajan's Explaination is that data validation Keep your data consistent so that it can hold its actual meaning. Lets suppose age of person Can not be a text value it should always be in Numeric value so that we can perform any calculation on it. Regards Prince On

$$Excel-Macros$$ Re: Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-04 Thread Prince
Hi Paul, 1: Public Sub OpenDb(strSql As String) Dim cnn As New ADODB.Connection Dim rstData As New ADODB.Recordset Dim strDbConnectStr As String Dim strDbPath As String strDbPath =* ThisWorkbook.Path & "\**Your Accessbase name**"

Re: $$Excel-Macros$$ please provide me some basic training materials of Excel

2013-03-04 Thread yhan a
Hi guys, Really impressed with all your in-depth knowledge on vba. I really want to learn how to program like vba, unfortunately my lack of background on computer program prevents me from learning. Pls. email me a basic guide for vba programming or any sort of beginner's guide for vba. I will gre

Re: $$Excel-Macros$$ please provide me some basic training materials of Excel

2013-03-04 Thread yhan a
Thank you for the help Kuldeep Singh. Ian On Tue, Mar 5, 2013 at 1:28 PM, Kuldeep Singh wrote: > > Hi, > > PFA.. > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 > naukrikuld...@gmail.com || www.naukri.com > *Please*

Re: $$Excel-Macros$$ please provide me some basic training materials of Excel

2013-03-04 Thread Indrajit $nai
Thanks to all of you. :) On Tue, Mar 5, 2013 at 11:04 AM, yhan a wrote: > Thank you for the help Kuldeep Singh. > > Ian > > > On Tue, Mar 5, 2013 at 1:28 PM, Kuldeep Singh wrote: > >> >> Hi, >> >> PFA.. >> >> Regards, >> Kuldeep Singh >> Info Edge India Limited (naukri.com) >> Phone

$$Excel-Macros$$ Excel Interview Query

2013-03-04 Thread Satendra kumar
Dear Experts, Please share solution of below query. Thanks in advance -- Thanks & Regards Satendra Kumar -- 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 FORU

Re: $$Excel-Macros$$ MIS Job in Ienegizar

2013-03-04 Thread Surbhi Agarwal
Thanks Pankaj for this post. I think no one face any type of problem if some one post job on a wall of this group. Because it would be help of some one if they need of this post Regards, Surbhi On Tue, Mar 5, 2013 at 7:45 AM, pankaj sangotra wrote: > Job Description > * Should have good know