company

Hi, I hope I can explain myself properly to get some assistance here. The below data is on my first tab in excel, and I am trying to gain a understanding of how much Actual Revenue a specific marketing event brought in. <tbody> Marketing Event # of Contact Customer Name Cost...

Hello, I have a quoting system in development. Raising a quote is not a problem. One of the features is that a combobox is displayed when certain cells are clicked upon and at the same time, a predictive search allows for short-cutting to the desired option. For example, when we click the...

I have at the moment a list in Column A; Unit number 124 Company Name What it does web address contact Unit number 127 Company Name What it does web address contact Unit number 145 Company Name What it does web address contact and want... Column 1 Column 2...

I have a list of 8000 Company names and a list of 100 keys words. I want to the company names that contain a key word. For example, if 'Supply' was a keyword and Company name was "Mark Edwards Supply Co" the result should say yes

Hello World! I'm not sure if this is the right section to post this, but I'm needing some help. As of the beginning of July my company opted to ditch Microsoft Office (To cut expenses) and moved to Google. And that ruined a lot of my macros. I have no idea of how to script in google but I've...

Hi and thanks in advance in case anyone can help me find a solution. I am trying to combine an index match with an average if. Attached is a screenshot, and the green cells are supposed to calculate the average P/E ratios depending on the timeframe in B4-D4 (1yr-5yr). So for the 5yr (green cell...

Hello, Hope all are well Hoping you will be able to help me out on this one.. I'm creating supplier / customer database and I'm building "Update" button. Basically I have the table of customers / suppliers and some of them are duplicated. For example I have a company who deals with the...

Hey there, I've got something like this: I need modification to this code: <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Private Sub Worksheet_Activate() Dim a, e a =...

Hi, In Row A, let's say I have a either of the listed: Company A Company B Company C Company D In Row B, let's say I have a either of the listed: Product 1 Product 2 Product 3 Product 4 In Row C, I have a bunch of random prices listed. How can I create a formula where I want the average of...

I'm stumped. Nothing I've tried is working. Worksheet "Clients FY18" is to keep a log of all units reported by month for the whole fiscal year by client and company. However, the entire workbook is designed by month only. As an example, the staff completes their activity for clients they served...

I have a spreadsheet where 2 of the tabs where there is a list of over a thousand customers and the corresponding sales rep. The sales reps have completely changed and I need to make the change on both tabs and want to change on 1 tab and have it automatically pullover to the other tab. So on...

Hello guys, Every month I need to distribute a number of companies to be assessed by diferently graded analysts. This distribution is based on a matrix that attributes authority according to the internal rating/grade that a given company has and also what exposure that company holds. <tbody>...

Hi, Thank you in advance for helping. The company has a revenue sharing contract for 10% of the revenue starting when the company reaches $100,000 per month (month 7) in revenue until all $125,000 of the contracted amount of paid off (month 13) <tbody> Revenue <tbody> $20,947 </tbody>...

Hi everyone, I don't work with Excel much so I have a beginner question here. I have a sheet that constantly pulls in live data every hour or so. There are four columns and column A contains the company name. The sheet has around 200 companies in total with many rows of timestamped data each...

Hi I have a problem that I'm not able to overcome. I have the data as shown below (dataset much larger, but follows the logic below). - Cells A1:C1 are merged, so are D1:F1 and so on - I want to show a graph with Months on the X-axis, and Market Share on the Y-axis, and then different lines...

Hello Excel gurus, I am doing our employee database maintenance between our Payroll Database and NetSuite database. However, I am running into some issues that I need your expert help. The problem I have is our payroll database have employees (without middle name initial) and correct updated...

Hello, On paper, I think this should work. I want to make a formula that if special criteria are met, then a separate formula is calculated based on its own special criteria. If the first criteria is not met then nothing happens. This is what I started with...

I have the following data set for which I need to divide into decile for a particular year and also want to view the banks in a particular deciles. Is It possible to create this on the basis of a calculated column in Power BI. I used a simple Decile formula, but that doesn't work...

hi all. I have a table similar to; <tbody> Lead # Date In Referrer Sales Rep Customer Status 1 1/8/18 Company A AG Joe Blogs Active 2 14/8/18 Company A HB John Citizen Active 3 21/8/18 Company B AG Sherly Gray Dead </tbody> I'm wanting to have sheet 2 display on deals for...