I dont want few items in Column

[varma8998]

Hi All,

How to write set analysis using Wild Match

table Format Will Be:

Column A  Column B  Column C Column D

AKC           1234           XXXX

BKC            F15B         XXXX

CKC            67AB         XXXXX

DKC           Close         XXXXX

FKC            In              XXXXXX

HKC            Out         XXXX

LKC           >1=<1      XXXX

As you see in column B values is mixed with numbers and alphabets here I want to filter which is not required by using set analysis function

[Wlad_Masi]

Hi @varma8998 ,

What is not required?
Would you be looking to have numbers only? If yes, check this post please
 Check whether the value is number or not 

If not check this please:
How to use wildmatch function in set analysis 
Wildmatch within set analysis. 

I hope it answers your question.