Finding intersection (Difference) by using excel forumla

[rajaniesh]

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

Project	WorkItemIDs (semicolon separated)
Project 1	PRCEMREV;XACEMREV;
Project 2	XASCOTBK;

<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

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

 

[arthurbr]

Re: URGENT:Finding intersection (Difference) by using excel forumla

Is this some kind of homework?

 

[rajaniesh]

Re: URGENT:Finding intersection (Difference) by using excel forumla

Not exactly sir, but I have not done so much hands on in formulas so it is a big homework for me. May be for you it is a piece of cake.