Probably not the easiest way to do it, but I think for each column, I'd replace the yesses and nos with the appropriate number, and then sort by those columns so I could copy and paste by chunks into one column, and then I'd have one column all with numbers.

...but that's probably not a great way to do it.

I don't have an answer for you, I just wanted to say I really don't understand why databases are not more accepted. I see Excel forced to do things that should be in a DB so often and there's always someone at the top of the chain decreeing that's the way it has to be. I'm sure it's driven by the fact that there's a site license for Office, so just use the tool we have.

Right, next time I need to remove a screw I'm going to do it with a hammer, because I'm sure i can make it happen somehow and it's the tool that we have.

I love databases (I used Filemaker at my last job), but the reason I do things in Excel is that either Excel or Access is available to me, and I don't have the skills to make Access work for other people, or really for me. If I have a list of 100 names and addresses that I someone to be able to do mail merges with, it is just easier to use excel, which the other Admins understand than Access. Filemaker is not supported and activiely discouraged by our IT department. I have one Access database for registration, and they eliminated the Access database support position from IT, and it is so hard to use!

ETA- I would do what meara said (replacing the Y and N with a number, and then doing a search and replace for the number to put in the age range.

Let's say I do a search and replace on Age Range 0-3 to turn all the Y's into "0-3" and a search and replace on Age Range 4-6 to turn those Y's into "4-6" - is there an easy way to convert a row of text values into ONE cell with those values separated by commas?

You can use the CONCATENATE function to do that, Jess.

Eta: or &, that might be easier for a long string. =A1&","&A2&","&A3 etc

Awesome, thanks -t!

See and I was thinking of if statements. Concatenate would work just fine.

I think I have finally beaten the Excel query into submission. Of course my frustration with it spurred me into putting more time in after I had submitted my timesheet, so that will become Saturday time. If the recipients don't like the results, they can stick it.

Yeah, I was thinking IF, too, but without actually seeing the data and how its arranged I'd have a hard time formulating something helpful.

Stick it to the man, Suzi! By working more than you meant to...that'll show 'em.

I purchased a Lacie Cloudbox NAS. Not a RAID system. Just wanted an iTunes server. My computer is consolidating my library on the new 3 TB drive. The progress bar is a thin sliver of green, and it's been nearly 2 hours now. I get the feeling this will be going when I come home from work tomorrow. Now to figure out how to get the AppleTV to see it directly. The Xbox has no problem. We shall see if I can figure it out.

ETA: when I woke up this morning, the progress bar was about pinkie wide. I think it's started on the video stuff now. Which is about a TB worth.