identify a project that has only one estimate across multiple columns

J

jaggy

I have the title of projects in column G, columns H thru V will have estimates by teams. I am looking to identify which projects (col G) have only one estimate across all teams (col H thru V). It's there a way to do this?

Thanks in advance
Jaggy
 
C

Claus Busch

Hi,

Am Tue, 13 Jan 2015 22:27:40 -0800 (PST) schrieb jaggy:
I have the title of projects in column G, columns H thru V will have estimates by teams. I am looking to identify which projects (col G) have only one estimate across all teams (col H thru V). It's there a way to do this?

select G1:Vn => Conditional Formatting => New Rule => Formula to
determinate.....
=COUNTA($H1:$V1)=1


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top