business

Hello, Can anyone show me how to write a formula that will find the MEDIAN of a group of numbers in one column related to specific criteria in another column? My business segment name data is located in column T and my days open numbers are located in column U. Below is the formula I've...

I've tried every formula I could find online and in Excel help. I have a spreadsheet with many columns. Column B contains business tracks; QTD, ATM, PLM, etc. Column I contains the dates new items where added to the spreadsheet for each business track. Their may be as many items listed for QTD...

Good afternoon, I am attempting to identify mismatched data in Power BI. However, I am totally new to BI and am intimidated by DAX. I have two tables: Table 1 is a list of business IDs, and what item types they are allowed to interact with Table 2 is a list of business IDs, and what items they...

Hello I have mutlipe business lines each with many products listed with revenue show next to them. I want to vlookup from another cell/different tab all business lines and then capture and seum all monthly revenue into a single sell. Identify all the matchting rows: <tbody> Business 2...

Hello folks, I am new to Excel and new to this forum. I am using Excel 2010. I am trying to create a court filing deadline calculator that calculates two different kinds of deadlines. One for business days and one for what I call calendar days. I have been able to figure out how to calculate...

Hi all, I have a table with to Data Validation drop down lists. Business Area Financial Year Budget Name I need to create some sort of cascading drop down list from this table (data is added to this table all the time) <tbody> Business Area Financial Year Budget Name 1 18/19 General 1...

Good Afternoon, I am hoping the kind people of this forum can help me arrive to a solution. I have basic excel knowledge, but what I am trying to achieve is beyond the scope of my current understanding of excel formulas. I need to do what I believe is referred to as a reverse lookup (to...

Hi all, I tried looking for an answer myself (or here), but I just can't get it to work. Hopefully the answer is understandeable for a non-IT guy (finance background)... :-) So the problem: We have about 100 employees working on our payroll and we want to allocate their individual cost to...

Hi, I am used to set up dropdowns from tables. For example I set up a table called TblBU that I fill with all business units. I select then the column without the tiltle (Business Units) and name it BU_List (so it refers to =TblBU[Busuness Units]), which I use as dropdown source. The reason for...

Can you please provide me code for sending message from excel vba to Skype for business below code is not working for me Sub testingskype() Dim aSkype As SKYPE4COMLib.Skype Set aSkype = New SKYPE4COMLib.Skype Dim oChat As Chat Dim skUser As SKYPE4COMLib.User Set skUser =...

I have a calendar table with a column WorkingDay that has a 1 for working days and 0 for weekends and holidays. A typical helper column to get business days would be: Business Days from Approval to Dispatch= CALCULATE ( SUMX ( Calendar, Calendar[WorkingDay]...

I'm trying to do follow-ups by calculate 5 business days between two columns and does not want to include holidays for ex: Entered Date 5 day FU 12/17/2018 12/24/2018 (did not include Christmas and weekend) 12/24/2018 1/2/2019 (did not include New Years or...

Hi looking to create a CRM system for our business has anyone got any recommendations? Thanks

Hi there, I'm hoping someone might help. I need to automatically move data from the main worksheet (Detail) to various others, based upon a value in column c. C contains business functions. e.g 1) Finance 2) I.T 3) Marketing ....and so on.... There is a worksheet for each business function -...

Hi friends I have really spend some time to come around my problem, with no succes so far. I got this data set (example) that I'd prefer not to fiddle with (all cells in row 2 is merged to 1 cell, as is row 5): <tbody> A B C D 1 Initial Name Program Admission 2 First year student...

Good Morning World, I am looking for a formula which will look up a range of different value - i.e. Business / Central etc and return the sum of another value in a range of cells relating to that column value.. For Example Look Up value "Business" in Column C - Range C1:C400 and then return...

I have a spreadsheet with two workbooks as below Book1BCDEFGHIJKL32Period2016/172017/182018/192019/202020/212021/222022/232023/242024/252025/263301 BuildingCost Summary Book1OVWACAD2Rail YearDeliveryTotal3Sub-totalConstr.Sub-total42019/2036,450.00250,000.00337,500.00373,950.00Business Plan...

Hi, Struggling to save an excel file with the following file name: "20181018 ALEX - Data.xlsx". I have the below code but the application.workday function doesnt seem to be working. Any ideas how to get around this? File name should be yesterday's business date and then ALEX - Data...

Hello, I have a column with YYYYMM in it. I am able to split that column into two columns YYYY and MM. What I am trying to do is figure out what the 5th business day of each month is. Column C holds the results I am looking for. I want to exclude weekends and holidays from the calculation...

Hi, I am relatively new to excel vba and I am currently trying to resolve an issue. I have been asked to generate an excel file with randomly assigned quarters to a business unit. There are 11 business units and 11 quarters in scope - the end result being a distinct quarter for each business...