Automating Data Analysis Tasks

Excel Help Forum for Automating Data Analysis Tasks

Excel Help Topics		Date	Author	Views	Replies
	Basic Excel data categorization	29 Mar 2011	anu_17	5,967	1
	Conditional formatting of the last entry in the column only	04 Feb 2011	environdata	5,671	3
	Auto copy from drop down list to three new sheets	26 Jan 2011	allyc0820	5,952	4
	Using Excel to connect to AS400 database to retrieve data	26 Dec 2010	davidong328	8,606	1
	About 64 bit ODBC Connect Excel 2007 download	18 Dec 2010	satimis	6,725	1
	Run Macro IF Specific URL Changes	30 Oct 2010	indi visual	5,242	3
	Concatenate string and lookup in array?	11 Oct 2010	Lhadrepsak	6,262	1
	Conditional Formatting to color-code three highest values?	30 Jul 2010	heatherchellette	6,125	1
	Finding a common string in two columns	28 Jul 2010	Sansha	6,255	2
	Adding up interchanging word	22 Jul 2010	JordanGoodchild	4,617	1
	Automating a web query	16 Jul 2010	Double A Enterprises	5,116	1
	IF Statement	14 Jul 2010	dkalra1981	4,981	3
	Exclude Space and restrict text length	27 Apr 2010	dkalra1981	5,478	1
	Change text based on content	29 Mar 2010	EBERE	4,553	1
	Import print screen figures into Excel	19 Mar 2010	frcrilly	5,076	1
	selective cells for use in a different spreadsheet	15 Feb 2010	legepe	4,433	1
	Search Function	11 Feb 2010	ajhat	2,459	0
	How to Calulate if a Range of Times Falls Between two Date/Time Stamps	21 Jan 2010	Michaniker	4,992	1
	Trouble with VBA query using date with ODBC	11 Dec 2009	rhawk204	4,085	0
	Download Historical NAV form web	15 Nov 2009	Maheshp	6,640	5