Automating Data Analysis Tasks

Excel Help Forum for Automating Data Analysis Tasks

Forum Category

New Post Login

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
	Finding max value based on data that contains both text and numbers	18 Apr 2011	Margretjona	6,443	3
	Is this possible - Change dates in URL?	18 Oct 2011	DMKPDX	6,356	6
	Combination of Values in Cells	01 Mar 2007	coolz	6,316	1
	Taking out middle names on a long list of names	06 Jun 2011	joe8489	6,243	5
	Help me with web query pls	04 Oct 2007	gagrinho	6,120	3
	Fetch Data automatically in a single cell	26 Oct 2013	krishna2221	6,097	1
	Concatenate string and lookup in array?	11 Oct 2010	Lhadrepsak	6,069	1
	Finding a common string in two columns	28 Jul 2010	Sansha	6,066	2
	Adding Formula to Cells	24 Jan 2007	yolewis	6,053	1
	Automate cost allocation	29 Jun 2007	Mlewit1	6,025	0
	Conditional Formatting to color-code three highest values?	30 Jul 2010	heatherchellette	5,930	1
	Basic Excel data categorization	29 Mar 2011	anu_17	5,781	1
	Auto copy from drop down list to three new sheets	26 Jan 2011	allyc0820	5,761	4
	Bloomberg API	17 May 2008	nomadicj5	5,742	0
	all possible numerical combinations	25 Aug 2007	the Dog	5,595	0
	Conditional Formatting	17 Nov 2007	BridgetteNelson	5,583	1
	Conditional formatting of the last entry in the column only	04 Feb 2011	environdata	5,468	3
	Multiple If condition	06 Jun 2008	PaulaM	5,409	4
	Importing Data From multiple Text files	31 Jan 2009	jgerding	5,404	1
	Convert numbers to a specific text string	01 Oct 2011	francis	5,365	1

Back

Displaying page 2 of 4

Next

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