stage

Hi everyone, I have an excel problem that I am stuck on, appreciate any help! Goal: To identify the total sum of each company in a specific stage based on a Date criteria. For example: <colgroup><col span="4"></colgroup><tbody> Client Action Date Stage Amount Company A 1/1/2019 1 $100...

Hello everyone! I have a "problem" in a spreadsheet that I believe through VBA I could solve. But I never programmed in VBA, so I have no idea where to start. I have a table with the following information: Project Name, Type, Stage, Value, Adjusted Value. The adjusted value depends on the...

I need to copy the Data from Column E to paste to column variable by stage number (shown in cell E4) + 7. So Stage 1 would paste to Column H, Stage 2 paste to column I, and so on. In addition, it needs to unhide that column before pasting. Any ideas how to do this? Thanks in advance for any...

Hello - I hoping someone can help me with this. I created a macro using the Macro Recorder to sort a column on my spreadsheet by a custom list. CUSTOM LIST: PROJECT CANCELLED STAGE 1 - PI STAGE 2 - RD STAGE 3 - W STAGE 4 - LV STAGE 5 - LD PROJECT COMPLETE VBA CODE...

Allow me to explain. I am a doctoral candidate and my all my raw data will be in the "left most" sheet. I want to clean it in stages, with the data in each stage going into the next sheet. When my chairmen clicks into the sheet I want the explanation of what the stage is to pop up. I would...

I am looking for an excel formula to identify the latest stage of a project. <tbody> A B C D E F G H I J 1 Progress Stages 2 Project Prepare Start 30% 60% 90% Complete Stage 3 Battersby 21/09/2018 22/09/2018 15/12/2018 30% 4 Phillips...

Hello, Hopefully soon can help me. I am trying to work out how to create a formula to make a plan showing when a total process will be finished and also each stage start and finish times. The time for each stage is fixed, but the initial start time may vary and the process in total will span 3...

Hey guys, I have two data sets that I want to combine. Data is currently on two different worksheets. Below is an example of what I am trying to do, but my actual data has more columns for both Opportunity and Contacts. I also have many more rows. <colgroup><col style="text-align...

Greetings, I'm wondering how I'm going to write this formula to solve a problem that occurs every month that takes a lot of time. If L2 contains "stage 1" and M2 "pre-sat" it will show the value from sheet "input c6" ,if L2 contains "stage 2" and M2 "pre sat" it will show input from "sheet...

Hi Everyone, I am trying to calculate my pipeline backwards. I hope I can explain clearly here. The premise is: If I start with 100 USD in my pipeline and I have a win ratio of 20% I will win 20 USD. This 20 USD will move to the next stage (stage A) where there is already another amount...

Hi guys, I need help on this. I would like to tie and record the car's plate number and turn-around-time for each stage but there's a catch. Read on please. For example: 3 person brings their car in for cleaning and drying. Cleaning stage: <tbody> Name Number Plate Time of entry Car 1...

The requirements are that I will send a school an excel spreadsheet so the school can copy and paste a class register into column A and B (first & last name). In column C, I need a stopwatch linked to each cell from rows 1 to 35. This will enable teachers to take scores/times for sports tests...

I have 4 columns <tbody> MAL MQL SAL SQL SQO 1/2/2018 1:20 3/2/2018 3:30 4/27/2018 4.30 </tbody> I have a date that can be used as a reference to when a lead comes into this stage, I need to identify the gaps between the stages that will allow me to identify why a particular stage was not...

Hi, I've been a long-time reader so I owe you all thanks before I even get started! With my data I'm trying to compare two months of data and count the number of users with the following criteria: Created Date takes place in the first of the two months. The Stage was "A" in the first month...

Hi, Really would like some help here. I have several different dates in a row with one primary date i need to match with. The different dates referring to different events and stages. I would like to extract all the column header which has the event if the main date matches in the same row...

Hi, In a pivot table I want to find the number of selected values (i.e. not the actual values themselves) in the Page, Row labels and Column labels filters, respectively. I started out with the row and column filters and those elements of the code still work as expected. Unaware of the lurking...

Hi All - I have a spreadsheet with 2 sheets. Sheet 1 contains various columns, one for part numbers, one for prices, one fordescription, etc. and two columns of cells that are called "stage 1" (call this column A) and "stage 2" (Column B). The cells in last two either have a yes or a no in...

Excel 2007ABCDEFGH1Include/ExcludeParent CASIDDateRegionProduct MappingStageStage 2Relevant (Y/N)2IncludePrivate2015APACCCBidLost3-2016CANLiqMandateDead4TBD2017EMEAFXOppYes52018LATAMLendLostNo62020OthersPaymentechNQOProbably72025USTradeClosed82065Other9IB10Multiple ProductsSheet1...

Hi all, I'm going to try and explain this as well as I can. I have a spread sheet with equipment in column J, sweet type in column H, damage in column O of our damage register. in a separate sheet named Data, I have a list of all the equipment in column A and whether they fit into 1 of 2...

Hello, I need to create a sheet that that will have a general tab for entry, but it would then sort and send an entire row of data to another tab based on the information of one cell. I realize that it is close to a vlookup, but don't know how to make a vlookup to apply to the entire row (not...