https://www.business-spreadsheets.com/forum.asp?f=11Excel help forum topics for Automating Data Analysis Tasks. The Excel help forum for business provides help topics for Excel based business applications and analysis.en-usWed, 20 Nov 2024 17:08:00 GMThttps://www.business-spreadsheets.com/images/bslogo.pnghttps://www.business-spreadsheets.com/forum.asp?f=11https://www.business-spreadsheets.com/forum.asp?t=1480Data Profiling in #Excel in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 18 Feb 2022 06:16:22 GMThttps://www.business-spreadsheets.com/forum.asp?t=1466Formula selecting in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 30 Sep 2021 12:57:49 GMThttps://www.business-spreadsheets.com/forum.asp?t=1452Data Analysis with Beautiful Charts in Microsoft #Excel & Office 365 in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 6 Aug 2021 06:52:52 GMThttps://www.business-spreadsheets.com/forum.asp?t=1383duplicate invoice numbers in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Wed, 2 May 2018 14:27:36 GMThttps://www.business-spreadsheets.com/forum.asp?t=1376Facing difficulty in Financial Reporting and Analysis in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 19 Dec 2017 05:53:15 GMThttps://www.business-spreadsheets.com/forum.asp?t=1283simple spreadsheet that finds m and b of y=mx+b given two cartesian points in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Wed, 4 Mar 2015 15:42:45 GMThttps://www.business-spreadsheets.com/forum.asp?t=1254Web query in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 29 Aug 2014 08:20:46 GMThttps://www.business-spreadsheets.com/forum.asp?t=1213Check PDF files for text from #Excel file. in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 4 Feb 2014 00:43:19 GMThttps://www.business-spreadsheets.com/forum.asp?t=1199Fetch Data automatically in a single cell in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 26 Oct 2013 11:29:33 GMThttps://www.business-spreadsheets.com/forum.asp?t=1156Delete cell items in spreadsheet in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 11 Apr 2013 11:51:52 GMThttps://www.business-spreadsheets.com/forum.asp?t=1120Free software download? in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 4 Aug 2012 07:30:25 GMThttps://www.business-spreadsheets.com/forum.asp?t=1119Can anyone help to create a project plan? in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 17 Jul 2012 07:38:26 GMThttps://www.business-spreadsheets.com/forum.asp?t=1111Newbie join here! in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 28 Jun 2012 03:32:44 GMThttps://www.business-spreadsheets.com/forum.asp?t=1108How to pull data from webpage(.aspx) for a excel column? in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 28 Jun 2012 01:34:17 GMThttps://www.business-spreadsheets.com/forum.asp?t=1083Using excel to automatically build a database of stock data in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 23 Feb 2012 06:46:11 GMThttps://www.business-spreadsheets.com/forum.asp?t=1036Is this possible - Change dates in URL? in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 18 Oct 2011 06:02:15 GMThttps://www.business-spreadsheets.com/forum.asp?t=1032Convert numbers to a specific text string in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 1 Oct 2011 12:44:05 GMThttps://www.business-spreadsheets.com/forum.asp?t=1026Institutional ownership 13F form downloads from SEC and Bloomberg in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 19 Jul 2011 13:51:46 GMThttps://www.business-spreadsheets.com/forum.asp?t=999Taking out middle names on a long list of names in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 6 Jun 2011 19:13:27 GMThttps://www.business-spreadsheets.com/forum.asp?t=960Finding max value based on data that contains both text and numbers in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 18 Apr 2011 16:19:46 GMThttps://www.business-spreadsheets.com/forum.asp?t=946Basic #Excel data categorization in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 29 Mar 2011 22:25:20 GMThttps://www.business-spreadsheets.com/forum.asp?t=913Conditional formatting of the last entry in the column only in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 4 Feb 2011 10:02:51 GMThttps://www.business-spreadsheets.com/forum.asp?t=889Auto copy from drop down list to three new sheets in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Wed, 26 Jan 2011 13:42:49 GMThttps://www.business-spreadsheets.com/forum.asp?t=869Using #Excel to connect to AS400 database to retrieve data in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sun, 26 Dec 2010 17:22:33 GMThttps://www.business-spreadsheets.com/forum.asp?t=857About 64 bit ODBC Connect #Excel 2007 download in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 18 Dec 2010 02:52:39 GMThttps://www.business-spreadsheets.com/forum.asp?t=805Run Macro IF Specific URL Changes in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 30 Oct 2010 14:36:19 GMThttps://www.business-spreadsheets.com/forum.asp?t=793Concatenate string and lookup in array? in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 11 Oct 2010 23:04:39 GMThttps://www.business-spreadsheets.com/forum.asp?t=746Conditional Formatting to color-code three highest values? in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 30 Jul 2010 15:15:43 GMThttps://www.business-spreadsheets.com/forum.asp?t=744Finding a common string in two columns in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Wed, 28 Jul 2010 13:35:47 GMThttps://www.business-spreadsheets.com/forum.asp?t=741Adding up interchanging word in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 22 Jul 2010 15:22:05 GMThttps://www.business-spreadsheets.com/forum.asp?t=737Automating a web query in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 16 Jul 2010 02:38:09 GMThttps://www.business-spreadsheets.com/forum.asp?t=731IF Statement in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Wed, 14 Jul 2010 23:00:42 GMThttps://www.business-spreadsheets.com/forum.asp?t=702Exclude Space and restrict text length in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 27 Apr 2010 00:46:57 GMThttps://www.business-spreadsheets.com/forum.asp?t=675Change text based on content in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 29 Mar 2010 18:54:25 GMThttps://www.business-spreadsheets.com/forum.asp?t=671Import print screen figures into #Excel in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 19 Mar 2010 06:42:28 GMThttps://www.business-spreadsheets.com/forum.asp?t=626selective cells for use in a different spreadsheet in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 15 Feb 2010 08:09:17 GMThttps://www.business-spreadsheets.com/forum.asp?t=625Search Function in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 11 Feb 2010 17:35:33 GMThttps://www.business-spreadsheets.com/forum.asp?t=614How to Calulate if a Range of Times Falls Between two Date/Time Stamps in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 21 Jan 2010 13:15:57 GMThttps://www.business-spreadsheets.com/forum.asp?t=589Trouble with VBA query using date with ODBC in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 11 Dec 2009 15:21:35 GMThttps://www.business-spreadsheets.com/forum.asp?t=561Download Historical NAV form web in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sun, 15 Nov 2009 18:57:07 GMThttps://www.business-spreadsheets.com/forum.asp?t=554Web Query with Session ID Variable in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 13 Nov 2009 10:20:50 GMThttps://www.business-spreadsheets.com/forum.asp?t=468Hyperlink to saved PDF's in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 23 Jun 2009 04:14:05 GMThttps://www.business-spreadsheets.com/forum.asp?t=464Web query issues in data format in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 8 Jun 2009 17:56:13 GMThttps://www.business-spreadsheets.com/forum.asp?t=455Lookup Function (kinda?) in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 1 May 2009 06:57:48 GMThttps://www.business-spreadsheets.com/forum.asp?t=453Easy Pricing in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 23 Apr 2009 10:45:20 GMThttps://www.business-spreadsheets.com/forum.asp?t=452automated email on an event of default in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 21 Apr 2009 23:53:46 GMThttps://www.business-spreadsheets.com/forum.asp?t=451Selection Problems in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 18 Apr 2009 05:35:11 GMThttps://www.business-spreadsheets.com/forum.asp?t=450How to find the most common numbers? in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 10 Apr 2009 12:57:21 GMThttps://www.business-spreadsheets.com/forum.asp?t=420Importing Data From multiple Text files in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 31 Jan 2009 08:54:21 GMThttps://www.business-spreadsheets.com/forum.asp?t=415Creating a continuously updating excel document in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 23 Jan 2009 10:22:20 GMThttps://www.business-spreadsheets.com/forum.asp?t=395Live Data in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 24 Nov 2008 23:54:33 GMThttps://www.business-spreadsheets.com/forum.asp?t=359How to recode values in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 25 Jul 2008 02:29:54 GMThttps://www.business-spreadsheets.com/forum.asp?t=331Separating text from numbers in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 14 Jun 2008 18:23:25 GMThttps://www.business-spreadsheets.com/forum.asp?t=320Multiple If condition in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 6 Jun 2008 03:33:18 GMThttps://www.business-spreadsheets.com/forum.asp?t=310Write To Web Page in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 20 May 2008 03:23:24 GMThttps://www.business-spreadsheets.com/forum.asp?t=309Bloomberg API in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 17 May 2008 02:50:09 GMThttps://www.business-spreadsheets.com/forum.asp?t=286Calculating the time in Hours in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 1 Mar 2008 18:11:42 GMThttps://www.business-spreadsheets.com/forum.asp?t=282Generating possible Combination on a 6 by 6 table in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 25 Feb 2008 16:34:56 GMThttps://www.business-spreadsheets.com/forum.asp?t=277Counting case-sensitive values within a range of cells in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 11 Feb 2008 06:27:30 GMThttps://www.business-spreadsheets.com/forum.asp?t=255Conditional Formatting in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 17 Nov 2007 14:01:21 GMThttps://www.business-spreadsheets.com/forum.asp?t=241Help creating a list that meet certain criteria ... in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 26 Oct 2007 01:12:29 GMThttps://www.business-spreadsheets.com/forum.asp?t=230Help me with web query pls in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 4 Oct 2007 13:45:43 GMThttps://www.business-spreadsheets.com/forum.asp?t=223Looping Query using value from next cell in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 27 Sep 2007 05:36:46 GMThttps://www.business-spreadsheets.com/forum.asp?t=202http://excelmedic.com in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 27 Aug 2007 03:04:14 GMThttps://www.business-spreadsheets.com/forum.asp?t=199all possible numerical combinations in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 25 Aug 2007 04:05:26 GMThttps://www.business-spreadsheets.com/forum.asp?t=179Automate cost allocation in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 29 Jun 2007 05:48:47 GMThttps://www.business-spreadsheets.com/forum.asp?t=149Issue on Web Query in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 5 Apr 2007 23:04:14 GMThttps://www.business-spreadsheets.com/forum.asp?t=139Web Query: Not able to login in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sat, 24 Mar 2007 07:34:51 GMThttps://www.business-spreadsheets.com/forum.asp?t=134Assigning category to downloaded data building FSs in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 5 Mar 2007 14:57:42 GMThttps://www.business-spreadsheets.com/forum.asp?t=132Combination of Values in Cells in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Thu, 1 Mar 2007 09:48:09 GMThttps://www.business-spreadsheets.com/forum.asp?t=123Look Up in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 13 Feb 2007 00:18:24 GMThttps://www.business-spreadsheets.com/forum.asp?t=117Bloomberg ActiveX control in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 9 Feb 2007 06:59:48 GMThttps://www.business-spreadsheets.com/forum.asp?t=110Adding Formula to Cells in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Wed, 24 Jan 2007 06:34:37 GMThttps://www.business-spreadsheets.com/forum.asp?t=103Automating a web query login to download data in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 18 Dec 2006 12:45:34 GMThttps://www.business-spreadsheets.com/forum.asp?t=57#Excel web query results destination in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Sun, 13 Aug 2006 14:41:10 GMThttps://www.business-spreadsheets.com/forum.asp?t=31Send variables to MSQuery via entry in #Excel cell range? in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Tue, 9 May 2006 03:22:39 GMThttps://www.business-spreadsheets.com/forum.asp?t=11Cumulative formula based on entries in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Fri, 24 Feb 2006 20:01:57 GMThttps://www.business-spreadsheets.com/forum.asp?t=10Returning a value from a range of data in Automating Data Analysis Tasks - find the solution for this #MicrosoftExcel issue.Mon, 20 Feb 2006 15:34:00 GMT