deal

Hello- I have two pivot tables from different weeks that consist of date, a sales deal name and the value of the deal. I need to see the changes in values on each deal that have occurred from week to week. In the table below, I want to create a formula in a column outside of Pivot Table #1...

Hi I recorded a macro which applies a filter to row 1 of a sheet, then filters data by a specific criteria ie "On Deal." However, when I add a new set of data to that sheet and run the macro, it doesn't work as expected. Can someone please advise how I should amend the code below? The...

Hello, I am doing a masters pool with friends where we are each going to get 1 player. There are 86 players in the masters field and 86 people participating in the deal. How can i match the two randomly?

I have this sheet created by H.R. System , you notice that the data of every employee are scattered at various rows . I can't use these data unless the code of every employee in the same column along with the value belongs to him then I can use pivot table to sum the values for every employee ...

I want to search a cell for a string in a range. If one of the strings within the range is found, I want to use a vlookup to return a value from a grid. How would I do this with VBA? Here is an example of what I want to do (I apologize in advance for the wonky formatting on the bottom grid)...

Hello, everyone here. I hope you're all well. I'm posting this thread looking for help with a few formulas that I've been struggling with and making minimal progress. The formulas I'm needing help with deal with dice rolling and randbetween stuff for a pen and paper role-playing game. Here is...

Good morning, I am working with a sales data table for which I have created the following corresponding Pivot Table fields: 1. customer (company name) 2. deal stage (Lead, Prospect, Qualification, Evaluation, On Hold, POC, Negotiations/Legal, Closed Won, Closed Lost) 3. deal name (internal...

Can you deal with the comments in the attached? https://www.dropbox.com/s/uwuf9nht3snfva1/example%20-%20Copy%20%283%29.xlsx?dl=0

Hey, everyone, I just joined a company a couple of weeks ago and I realized that the department I'm working on has a lot of room for improvement. I don't want to get into details, but we deal with risk management. As we can imagine, we have excel files with hundreds of risks and KRIs that were...

Hi, I have one column with something like the below; A1 £100 deal £200 deal £300 deal In B2 I need to return the value of the cell (depending on what is in A1) Would I use an IF statement? (Cant get it to work) IF A1 = £100 deal then return £100 IF A1 = £200 deal then return £200...

Should be easy. Column "A" has a DUE DATE. Based on the date as of TODAY(). Is it late or not? I can deal with simple true or false. It's just not working.

Book1ABCDEFGHIJKLM1Selection CriteriaRaw Data2RegionAPACDeal...

Hi, I am currently using the vba code below to turn the sentence "Deal capacity over 95%" to red, however, the issue I am facing is that it turns all text in that cell red, not just the statement "Deal capacity over 95%". Is there a way I can stop the whole cell text turning red and just turn...

Any help would be greatly appreciated. I have figured out everything, but there is a slight curveball now. Here is the situation: If the DEAL GROSS is a positive number and FINANCE is a positive, then the max finance Commission that can be awarded 5% of Finance, not to exceed 100...

I have a list of criteria, 1 through, for example, which measures different aspects of a "deal", rates it simply if it is complete or completed accurately or not. The criteria list will be weighted based on importance. Not all the criteria will be applicable. so either 1, 0, or N\A with final...

Hi, In column "G", Rows 7 - 2,000 there are mainly numbers, but some text. Many cells show as 0 (ie zero), and I would like to delete these. I have over a hundred sheets to deal with. The workbook I have been given is over 6 Mb. How do I loop through each worksheet and also loop through each...

Hi, I am currently working on a portfolio analysis model where I need to do a specific operation on multiple selected deals. My goal here is to be able to run the CALCULATE() on more than one selection. Currently I can do it with one selection in my slicer using the VALUES() formula. It...