companies

Hi, Sorry if there is another thread about this, but I can't find any, or I don't know the right search criteria :-) Please see below table. Do you know a formula to calculate how many times two specific companies, has been working on the same project? In below example the results should be...

First post here and purely asking as I haven't found the answer through informational search. I completely appreciate below might not be the best use of Excel and that there are other tools that would probably be more suitable. I am looking for a MS Excel book for non(strictly)-formula/pivot...

Hi everyone, I'm new to this forum and hoping to get help with an issue I've been trying to resolve for a few hours now. The company I work has two entities with separate sets of accounting books in QuickBooks, the US-based accounting software. I'm trying to combine identical data sets from...

HI All I regret that In my job I don’t get to do as much work with reports as I would like as I just keep forgetting some of the basic stuff never mind the more complex formula’s and strategies. I have a sheet called raw data that shows the company name and products that our customers have...

Hello, ım new at vba, ı wrote a basic macro for my excel.This macro works like this: first he ask me how many company do you want to compare? exp: 3 and then ask wrote a company name and then it writes companies name to my main table and then ı see a value in some cell, so my problem is, there...

Hi everyone, I have a sheet that has lots of data in it. There are lots of row for the same company so i sort the sheet so all the company data from lots of rows is toghther. I like a macro that can insert a row in my data between the companies so i can easily see the companies data toghther...

I am trying to get excel to return a date from a list of orders from certain companies. This list has the same companies just different dates and i need excel to return the latest date. =INDEX(Orders!B313:B419,MATCH(1,(Orders!A313:A419="*"&F3&"*")*(Orders!B313:B419>N3),1)) F3 is the name of...

Hi team, I have one doubt about how I can find the domain name from companies mail address

Hi, I have a question that i'm hoping someone has a solution for. Suppose an investor owns 3 companies: Company A Company B Company C. Each of these 3 companies have various financial deliverables in .pdf form (i.e. Financial Statements, IRR Reports, Investor Reports, ect...) that use a...

I have an architect, HKS, and I'd like to see, when selecting their name in a splicer or drop down the top 10 other companies of other trades that they work with in a specific range of dates using a project name correlated with a project number to help delineate. IE Start Date - 12/1/2016 End...

Hi - I'm new to this forum although I have used it loads to get help but I am stuck with this one so hope you guys can assist! I have a table (2 columns) in excel. The first column contains only a letter, the second a list of company names. I then have to the right of my table a row headed up...

Hi, I have a problem and can not figure out that if there is a solution (mathematically possible) or not. I tried to demonstrate the problem below. I have tried so many things (goal seek, solver or analytical approaches) but could not find a solution. Now I am thinking that there is no solution...

Hello, I am trying to do a project that is based in the analysis of stock quotes over several years. However I have a few questions and I hope you can help me. The project I want to analyze how certain stocks behave between specific dates, i.e, what is the percentage growth or decay between...

Hi, I need to see the list of companies and associated details when I select a state. Please check the table I have and the desired list. List I have: <colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> s1 s2 s3 s4 s5 s6 s7 s8 s9 s10 name...

Hello， I was asked to compare numerous companies' data in current three years; I tried to use the “Bloomberg excel add in” to import all data. However，the problem is that some companies used the different currency, such as company A used the GBP, company B used the GB, it ?but company C...

Hello, I have a sheet with over 50K companies, now here is the thing, some companies repeats themselves in the sheet because the have multiple licenses. What I would like to know is how can I know the total of companies "by name" even tho they have multiples licenses. Hopefully I wrote the...

Hi all, hoping somebody can help me with this. I have a big list of organisation names, populating column B. Some of these are companies, some are not. When they are companies, I have provided a relevant company number. However, I have some gaps (as in, the name appears twice in my list, but...

Hello, I'm looking to produce a simple (well I say simple, I've been playing with this for a while and just can't get it right) comparison workbook where I can copy/paste an extract from our own internal systems of company names and unique IDs in one sheet. Then in another I'm entering details...

I have cells in Column O that has a list of important companies. I have a list in column B that has a few hundred companies. I want to make the companies that are in column B highlight if they match an important company from column O. I pasted the data into column O so I can move it around...

Hello all, I have a spreadsheet with a number of companies, each one with 3 specific values that I would like to be able to put in and out of spreadsheets. When I select one of my companies using data validation list I would then like the 3 corresponding values to automatically fill in the...