Automating Data Analysis Tasks

Excel Help Forum for Automating Data Analysis Tasks

Forum Category

Automating Data Analysis Tasks

The Excel help forum for automating data analysis tasks focuses on problems and solutions for saving time when analyzing data or building analytical models by applying appropriate formulas and utilizing visual basic for applications (VBA) code.

Excel Help Topics		Date	Author	Views	Replies
	How to Calulate if a Range of Times Falls Between two Date/Time Stamps	21 Jan 2010	Michaniker	4,389	1
	Search Function	11 Feb 2010	ajhat	2,266	0
	selective cells for use in a different spreadsheet	15 Feb 2010	legepe	3,917	1
	Import print screen figures into Excel	19 Mar 2010	frcrilly	4,572	1
	Change text based on content	29 Mar 2010	EBERE	4,014	1
	Exclude Space and restrict text length	27 Apr 2010	dkalra1981	4,976	1
	IF Statement	14 Jul 2010	dkalra1981	4,481	3
	Automating a web query	16 Jul 2010	Double A Enterprises	4,664	1
	Adding up interchanging word	22 Jul 2010	JordanGoodchild	4,093	1
	Finding a common string in two columns	28 Jul 2010	Sansha	5,809	2
	Conditional Formatting to color-code three highest values?	30 Jul 2010	heatherchellette	5,594	1
	Concatenate string and lookup in array?	11 Oct 2010	Lhadrepsak	5,733	1
	Run Macro IF Specific URL Changes	30 Oct 2010	indi visual	4,696	3
	About 64 bit ODBC Connect Excel 2007 download	18 Dec 2010	satimis	6,198	1
	Using Excel to connect to AS400 database to retrieve data	26 Dec 2010	davidong328	8,007	1
	Auto copy from drop down list to three new sheets	26 Jan 2011	allyc0820	5,480	4
	Conditional formatting of the last entry in the column only	04 Feb 2011	environdata	5,123	3
	Basic Excel data categorization	29 Mar 2011	anu_17	5,463	1
	Finding max value based on data that contains both text and numbers	18 Apr 2011	Margretjona	6,051	3
	Taking out middle names on a long list of names	06 Jun 2011	joe8489	5,862	5

Back

Displaying page 3 of 4

Find relevant Excel templates and add-ins for Automating Data Analysis Tasks in the Excel Business Solutions Directory