Thanks Ken.. for your reply.As you have written two option , what i want to ask is
Compare A1 to each cell in B1:B100, then A2 to each cell in B1:B100, then A3 to each cell in B1:B100, right down to A100 to each cell in B1:B100, simultaneously i want to delete the matched cell from one column...
Dear Friends
What shall i do to two compare each cell on a column with each cell of another column. Also the cell has same data then i want to delete the data from one column.
Thanks
Ajay
Dear,
I have an spread sheet. In this there is colunm where it it written 'Yes', 'No' & 'spaces'
I want to count number of yes and number of no and number of not written means spaces.
Can anyone suggest me what fuction i should use to get my answer.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.