Comparing cell content

C

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
 
F

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
 
Top