company

So I have a simple 2-column table; basically just a list of names where each has a corresponding number. Simply, I want to comb through the list and find things like "| Company A | 5 |" and "| Company A Inc. | 5 |" and combine them. I guess this could turn into "| Company A | 10 |" or "| Company...

I've been toiling with this one for a few hours and have decided to come ask the experts for help. I'm trying to capture the start date associated with a particular company (in sheet 1) from a list of many stages that each company goes through (sheet 2) Sheet 1: unique list of company names...

I have a spreadsheet that contains multiple rows of data for multiple dates and companies. I am looking for a way to show all of the entries for the specified company within a specified date range. For example, I want to see all of the entries for company ABC between 1/1/2019 and 1/5/2019. I...

I have a sheet that lists out all of our customers. I want to create a dropdown list on a separate sheet that only contains the contacts associated with the company name that is indicated. Is this possible?

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...

<colgroup><col><col><col><col><col></colgroup><tbody> Company Contact Company 3M Amina Zimmerman 3M Tamara Phillips Adidas Cayden Myers Adidas Naima Cisneros Adobe Systems Quinton Dunlap Adobe Systems Esther Cochran Apple Inc. Sarah French Apple Inc. Juliette Lucero Avon...

I am curious if anyone could help me. I am looking to add a job number cell on my company dispatch sheet. Is it possible to have an auto generating job number cell that includes a 3 letter prefix for company name plus date and job number? An example would be like this..... 19-ABC-05-001...

Hi all, hoping you can help as I'm a bit lost with this. My data has several columns of information regarding deliveries, the dates they were made and if all the items ordered by the customer were in the delivery. I need a formula to check the data and put a value of "bulk" if a delivery with...

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...

Hi all, I am new to this forum and would love some help. I have a spreadsheet from work I have to fill in loads of data, some cells could be made easier as once I fill in the a column, it means I waould have to fill in a certain word in the c column. My headings are <tbody> Company Home...

Hi Mr Excel, Good afternoon! First of all i would like to thank you for your uploaded video on you tube.i have learnt a lot having watched them. i was know nothing about excel,but your videos lot helped me to understand excel from basic to advance level. i was normal labor in company of...

I’m looking for a way to use a job number in coalescence with a job name for our time sheets. Basically the company we contract under organizes jobs by job number (ex. LP0068435). seeing as we are a much smaller company, our guys don’t care to memorize these numbers. we would just use general...

Hey all, I'm currently working on a private equity report that I want to automate. Ive made a rough draft of what I am looking to do below. Assume the first two columns are manual entry (Company Reporting, 6/30/2011). I want to be assign a macro to a button that, when pressed, will...

Hi there, Not had to write a code like this so have taken a stab in the dark but it's not liking it. Can anyone see where I am going wrong please? When I try to run it, the error highlights the second row of code (If Not Intersect...) The "Entity_Type" is located in cell D8. The "Entity Type"...

I want to find out how many of my company's customers are in the Fortune 500. I have both lists, but am not sure how to compare them. Also, how would I handle common words like "the" or "of?" I guess I could do an exact match, but then I might miss close matches, for example, we might have a...

From the following example data set I would like to count the number of rows where "Company A" and the word "Completed" appear but not counting duplicate values in the first column and ignoring the blanks that might appear in the first column. It is ignoring the blanks I am having difficulties...

I'm trying to design some sort of countif/countifs formula(Sheet 1, Column B) to count the number of clients involved in each job type... -----Sheet 1-----(Column B needs to count the number of individual clients that hired different job types...For Example: Cell B2 should result with 2...

I have a table that looks like this: <tbody> Company Invoice Amount 1 Amount 2 Amount 3 Amount 4 Amount 5 Page Last Page John Q Company 3063615 $ 101 $ 200 $ 25 $ 25 $ 25 1 1 Peter North Company 3063616 $ 999 $ 877 $...

Hello, I am trying to count the number of instances a certain value (Company) is listed in a conditional formatted cell, where the conditions are as follows: if cell value for # of Days <4, highlight cell green; if cell value is between 4 and 9, highlight cell yellow; and if cell value >9...

Hi guys, I have a two-sheet workbook. In the first sheet I have a list of companies (A), and revenue (B). I want to add a third column and to look for the number of cards the company bought for the first time (second sheet). In the second sheet we have (A) companies, (B to AA), number of cards...