1. H

    Calculating 15 minute high and low value for stock trading

    Hello people, i'm a newbie stock market trader and i trying my hand on algo trading for a while and i thought of doing all the calculation on my excel sheets. now i'm stuck with a problem for past few days and i'm not able to solve it, so i'm need of a help from fellow members of this forum to...
  2. A

    Top 5 high scores

    Hello, Is there a way to have a result of the top 5 highest scores? Here's my example. Entered manually: A1 = Dan - B1 = 63 A2 = Bill - B2 = 54 A3 = Steve - B3 = 73 A4 = Ben - B4 = 38 A5 = Patrick - B5 = 45 A6 = Jack - B6 = 104 A7 = Craig - B7 = 73 I put the tie on...
  3. O

    Looking for an If formula

    I am looking to use a IF formula but not sure how to write it so it returns the value i want. I have a list of SKU's that have a location by them, i also have a separate list of locations. I want the If formula to return a value of 1, if the SKU's location appears in my 2nd list...
  4. R

    ERROR FOUND 0x80072ee7. The server name and address could not be resolved

    Hi All, I am new to coding and programming in excel vba. Actually I have 50 Stock Tickers in Column "C".I am trying to download data from the Yahoo Finance website using their API. But when i run the code , an error is coming that: Run-time error '-2147012889( 0x80072ee7)': The server...
  5. mole999

    Scripting Dictionary

    I know these appear really fast, I have a worksheet that grows every day and currently 98% has to be looked up manually (basically a location, that then develops into postcode ad easting & northing plus A&B identifier's In the table shown as A I am developing values in Col AN I want to keep...
  6. D

    Offset Match Max - Priority Issue

    Hi folks, I am relatively new to Excel functions, but have set up a shared sheet in Google docs for my friends and I to do an online auction for our Fantasy Football draft in real time. I have each of our names in a separate column across row 11, and a blank cell below each name in row 12 for...
  7. R

    How to download 52 week high and 52 week low

    Hi all, I am new to coding and programming and would appreciate any suggestions you can give me in creating my first real code. So here i want the solution of how to download the 52 week high and 52 week low of a particular company into excel using the vba code. That's really all I am...
  8. O

    Attendance sheet

    Can you give me solution for Attendance sheet with public holidays should be high lighted in kuwait region
  9. Z

    IF(OR/AND) Formula

    Hi, I was trying to use IF, AND, OR formula to build the condition below but I'm not sure why it's not working. The condition should be: if Category is high or Critical and Status is Express then it's TRUE, otherwise False. The results column is the desired results. Category Status Results...
  10. I

    SUMIFS and numbers/ text in the same cell

    Hi there I would love some help in figuring out how to report subtotals from an existing dataset that has been created by combining values from two separate lists. List 1 - Category: Adoption, Process, People, Technology, Tools, and Location List 2 - Impact: 0 - No impact, 1 - Extremely Low...
  11. D

    VBA function IF

    Hi all, I try to make appear on the cell Cells(emptyRow, 11) the value ''HIGH'', ''MEDIUM'' or ''LOW'' in function of the value of the cell Cells(emptyRow, 10).value I mean if the value of that cell is more than 6 the value of Cells(emptyRow, 11) is ''HIGH'', if its value is less than 1...
  12. S

    Formula Help - High to Low and Odd to Even

    Hello everyone, I have 2 requests but they refer to the same cell range Cell range = A1 through C1 Example: Each cell can have a value from 0 through 9 A1 = 0 B1 = 0 C1 = 0 Even to Even formula A1 = 0 (even) B1 = 0 (even) C1 = 0 (even) So the result would be 2 (even follows an even (B1...
  13. C

    Finding the correct % value

    I have 20 assets (devices) 9 of the devices have vulnerabilities. Device 1 has 8 x critical vulnerabilities and 20 x High vulnerabilities. How do I correctly determine the true percentage values of Critical vulnerabilities and High vulnerabilities against number of assets with issues...
  14. P

    Need help

    I have code that High Lights Duplicates in a Workbook. Out of the 12 sheets only 7, I want to find dup's. All 7 are formatted as Table's and are identical. It also high lights the tab when one is found. It works perfect but I cant figure out how to exclude 4 of the sheets. Columns are A - T and...
  15. A

    Compare two means and calculate p value with pivot table

    Hi, I've built this table: <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <tbody> #d9d9d9[/URL] "] #d9d9d9[/URL] "]s_male #d9d9d9[/URL] "]Values #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #666666[/URL] , align: right"]0...
  16. A

    Compare two means and calculate p value with pivot table

    Hi, I've built this table: <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 178px"><col width="171"><col width="152"><col width="112"><col width="171"><col width="152"><col width="112"></colgroup><tbody> #d9d9d9[/URL] "] #d9d9d9[/URL]...
  17. M

    Assign value to dropdown

    Hi, I'm trying to create a dropdown that show a text value e.g. High but has a value associated to it so I can calculate it. https://we.tl/t-GCnCPTCPcA Thanks Matt
  18. M

    Dynamically derive data from websites into excel.

    I wish to automate the calculation of my portfolio at the end of day for my analysis purposes. https://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=SBIN The above web address needs to be dynamically modified to obtain data of stocks. In the above address "SBIN"...
  19. DRSteele

    Averages per Day

    Can someone please help me? I have a Query Table of climate data from 1/1/1900 to today which I update regularly. I wish to calulate the mean High for each of the days (e.g., month 2 day 19) and compare it to the High for each date (e.g. all of the Feb 19s), subsequently indicating whether it...
  20. A

    Checking multiple cells to see if they contain any of a list of choices

    Good morning guys... I have been racking my (less-than-ample) brain on this one for a couple of days... please help... If i have a questionnaire which contains something like "What countries do you do business with?" and it yields a single cell with all their answers delimited by a comma, is...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back