Just need a tweak on countif formula....due to space

[SuzyQPA2]

Excel Workbook
	A	B	C	D
1	Plan Per IBX	Plan per system	Match Plan	*
2	DIRECTPOS	KEYSTONE DIRECT POS FT	FALSE	not working
3	HMO HIGH	KEYSTONE HMO HIGH FT	TRUE	working
Sheet2

 

[Scott Huish]

Excel Workbook
	A	B	C
1	Plan Per IBX	Plan per system	Match Plan
2	DIRECTPOS	KEYSTONE DIRECT POS FT	TRUE
3	HMO HIGH	KEYSTONE HMO HIGH FT	TRUE
Sheet1

 

[SuzyQPA2]

Works like a charm....
can it allow for this as well or am i expecting too much? LOL

PERSCH PPO PERSONAL CHOICE FT FALSE

 

[Scott Huish]

What are both parts you are comparing?

 

[SuzyQPA2]

I actually resolved that problem with a find and replace.....not ideal but it worked since i couldn't make the wildcards work.

Here is my new similar wildcard problem....I am seeing a lot of variation on what is coming from the system.
They call it Fulltime, Fulltime-Regular,Fulltime-Temporary,i expect i'll see Full-time at some point etc....

I had to do 2 columns, one to give me FT/PT and the other to match....
if you could simplify to one column w/a variable (can you tell i'm not that great at those?)
that would be great...
I kept trying to get a formula to work with wildcards of full* and it wouldn't go.

Excel Workbook
	A	B	C	D
1	plan	EE status var	extra column I had to create	match
2	KEYSTONE POS FT	Fulltime-Regular	FT	TRUE
3	KEYSTONE HMO LOW FT	Fulltime-Regular	FT	TRUE
4	KEYSTONE HMO LOW FT	Fulltime-Regular	FT	TRUE
5	KEYSTONE HMO LOW FT	Fulltime-Regular	FT	TRUE
6	KEYSTONE HMO LOW FT	Fulltime-Regular	FT	TRUE
7	KEYSTONE POS PT	Parttime-Regular	PT	TRUE
8	KEYSTONE POS FT	Parttime-Regular	PT	FALSE
9	KEYSTONE POS FT	FulltimeRegular	FT	TRUE
10	KEYSTONE HMO LOW FT	FulltimeRegular	FT	TRUE
11	AMERIHEALTH HMO HIGH FT	Fulltime-Regular	FT	TRUE
12	AMERIHEALTH HMO HIGH FT	Fulltime-Temporary	FT	TRUE
Sheet2

 

[Scott Huish]

You don't need an extra column and you don't need wildcards:

Excel Workbook
	A	B	C
1	KEYSTONE POS FT	Fulltime-Regular	TRUE
2	KEYSTONE HMO LOW FT	Fulltime-Regular	TRUE
3	KEYSTONE HMO LOW FT	Fulltime-Regular	TRUE
4	KEYSTONE HMO LOW FT	Fulltime-Regular	TRUE
5	KEYSTONE HMO LOW FT	Fulltime-Regular	TRUE
6	KEYSTONE POS PT	Parttime-Regular	FALSE
7	KEYSTONE POS FT	Parttime-Regular	FALSE
8	KEYSTONE POS FT	FulltimeRegular	TRUE
9	KEYSTONE HMO LOW FT	FulltimeRegular	TRUE
10	AMERIHEALTH HMO HIGH FT	Fulltime-Regular	TRUE
11	AMERIHEALTH HMO HIGH FT	Full-time-Temporary	TRUE
Sheet1

 

[SuzyQPA2]

cell c6 should be true - PT and parttime are a match

 

[Scott Huish]

I thought you were checking for fulltime.

What's the difference between your example row 7 and row 8?

 

[Scott Huish]

Are you looking for the last two letters from column A FT and PT to match its description?

 

[Scott Huish]

Excel Workbook
	A	B	C
1	KEYSTONE POS FT	Fulltime-Regular	TRUE
2	KEYSTONE HMO LOW FT	Fulltime-Regular	TRUE
3	KEYSTONE HMO LOW FT	Fulltime-Regular	TRUE
4	KEYSTONE HMO LOW FT	Fulltime-Regular	TRUE
5	KEYSTONE HMO LOW FT	Fulltime-Regular	TRUE
6	KEYSTONE POS PT	Parttime-Regular	TRUE
7	KEYSTONE POS FT	Parttime-Regular	FALSE
8	KEYSTONE POS FT	FulltimeRegular	TRUE
9	KEYSTONE HMO LOW FT	FulltimeRegular	TRUE
10	AMERIHEALTH HMO HIGH FT	Fulltime-Regular	TRUE
11	AMERIHEALTH HMO HIGH FT	Full-time-Temporary	TRUE
Sheet1