sector

Hi, I am trying to automate a monthly investment commentary where I would write predetermined sentences in Word with certain portions of the sentences being left blank and meant to be linked to cells in an Excel worksheet; somewhat similarly to a mail merge greetings linked to an address book...

There are 30 functions and each one is tied to revenue. So I know how much revenue is tied to each function. <tbody> Functions Revenue 1A $24.00 2A $54.00 3A $36.00 5A $23.00 8A $25.00 9A $42.00 11A $35.00 13A $75.00 1B $79.00 2B $6.00 3B $80.00 5B $7.00 6B $46.00...

There are 30 functions and each one is tied to revenue. So I know how much revenue is tied to each function. <tbody> Functions Revenue 1A $24.00 2A $54.00 3A $36.00 5A $23.00 8A $25.00 9A $42.00 11A $35.00 13A $75.00 1B $79.00 2B $6.00 3B $80.00 5B $7.00 6B $46.00...

Hi Mr. Excel community, I have been performing a daily task at work. On a spreadsheet there are several tables. I need to automate this repetitive task using excel macros All the tables have their first column in A The number of tables may vary All the tables have atleast the following...

I would like to count the number of times a number string (numbers in bold in Column A) occur in a cell (# in Column B) throughout my file of XXX # of rows. The number string varies in length but the format is always constant (i.e. #.##.##.#). Thanks, in advance, to all for your help! <tbody>...

Greetings! I have three data columns Column A - market sector Column B - stock weight Column C - stock return I would like to calculate a weighted median two ways: 1) for all the data in columns b & c irrespective of market sector 2) for only data in b & c that is also in the Technology...

Hi guys, having some trouble with a calculated column on a pivot table. I thought it should be simple but apparently not. All I need to do is add a 3rd column which will be column B - column A giving me the difference. The pivot table looks as below. <tbody> Sectors 201710 201711 Sector A...

Hi. I'm hoping that someone out there will be able to help! I have c.600 rows of data with three important columns (Name, sector, valuation). I would like a formula to return the number of companies in each sector (e.g. housebuilder, Tech) that sit within each quartile of valuation. I can...

Hi, I will try to explain this the best that I can. I have a dump of data every month that I have to use to create reports. This dump has columns up to NG and rows are are currently at 1112, so its a large spreadsheet. The columns will not change but the rows will get longer per month. There are...

I think its easier to just show you! <tbody> Company Sector LMArchitect Architect PJKArchitects Architect PLPlumber Plumber </tbody> I have a list of companies in column one. I want to include the sector in column two. However they are a mix of letters and types. Is it possible to use...

Hi, I have two spreadsheets, each containing two columns - Company ID and Profit (Sheet1), the other one contains Company ID and Sector(Sheet2). I am building third sheet which will contain a calculation. Let's say I'll put a drop down menu in A1 which will allow user to choose Sector. Then...

Hi, I have two spreadsheets, each containing two columns - ID and Profit (Sheet1), the other one contains ID and Sector(Sheet2). I am building third sheet which will contain calculation. Let's say I'll put a drop down menu in A1 which will allow user to choose Sector. Then, I want in A2 a...