Excel Magic Trick 441: Count Times That Start With 7 (7:00, 7:15, etc.)

[marketguro]

As always, great video tutorial. What if I have "Yes" or "No" on column B and I want to select only hour with "Yes" value? How do I add this to code?

[ExcelIsFun]

You Tube won't let me post the formula in the comment area - so I sent you an e-mail.

[marketguro]

Excel is a challenge for beginner like me but you make it FUN.Thank you very much.

[ExcelIsFun]

You are welcome!

Did you get my e-mail?

[marketguro]

Thanks for the E-mail.

[ExcelIsFun]

No problem.

[eissoaibrasil]

Thank you for your response to my question, those are all great videos that you suggested.

I will view them and see if they work for my situation.

Thanks again.

[eissoaibrasil]

Great video as always! I have a linked spreadsheet that displays live stock market data. I need to extract data from each field as price increases or decrease and store it in a separate field, to show the relative change in High/Low. Is this possible in Excel?

Thanks for n e help u can give.

[ExcelIsFun]

Try these video titles:

Excel Busn Math 33: Stock Values Web Query & Rate Of Change

Excel Magic Trick #44: Web Query, % Change & Custom Number F

Excel Magic Trick #108: Exchange Rate Table From Web Query