market

I need help with some VBA to loop through a spreadsheet and Group rows with an indent level > 0. Indent level 0 is the highest level summary for the data, detail is broken out at indent level 1, 2 etc.. A data sample follows: Cash & Short Duration Cash and Money Market Money Market 1 Money...

What I am trying to do is to type a site ID on a field, and in next filed auto populate market id. Example Site ID - IL12345, Market IL So the first two letters would auto populate market ID. Any help is appreciated. Thanks

I have an Excel worksheet I use to log crew members in and out. I have a field where I type site ID and the other field I type market code. So I for Example Site ID IL12345, Market would be IL, how would I get it to auto populate based off the first two letters? I have 16 different markets...

I have a table that has the following Format <tbody> Plate Group Count Market Cost/LB Markup Markup % <= 1.5 and <= 120 319 .46 .39 .07 18% </tbody> I am trying to see if there is a simple way to convert that to <tbody> Plate Group Type Value <= 1.5 and <= 120 Count 319 <= 1.5 and <=...

Hi to everyone I ve been reading https://www.mrexcel.com/forum/excel-questions/559828-combining-data-two-spreadsheets.html?highlight=excel+table+relations as i am trying to solve following Assume having two sheets in same work book. Sheet 1 contains table 1 with columns "Name" & "Group" Sheet 2...

I am importing this table https://www.investing.com/crypto/currencies into Excel using Power Query. The column named Market Cap is entered as Text. All caps greater than 1 Billion are Large Caps, < 1 billion and > 200 million are mid caps and < 200 million are small caps. I need to either...

Hi. I am creating a slide based off the data in a pivot table. The Pivot table has 2 filters, "Market" & "HH Characteristic". I need to create a slide for each HH Characteristic within each Market. For example, there are 3 markets and 5 characteristics. For each market, I must create a...

Hello, Thank you for any help you can provide. Table 1 I am wanting to sum up the cost (USD) (Column I) for each market (Column D) and place that cost by date into the second Table by market in Column AA. I have been unable to figure this out. I have been able to group it but it adds all of...

Calculate puts needed to insure against stock market loss..

This is the formula I use to check the price of, say, YHOO, at close , from 6 days ago. = INDEX( GoogleFinance( "YHOO" ; "Close" ; TODAY()-6 ) ; 2 ; 2 ) The problem is that it registers dat 360 days a year and I don't know how to configure it to register data from workdays only. Thanks! A...