identify a project that has only one estimate across multiple columns

  • Thread starter Thread starter jaggy
  • Start date Start date
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
 
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?
Click to expand...

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


Regards
Claus B.
 
Back
Top