business

I know only enough excel to be dangerous these days, and need to sort one column of contact information into separate columns. Business, Contact Name, Title, Address1, Address2, City, State, Zip, Business Phone, Email, etc. This is what it looks like now. Text was extracted from a word...

Hi All, Please help me in extracting hours from two responses given date and time, keep in mind to calculate if response received within business hours. For Ex: [SIZE=2][FONT=arial] * Here, please consider business time starts and ends at 08:00 AM - 05:00 AM * Saturday and Sunday should be...

Hi All, I am trying to build a cash flow forecasting tool. I have revenue that comes into a business on the nth day of certain months - this data is captured on the right hand side of the table below. in the data below as an example, on the (Dynamic Date) 1st of Jan thru Dec the revenue table...

I am trying to build out a waterfall that will count how many customers we have based on what time they became a customer. The plan is to count the account IDs if they are new business and remove them if they have been cancelled. The issue is an account can have numerous opportunities marked as...

I have a file with 3 columns consisting of dates, companynames and costs respectively. I have developed a VBA forecasting model which I want to useon this data. However I want to arrange the data into the form I need,which is 2 columns consisting of months and costs, but with the rows of...

I have a mail merge Excel to word problem. I have designed a business case template that various agents use. Various questions out of a total of 21 have to be answered depending on the agent type. The answers then feed a Word submission final business case document. The issue I'm...

I have a Start Date and Time and I want to add 30 days to it and I want the due to date to come out as Date + 23:59:59. As I have to have it go to the end of the business day.

Need help with a formula that would be a dynamic SUMIF of sorts. I have a dataset of GL codes (XX-XXXX-XXXXX) for which I need to sum amounts based on the values in two columns. The left two segments (7 characters) represent the Business Unit and each Business Unit can have multiple GL Codes...

Hello, I have a spreadsheet with work whereby they want predicted sales figures for each month. The way the spreadsheet is setup at the moment is that we have tabs for each business unit with a list of items each having a column for date and sales figure. What I want to do is have a seperate...

Example: 5/1/18 Sat 5/2/18 Sun 5/3/18 Mon (what formula can extract from 5/3/18 that it's business day 1?; just need "1") Using the same series of dates from above, 5/10/18 would be "6". Thanks in advance.

All, I'm beginning to draw up the plans for a budget model I need to build in about a month and am stuck on a rather large piece of it. Hoping to get your best practice guidance as I'm sure many of you have run through similar projects in the past. Ultimately, I will be holding the full...

Guys, Please can anyone throw some suggestions on the error when the script is run turns the excel file property to read only.

Hi guys, I found myself chasing my own tail at work, and could use some extra input. I'm basically just trying to compare to columns with a condition. There are two variables: - Buildings - 3 to 5 alphanumeric code in a format of 3 or 4 digits, or 3 digits followed by a single letter, or 4...

Hello All, Really need some help! Assume Column A is an Account name and Column B is an email address. Basically, I want something that analyses the email address and compares it to the name of the account in Column A. If the email address contains any word from the Account name in Column A...

Hello Folks , I am working on an excel sheet where in i have business done by staff members for 2 weeks. I have 4 staff members , Need to compare their current month business from last month business. A1 has current month business 120000000 B1 has last month business 100000000 I need a...

Hi All I'm looking for a pointer where to start with this problem. I have two worksheets, sheet1 and sheet2. Sheet1 contains businesses whose credentials are correct. Column A has the businesses Ref No, Columns B-H contain the businesses name and contact details. Sheet2 contains the...

Hey everyone, I hope you are able to help! I am using Excel 2016 + Windows 10. I am trying to merge two web queries which have three common columns (Date, Campaign Name and Ad Group Name) please see below for the tables and desired outcome. I tried doing a full inner but I end duplicating the...

Hello all! I'm new here. So I have a tracking worksheet. I have a date that a client called in column B (Their name is in column A) The calls get assigned and the person to call back, and they will let me know when they reach out. They have two business days to do so. The date returned is...

I am wondering if you can calculate an average over time? By this I mean if I wanted to know an average of a number at the end of each business day for a period of time but that average was from a set start date through the current day. Then, "tomorrow", it would add another day giving a new...

Is it possible to do multiple If Statements for the following: I need a Formula for F3 based on the information from F1 and F2 Example: F1= Business A F2= 5 THEN F3= 1500 F1= Business B F2= 10 THEN F3= 1800 F1= Business C F2= 2 THEN F3= 180 <tbody> A B C D E F 1 Business A Product...