company

E F G H I Company A Comp B Comp C $1.00 $.30 $.24 =min(E2:G2) Comp C $.53 $.62 $.51 $.40 $0.00 $.46 The simple MIN...

Hi everybody, I have one block of 10 columns. The 10 columns contain data ordered by year (from the most recent to the oldest - 2019 - 2018 .... - 2010). Example of block of 10 columns: <tbody> company A 2019 A 2018 A 2017 A 2016 A 2015 A 2014 A 2013 A 2012 A 2011 A 2010 value...

Hi I have a spreadsheet running vba which separates data into the relevant tabs. my problem is after running the macro, if i need to correct a line in the master sheet it doesnt update or create a new tab. So for instance, tab 2 has 2 lines of info, i then go to the master sheet and edit 1...

Does anyone have a formula to use the Ultimate Parent Company Id field to pull back data/info on a company (as opposed to using the ISIN number, the ticker, the cusip etc.). Thanks,

I have a table of data with three columns: - company code - company name - sales When we use Pivot Tables, we would drag, say, Company Code to the rows field and Sales to the total field. But how about if we wanted to see the company name corresponding to the company code... how would you go...

Hi I have a 5-sheet Workbook on Sheet 1 there is a table with a Header from "A6:K6" In column D there is text with company departments. I want to copy all Rows with all columns from the table to Sheet 2 inserted from Row"A7: K7" without Header However, the Rows white company department...

i need help creating a formula to do a lookup, on my landing page i have an identifier for a company, however on my data page there may be more than one record for that company that all have the same identifier with different start dates. i need a formula to bring in the last date associated...

I have two workbooks. https://1drv.ms/x/s!AvjBsEPEq12ngS2YS0oBxz5iM-e9?e=Yp3tbV Workbook 1 just has one sheet of data in a table format. There are many columns. One of them is called "Vendor" and is composed of the names of companies. Workbook 2 has many sheets. Each company name in the first...

https://1drv.ms/x/s!AvjBsEPEq12ngR1M8FneK-3B1Ew7?e=1pqHkd Hey guys, Let me explain my setup. This workbook is what I use to manage invoices that we pay to other companies. Company (1) sends us invoices. We'll pay them. Each week, Company (1) will send us a statement with a list of...

Dim rData As RangeDim Lst As Long, LRow As Long LRow = Range("W" & Rows.Count).End(xlUp).Row Range("V18:Y" & LRow).ClearContents Set rData = Range("A18", Range("B" & Rows.Count).End(xlUp)) rData.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("W18"), Unique:=True With...

Can anyone help me with a VBA code that will take this list and create a summary list in column W-Y. Each item should have a subtotal like in the example in the next table. The Ticker and Name are in column A & B and the Amounts are in column P. The output should be place in in C. Greatly...

Hey guys, so basically I have a list on the left of companys (company a, company b as example) and list of products for each company (P1, P2, P3) and the revenue Now I need something like the right hand side where all the products for each company are in a single cell (or even how to have...

Hi guys Is there a way to link an excel spreadsheet to a website? Each case I work on has different dates. This tells me how many reports I need to download from a company internal website. When I go on the company website, I select the report and use cute pdf to save this file on the hard...

Hi, I am new to this forum and currently having some problems with SUMIFS. I am trying to get the formula to check if criteria 1 and 2 are met and then if they are add the sum range value to get a total. For criteria 1 I found that the formula in G3 only notices 124 if the cell contains a letter...

I'm creating a file where a company name is selected from a drop-down menu at the top, and id like it to display the full column of corresponding values for the company from the raw data sheet. I originally used (=VLOOKUP($B$1,Table5,3,FALSE) changing the 3 to 4,5,6, etc for each column...

I'm lost on how to go about taking the follow data from a excel spreadsheet and creating the listing on the bottom. My data looks like this (sheet1) Company Product# A 10 A 11 A 12 A...

Hello, I'm looking for 2 formulas to identify: 1. Column header for selected cell. 2. Row header for selected cell. Example: <tbody> Jan Feb Mar Apr Company A 1 2 3 4 Company B 5 6 7 8 Company C 9 10 11 12 Company D 13 14 15 16 </tbody> If the value selected is 10, I want cell F1...

Please help!! I have a large list ofcompanies (approx. 180,000 rows) that placed bids on different contracts. I amtrying to determine how to figure out how many TOTAL times each company bidagainst one another. Any suggestions?? Sample dataset is below: Contract Number (Column A)...

Hi, I'm hoping to get help with how to compare company data with a handful of other companies. I originally ran pivot table to compare the totals of each company, but was asked to compare my companies data with the average and median number of about 30 other companies in my industry. I will need...

I have a table visualization on the canvas set up that currently looks like this: <tbody> Company Place Incident Count (Blank) (Blank) (Blank) (Blank) (Blank) (Blank) Company A Place 1 1 Company A Place 2 1 Company A Place 3 (Blank) Company B Place 4 2 Company C Place 5 1...