#1
|
|||
|
|||
Lookup problem for data input
Visitor Survey problem with data entry.
For each observation Data variables have been imputed and listed for each observation (or respondents). I would like to create a record (value 1) in the table parallel for each variable. I have inputted the first two rows to show the intended output. I have over a 1,000 rows of data so this will save some time. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Brilliant, thanks
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trying to input data from columns in cell | gregjordan38 | Excel | 3 | 07-31-2013 02:57 AM |
how to input data vertically in spreadsheet? | mikehende | Excel | 3 | 10-10-2012 11:40 PM |
Data input in Powerpoint? | DeeDubb | PowerPoint | 1 | 04-05-2012 01:53 AM |
lookup dates and return corresponding data | newton.rogers | Excel | 7 | 08-15-2011 11:50 AM |
Lookup a value from non-sorted data | udea | Excel | 12 | 04-25-2011 04:34 AM |