Thread: Need help counting text into separate columns. Screenshot Included
View Single Post
 
Old 09-04-2014, 11:14 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Looks like you need code...

When J9 is updated increment score
* offset score column by [V55-1]
* offset score row by [IF J9=O2 THEN 0 ELSE 1]

The Excel Programming forum may be able to help you more.

Looks pretty neat though!
Reply With Quote