Converting and reassigning values.

Hello there,

I apologize if newcomers like myself come out here to ask for what seems to be simple problems, but I've found myself in a little pickle concerning some trouble I'm having with Excel. Any and all help would be greatly appreciated. =D

I work for an audio company and currently creating a database of projects we've been working on. I have thousands of entries to input manually, but require help in converting a select few of them which woulds save me incredible amounts of precious time.

The database includes certain columns divided by 'Title', 'Artist' and 'Record House'. Next to that are individual columns of the 'Record Houses'. I simply input a '0' by default to each rows, but would need to manually assign a '1' when that album has been released by a specific 'Record House'.

I can do, and have been doing, this manually. Looking at my database on paper (we are converting from paper to digital, as we are wasting enormous amounts of space and paper), it seems that I'll be doing this until 2016, if lucky. :P

I was wondering if it were possible to, via formula or 3rd party programming, convert the words in the 'Record House' column and have them directly insert the number '1' instead. Thus, in the end, I'll be able to use thesum formula to have a total number of times a Record House has been used by said artist and album.

For example: I wish to have 'Selected Works 2' assign a '1' to column 'OGM' and column 'Sony'. The same applies to 'Selected Works 3'.

I can't thank you enough for your time.

(I've been doing this work on a Chromebook recently and been using Google Spreadsheet. I'll have the attached file converted via Excel 2007 as soon as I get home later today if that causes any problems to anyone. Gotta love those lightweight chromebooks! :D)

Thank you both very much for your quick response. I very much appreciated your help!

Glenn Kennedy, I don't seem to be able able to see anything different besides the values '1' where the '0's used to be...?

Mazzaropi, I see you added the =SUM formula to calculate the sum of the '1's. However I don't understand what's going on in the red 'Record House' rows you've added...?

After re-reading myself, I fear I've perhaps failed to clarify a few things. My apologies.;

I have a generated list of 'Title', 'Artist' and 'Record House' (about 1000 entries). I've added the 'OGM', 'Sony' and 'Helix' myself in order to separate and eventually sum them all up in the end. My troubles start where I'd like to be able to search the column entitled 'Record House' (column E) for certain words, such as 'Sony' and have it transcribe a '1' in column H (titled Sony). I would do this for every individual Record House, which there are about 25 of.

I apologize if I wasn't being clearer about that. I tend to get lost when explaining myself over issues I don't fully comprehend. :P

Thanks again! =)

It's probably the Google Spreadsheet not showing everything like I'm used to in Excel. Again, I'll wait until I get home to view everything in it's entirely before saying it isn't good. Sorry about that, and thanks for your help.

Thanks for pointing this out.

Very odd. I just rechecked on the exact same column selection. All I get in the bar is a simple '1'. No formula at all.

I'll be leaving work in a few hours. I'm sure it'll be fine once I get on Excel instead.

Thanks for the replies, fellas. I'll let you know how it goes. =D

Eureka! Upon being home and opening up Excel itself, it worked! Thank you!

I do, however, have one small, tiny little extra to ask. :P

I see the formula and believe I understand it.The E$1,$D2 formula states that if what is written in column E1 is found in column D2, then to inscribe it here, directly. Perfect! Here's my little problem, though; How can I make this apply all the rows going down the same column? I tried using the simple drag-to-copy technique like I usually do when using the =SUM formula, but somehow it doesn't work as I thought it should. :/

Again, thank you! :3

Woah, nevermind. It was just being buggy. I got it. I"m sure I"ll have a few other questions, but if not. THANK YOU ALL SO MUCH! :D

I've had to look at these again, even after all this time has passed. I just wanted to say thanks, again. =)