logo
down
shadow

EXCEL QUESTIONS

excel vba http request download data from yahoo finance
excel vba http request download data from yahoo finance
I wish this help you I am in the process of making a program I wrote using excel vba faster. , Try this revised code
TAG : excel
Date : November 24 2020, 03:41 PM , By : Dan Vine
Excel Vba Loop , not running properly
Excel Vba Loop , not running properly
To fix this issue Well, I'll be guessing here.Firstly, always try to give meaningful names to your variables. This is to help clarify your intentions.
TAG : excel
Date : November 24 2020, 05:47 AM , By : Ganesh Kumar Subrama
Efficiently hiding / unhiding many (+500) rows in Excel VBA
Efficiently hiding / unhiding many (+500) rows in Excel VBA
wish help you to fix your issue Currently I am working on a Excel/VBA workbook that displays approx. 500 items in of a budget, each on a different row. I want the user to select the level of detail in the budget: on the highest level each individual
TAG : excel
Date : November 24 2020, 05:47 AM , By : user4639422
Excel's Find function; Exceptions over values
Excel's Find function; Exceptions over values
To fix the issue you can do The Find function looks for a case-sensitive match, and can be tested with IsNumber, like:
TAG : excel
Date : November 24 2020, 05:44 AM , By : Jim Cheng
reading data from an excel sheet in perl
reading data from an excel sheet in perl
seems to work fine The best way to read from an Excel file is using a CPAN module, like Spreadsheet::XLSX
TAG : excel
Date : November 24 2020, 05:44 AM , By : ibrahim alhumaidi
Using Webservice function in Excel to pull "Next Earnings Date" from Yahoo Finance using Yahoo API
Using Webservice function in Excel to pull "Next Earnings Date" from Yahoo Finance using Yahoo API
wish of those help Based on the documentation you provided for the API, the data you are looking for is not available in the Yahoo Finance API. Because Yahoo does not make this data available, you actually need to find a different API to work with in
TAG : excel
Date : November 24 2020, 01:01 AM , By : user2957594
Three And (&)'s into an if statement VBA for Excel
Three And (&)'s into an if statement VBA for Excel
I hope this helps . Sheets can be deleted at once using array of sheet names. In the For-Each loop collect the names of sheets you wish to delete into an array. Then just call Worksheets(sheetsToDeteleArrayHere).delete so all the sheets in the array
TAG : excel
Date : November 24 2020, 01:01 AM , By : user2957533
Certain fractions being calculated in excel 2013
Certain fractions being calculated in excel 2013
will be helpful for those in need You simply need to change the cell format; you want to use ???/???. This will make Excel represent any decimal number to the closest fraction approximation it can find using the specified numerator and denominator si
TAG : excel
Date : November 23 2020, 01:01 AM , By : user2957147
Excel formula to find sum of difference
Excel formula to find sum of difference
With these it helps I have excel sheet with 2 columns: baseline, current. , Found the answer.. no need for new column or so..
TAG : excel
Date : November 22 2020, 10:56 AM , By : user2956693
countfis or sum if array to work out if given time is between the value of two columns
countfis or sum if array to work out if given time is between the value of two columns
I hope this helps . If I understand correctly, you want a 0 or 1 for each of the times in row 10 that you can use a conditional format on to show red or nothing. In A10 try,=COUNTIFS($A$2:$A$5,""A$10)
TAG : excel
Date : November 22 2020, 10:56 AM , By : Konstantinos Daras
Error in Date Cell in CSV
Error in Date Cell in CSV
seems to work fine Use Custom format as yyyy/mm/dd hh:mm:ss AM/PM in Type text box and save as csv should work
TAG : excel
Date : November 22 2020, 10:54 AM , By : bundyal
Syntax while trying to include The multi-part identifier [°C] in command text
Syntax while trying to include The multi-part identifier [°C] in command text
I wish this helpful for you Ok, I've finally deducted that you are using the Excel Jet driver to connect directly to the Excel spreadsheet. This driver uses a SQL engine which has some... unique features.One feature is to convert square brackets in a
TAG : excel
Date : November 22 2020, 10:48 AM , By : user2956025
How to find day of the week from known date and month but variable year
How to find day of the week from known date and month but variable year
wish of those help The solution was found by eliminating unnecessary variables and thus eliminating potential conversion problems.The final code was as follows:
TAG : excel
Date : November 22 2020, 10:48 AM , By : joshuaeasy
Modify Marker Transparency with Excel VBA
Modify Marker Transparency with Excel VBA
should help you out I made another solution to this writing a small python script which creates more points based on the weight of each point e.g. if the weight of a point is 12 then 12 identical points with the specifications of this point are creat
TAG : excel
Date : November 22 2020, 10:38 AM , By : user2955150
Excel tricky formula
Excel tricky formula
it should still fix some issue Assuming I've understood what you're asking, I believe the formula you're looking for in cell D4 and copied down is:
TAG : excel
Date : November 22 2020, 10:33 AM , By : user2954820
Loop Though All UDF Names in Project
Loop Though All UDF Names in Project
To fix this issue This question: Searching for function usage in Excel VBA got me thinking about a process for automating a search for all UDFs being used in a spreadsheet. Something along the lines of:
TAG : excel
Date : November 22 2020, 10:31 AM , By : Brian Russell
Searching for function usage in Excel VBA
Searching for function usage in Excel VBA
it fixes the issue In VBA - Use CTRL+F and select "Current Project" to find each usage of the function name in the project.On Worksheet - Use CTRL+F and make sure "Look In" is set to "Formulas." Then click "Find All" to find each usage of the functio
TAG : excel
Date : November 22 2020, 01:01 AM , By : theshark
Convert from list to flat CSV with modified data
Convert from list to flat CSV with modified data
fixed the issue. Will look into that further I used something like this in another answer: (Edit: Fixed some small errors and updated syntax) Tested Working!Before Code:
TAG : excel
Date : November 22 2020, 01:01 AM , By : k3kenan
Count how many words from a list appear in a cell
Count how many words from a list appear in a cell
To fix the issue you can do If you have the correct words in a list, one word per cell, e.g in Z2:Z20 with no blanks then you could use this formula in B1 copied down=SUMPRODUCT(ISNUMBER(SEARCH(" "Z$2:Z$20","," "A1","))+0)
TAG : excel
Date : November 21 2020, 07:31 AM , By : Nick D.
Insert Missing Years between 2 years
Insert Missing Years between 2 years
Does that help TESTEDFirst off, you should always avoid using Select and ActiveCell as described here.
TAG : excel
Date : November 21 2020, 07:31 AM , By : M Hall
Creating hierarchical sequence in Excel using several functions in formula
Creating hierarchical sequence in Excel using several functions in formula
With these it helps Ok, first of check this article out here, you should be able to find everything you need to create what you need. Now here is all formulas per every level in your exampleLevel 1
TAG : excel
Date : November 21 2020, 01:01 AM , By : treasure ngaobiwu
On Error GoTo statement is still executing although there is no error generated
On Error GoTo statement is still executing although there is no error generated
seems to work fine @dee provided the correct answer.The Errorhandler: is just a place holder. It does NOT operate like you think. You are using it like an If... Then... statement:
TAG : excel
Date : November 21 2020, 01:01 AM , By : user2953745
Find last digits with IF
Find last digits with IF
Any of those help For a slightly different approach, assuming you want to return the A2 value only if it represents a date in the last 5 or first 5 days of any month you can use this formula in B2=IF(DAY(TEXT(A2,"0000-00-00")+5)
TAG : excel
Date : November 21 2020, 01:01 AM , By : user2953725
Use Excel VBA to find column matches & merge based on the values of two other column
Use Excel VBA to find column matches & merge based on the values of two other column
this will help I have a little conundrum here while there's a few suggestions on the site, there's nothing that quite fits the bill for me. I need to merge some rows based on the values of some cells in the row. , The following code should address y
TAG : excel
Date : November 20 2020, 01:01 AM , By : BaiQiang
PowerPivot not sending Authorization header in Basic Authentication to OData Svc
PowerPivot not sending Authorization header in Basic Authentication to OData Svc
around this issue You need to append a trailing backslash to the OData endpoint URLs when setting-up the data source/feed in PowerPivot, e.g.
TAG : excel
Date : November 20 2020, 01:01 AM , By : Alex Russell
Vlookup not working with text search
Vlookup not working with text search
Hope that helps Use this formula instead. It will return the first match found for the bit of text entered in cell B1.
TAG : excel
Date : November 19 2020, 12:41 AM , By : Vipvipvip Vipvipvip
Paste value from a Userform to a Excel Sheet
Paste value from a Userform to a Excel Sheet
I wish this helpful for you The Sub below probably works for you. You should suitably qualify Ranges, and avoid using Select or Activate unless they are strictly needed.Note that you should: 1) populate your ComboBox prior to using it, 2) make sure t
TAG : excel
Date : November 18 2020, 03:49 PM , By : yhjiang
Excel 2010 Macro to compare two columns for finding the matched value
Excel 2010 Macro to compare two columns for finding the matched value
wish helps you Looks like you were almost there. Your copy line needed a little tweaking, however. In the example below, I added an additional variable called rngName, to store the range of the name to be copied and assigned it a value in the for j l
TAG : excel
Date : November 18 2020, 11:13 AM , By : cosgroma
#VALUE error when dealing with long string in UDF in VBA(excel)
#VALUE error when dealing with long string in UDF in VBA(excel)
With these it helps I believe you have run into one of the obscure limitations in the interactions between VBA and Excel.One workaround would be to change the formula to return only a single element, and have the particular element as an argument in
TAG : excel
Date : November 18 2020, 11:13 AM , By : SharkVC
Refer to a cell in another worksheet by referencing the current sheet's name
Refer to a cell in another worksheet by referencing the current sheet's name
may help you . I have looked into the already asked questions, yet I could not find a way to achieve my objective. , For sheet names containing spaces, enclose the name in'
TAG : excel
Date : November 18 2020, 11:13 AM , By : user2951572
VBA Excel 2007 : Need to loop copy and loop count number except zero every row above
VBA Excel 2007 : Need to loop copy and loop count number except zero every row above
help you fix your problem i'm a complete noob in vba so i'm searching all over the net to combine the code but right now it seems i hit the great wall and can't get it right. what i wanna do are:
TAG : excel
Date : November 18 2020, 01:01 AM , By : Stranger Guy
Excel: Conditional probabilities of winning a tiebreaker game
Excel: Conditional probabilities of winning a tiebreaker game
wish helps you If you are going to use those formulas, then as the paper says, you need to use two tables, P_A and P_B. Your calculation assumed that player A is on serve until someone reaches 7 or the score is (6,6). This incorrectly gives a big adv
TAG : excel
Date : November 18 2020, 01:01 AM , By : user2951197
How to find groups of individuals who attended multiple events together?
How to find groups of individuals who attended multiple events together?
this will help I take it this is an exercise and you are not interested in an alternative approach, but should someone else stumble across this post in earnest the easiest solution may be to apply a PivotTable:
TAG : excel
Date : November 18 2020, 01:01 AM , By : user2951047
Using DateTime when referencing a cell with SUMIFS()
Using DateTime when referencing a cell with SUMIFS()
Does that help You can leave C1 as a date and the data as it is - just change your formula to the following=SUMIFS(A:A,B:B,">="C1,B:B,"
TAG : excel
Date : November 17 2020, 11:52 AM , By : Miguel Rodriguez
VBA Copy & Transpose Data Range
VBA Copy & Transpose Data Range
this will help PasteSpecial is unavailable with the .Cut method, but not the .Copy method. When I changed
TAG : excel
Date : November 17 2020, 11:52 AM , By : user2950232
Huge excel file... any advice?
Huge excel file... any advice?
it should still fix some issue "there is no chance of this changing"You haven't said why there is no chance of changing but one real reason to change is this; a worksheet can only have 1,048,576 rows. If you have 800k rows now and you are still addin
TAG : excel
Date : November 17 2020, 11:52 AM , By : keyring
Looped macro to create a new sheet, rename it, add data from the web, then loop back through until complete
Looped macro to create a new sheet, rename it, add data from the web, then loop back through until complete
Hope that helps Made some syntax tweaks that should help as well as error handling if the sheet name already exists. Didn't make any changes to the QueryTable.Add method though.
TAG : excel
Date : November 17 2020, 04:28 AM , By : Kentucky Fried Chick
copy paste of tab delimited text results in strange formatting in Excel?
copy paste of tab delimited text results in strange formatting in Excel?
I hope this helps . This solution fixes both issues. Although the text is squished together, as shown in the OP, the tab characters are still in the string. With that said, the solution is to:
TAG : excel
Date : November 17 2020, 01:00 AM , By : user2949659
Excel user defined function: Nth_Occurence
Excel user defined function: Nth_Occurence
Hope that helps The following code seems to solve the problems you have mentioned. Note that your code
TAG : excel
Date : November 17 2020, 01:00 AM , By : user2949590
Excel ActiveX Button is clickable, but does not work
Excel ActiveX Button is clickable, but does not work
wish help you to fix your issue I found a solution to the issue. It appears as though my issue WAS still related to the Microsoft update.. I just happened to be experiencing a different symptom, and needed a different solution as well (rather than ju
TAG : excel
Date : November 17 2020, 01:00 AM , By : user2949436
Array Formula Conditional Count
Array Formula Conditional Count
like below fixes the issue This formula will count the number of rows that have a number >= 5 at least twice, change the 2 and 5 accordingly=SUMPRODUCT((MMULT((B2:E10>=5)+0,{1;1;1;1})>=2)+0)
TAG : excel
Date : November 16 2020, 06:23 AM , By : Mikhail Milyutin
YEAR() fitting to WEEKNUM(...,21) in Excel
YEAR() fitting to WEEKNUM(...,21) in Excel
I wish did fix the issue. The "Year" of the week is determined by the year of the Thursday of that week (assuming ISO week numbers) so you can just find the Thursday and then get the year of that date, i.e. for any date in A1=YEAR(A1-WEEKDAY(A1,3)+3)
TAG : excel
Date : November 16 2020, 06:23 AM , By : user2949221
Macro that follows a link and downloads the table into a new sheet
Macro that follows a link and downloads the table into a new sheet
This might help you Just to piggy back on @Jeeped awesome solution, I added in the formating to delete and just have the LeaseUnit/Well/Production info left. This assumes Casing table always follow the Production table
TAG : excel
Date : November 15 2020, 06:54 AM , By : Always Errors
How to Concatenate multiple columns if not empty
How to Concatenate multiple columns if not empty
it helps some times I want to concatenate the values of 9 columns into 1 column with | between the values. The problem is that some of the columns are empty for some of the rows, making it pretty ugly to use the =CONCATENATE() function as you would n
TAG : excel
Date : November 14 2020, 04:51 PM , By : Calis
Excel - List all the combinations of two words from one list, in two other columns
Excel - List all the combinations of two words from one list, in two other columns
This might help you Tap Alt+F11 and when the VBE opens, immediately use the pull-down menus to Insert ► Module (Alt+I,M). Paste the following into the new pane titled something like Book1 - Module1 (Code),
TAG : excel
Date : November 14 2020, 04:51 PM , By : user2948441
How do I do my Pentaho Report take the Excel datasource file along to BA/BI Server?
How do I do my Pentaho Report take the Excel datasource file along to BA/BI Server?
seems to work fine This one's tricky, as you need to refer to the file inside the PRPT (which is basically a ZIP file). Here's a procedure that worked for me:1) Add the Excel (or whatever) file as a Resource in Pentaho Report Designer (PRD). For my t
TAG : excel
Date : November 14 2020, 04:51 PM , By : user2948395
shadow
Privacy Policy - Terms - Contact Us © ourworld-yourmove.org