Thread: Lookup problem for data input
View Single Post
 
Old 09-22-2015, 03:18 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You could insert:
=COUNTIF($B2:$L2,O$1)
into O2 and copy that across & down to AA10
You can hide 0 results, if you want, either via a custom number format or the worksheet 0 display options.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote