how to to compare of two tcolumns

[#1]

i have two columns  i want to calculate

I want to know how many id1 & Id2 are blank

I want to know how many id1values &id2(blank values)

I want to know how many id1 & Id2 are same

I want to know how many id1(blank values) and id2(values)

for this scenrio i used    count(id1=id2 ,dual(0,1)) , and created flags for id1 and id2 tried so many functions

i attached some sample data ....PFA

[sasiparupudi1]

please post a sample but may be in a new thread?