 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
im seriosuly rubbish with computers!
have just typed up 150 questionnaires worth of data into Excel,
one of the questions has yes/no responses and it would appear that in some cells i put a space after the words no or yes... so when putting the data into graphs there are two categories for 'no' etc...anyway i can find the problems quickly or do i have to click on each individual cell until i find it?
cheers
Setting the filter on the table should show you. Select somewhere in the table the on the Data tab hit the Filter button. If that doesn't work you'll need another column which trims the values...
if the yes/no answers are in column A then paste this into the top of another column and then copy paste it all the way down
=IF(A1="no ","pick me","")
You should then quickly see which one is wrong
Or you can press Control F to find and replace data. Type in 'no ' (with a space after the no) and it will find them all. You can then replace them with a 'no' (without the space).
cheers all... you just saved me a good hour i reckon!
Set some validation on the column next time so it only allows values from the list "yes","no" then you can't put in duff values.
if it is only spaces, type =trim(x) where x is the cell in which yes/no is, in the next cell. What this does is remove the spaces after the word., then copy, paste special values to turn the formula into text.