Hi,
I am new to excel Formulas. I want to solve this problem
1. There are two tabs in the spreadsheet.
a. Report Tab and
b. Data Tab
In the report tab I have this format
<colgroup><col width="281" style="width: 211pt; mso-width-source: userset; mso-width-alt: 9984;">
<col width="210" style="width: 157pt; mso-width-source: userset; mso-width-alt: 7452;">
<tbody>
</tbody>
In the data tab we have
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
I need to create a report in the output tab as follows:
1. Find the work items (Semicolon separated) which does not present in Report tab but are present in the Data tab and which have a "Budget Cat (L1)" of "Local Geo" and Whose account ID matches with GE* patterns
I need to put these Wortkitems in this format 1.Work Item Id
2.Work Item Title (L3) : this is coming from Data tab
I need to achieve this with the help of formulas only. We can use multiple formula but not Excel VBA
Regards
Rajaniesh
I am new to excel Formulas. I want to solve this problem
1. There are two tabs in the spreadsheet.
a. Report Tab and
b. Data Tab
In the report tab I have this format
Project | WorkItemIDs (semicolon separated) |
Project 1 | PRCEMREV;XACEMREV; |
Project 2 | XASCOTBK; |
In the data tab we have
Work Item Id | Budget Cat (L1) | AcntID Cat (L2) | Work Item Title (L3) ACCTID |
PRTECHAC | Top CAT | Giveback | Other Technical Giveback GEON |
X.00789 | Top CAT | ABC | Time Away GEOG |
X.00756 | Top CAT | EFG | TimeAway for projects GEOF |
Y.06001.011 | Local Geo | Local Work | Time doing local-geo work GEOM |
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
I need to create a report in the output tab as follows:
1. Find the work items (Semicolon separated) which does not present in Report tab but are present in the Data tab and which have a "Budget Cat (L1)" of "Local Geo" and Whose account ID matches with GE* patterns
I need to put these Wortkitems in this format 1.Work Item Id
2.Work Item Title (L3) : this is coming from Data tab
I need to achieve this with the help of formulas only. We can use multiple formula but not Excel VBA
Regards
Rajaniesh