spreadsheet mind blooing morning :( newbiew question

[orlando Teixeira 0]

Hello PPL,

i am trying to limit the criteria of an spredsheet.

This is what i got:

"=DATABASE(((L='PISO 0') & (R IN ['Space'])))"

It gives me the Spaces inside my Building , level 0 (PISO 0 - Portuguese)

Now my problem is that i want to remove from that list for example the porch that also as an space area.

Is it possible to remove from the list some or several spaces using the criteria ? i am not achieving it ....

Thx in advanced

[Gerrit 4]

Edit the criteria line to read :

=DATABASE(((L='PISO 0') & ((R IN ['Space']) & ('Space'.'Name'<>'porch'))))

(assuming the unwanted space is named porch)

[orlando Teixeira 0]

Thx Gerrit

It worked Perfectly, nice tip.

[Pat Stanford 647]

If you have multiple areas you want to exclude you could put them in a class and exclude the class something like:

=DATABASE(((L='PISO 0') & ((R IN ['Space']) NOT (C='porch_class'))))

I think both Geritt's and my solutions can be entered through the criteria builder and not have to be done by hand.