KPI-DATA---EE-Mk2.xlsx

Tom Crowfoot

<div>
Hi Rincewindwizz 
 
Thank you so much - that works a treat &amp;&nbsp;does the job perfectly 
 
Many thanks 
 
Tom
</div>

<div>
<div class="content wysiwyg-content fr-view">
Dear Experts&nbsp;I am building a spreadsheet to track project progress &amp; specifically how long it takes to get from stage 1 to 2 to 3 etc.&nbsp;The data comes from our finance team which shows each individual Invoice - each item has a project ID, invoice date and invoice type (retainer, working fee &amp; completion (i.e. stage 1,2,3). &nbsp;Each project ID can have up to all 3 stages.&nbsp;What I need to be able to do is effectively split out the data (using formulas so it can be reused) to put the corresponding invoice date into different columns dependant upon what invoice type it is so I can build the analysis from there.&nbsp;I have attached an example which I hope helps - there are 2 tabs which shows the input &amp; output. (The output tab uses a ‘unique filter’ to filter each project ID <a href="https://filedb.experts-exchange.com/incoming/2023/09_w39/1624839/KPI-DATA---EE.xlsx" class="fr-file" rel="ugc">KPI DATA - EE.xlsx</a> Can anyone help?&nbsp;
</div>
</div>

KPI-DATA---EE.xlsx


Dear Experts
 
I am building a spreadsheet to track project progress & specifically how long it takes to get from stage 1 to 2 to 3 etc.
 
The data comes from our finance team which shows each individual Invoice - each item has a project ID, invoice date and invoice type (retainer, working fee & completion (i.e. stage 1,2,3).  Each project ID can have up to all 3 stages.
 
What I need to be able to do is effectively split out the data (using formulas so it can be reused) to put the corresponding invoice date into different columns dependant upon what invoice type it is so I can build the analysis from there.
 
I have attached an example which I hope helps - there are 2 tabs which shows the input & output. (The output tab uses a ‘unique filter’ to filter each project ID
KPI DATA - EE.xlsx
Can anyone help?
 

Hi Rincewindwizz

Thank you so much - that works a treat &amp; does the job perfectly

Many thanks

Tom

Transform excel data matching criteria


Dear Experts
 
I am building a spreadsheet to track project progress &amp; specifically how long it takes to get from stage 1 to 2 to 3 etc.
 
The data comes from our finance team which shows each individual Invoice - each item has a project ID, invoice date and invoice type (retainer, working fee &amp; completion (i.e. stage 1,2,3).  Each project ID can have up to all 3 stages.
 
What I need to be able to do is effectively split out the data (using formulas so it can be reused) to put the corresponding invoice date into different columns dependant upon what invoice type it is so I can build the analysis from there.
 
I have attached an example which I hope helps - there are 2 tabs which shows the input &amp; output. (The output tab uses a ‘unique filter’ to filter each project ID
KPI DATA - EE.xlsx
Can anyone help?
 

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.