Filtering of data

HELPHELPTHANXS · Jul 29th 2004

How do you filter the worksheet based on 2 conditions: the length of one column for e.g col A and another column
for e.g col K = ""?

Maqbool · Jul 29th 2004

Hello HelpHelpThanx:

What you mean by "LENGTH OF COLUMN".

Regards

Maqbool

gollem · Jul 29th 2004

Hello,

if you want for example that all inputs of column A have to be length 3, you have to use "DATA - VALIDATION - SETTINGS" (after selecting the columns) and here you can determine the text lenght of every cell with an error message if the user doesn't put in for ex. 3 characters.

I don't know if this is the idea.

Gollem

HELPHELPTHANXS · Jul 29th 2004

yes.....Gollem...you are rite....okieokie....i know how to do already thanxs alot!!!

Filtering of data

Participate now!

Share