Thread: [Solved] Formula Help
View Single Post
 
Old 10-19-2017, 04:07 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
How is row 9 in your example a duplicate of row 8?

I think you could use:

=C2+COUNTIFS($C$1:$C1,$C2,$D$1:$D1,$D2)*0.3
Reply With Quote