Countif dynamic range and data validation

[rob nobel]

I use this in Data Validation to stop duplication of data.
=1=(COUNTIF($H$5:$H$38,H17)
How can this be amended for a two column range. That is, the validation
should also refer to COUNTIF($B$5:$B$38,H17))?
Rob

 

[Jim]

Select H17 and Data>Validation>Setting>Allow>Custom =COUNTIF(B5:B38,H17)>1

 

[Dave Peterson]

Just add them up:
=1=(COUNTIF($H$5:$H$38,H17)+COUNTIF($B$5:$B$38,H17))

 

[rob nobel]

Thanks Dave, I did figure this out but couldn't withdraw the post in time.
I tried that initually and it didn't work. I tried it again after sending
the post and it did. Musta had a gremlin in the works!
Rob

 

[Dave Peterson]

I blame the loose nut behind the wheel--oh, wait, that's me when I'm driving!