Comparing cell content

[Collcat]

How do I select cells that are not in continous order, for the abov
functions

The cells I would like to compare are on different rows and colum
sorrounded by other data.

Thanks

// CoolCa

 

[Frank Kabel]

Hi
not really possible with a simple formula. Your options:
- change your spreadsheet layout. e.g. reference these cells on a
hidden sheet and put them next to each other and use this hidden sheet
for your formula
- create a user defined function (VBA)

I would try the first option