Search results for query: *

I would like to know if it is possible to protect an individual cell or column in excel? Basically, i would like for others to be able to enter figures in certain columns but i do not want anyone to alter the formulas in other cells. I tried doing Format = protect but that just didn't work. ANy...

Thanks to Carrr & Eric. J-walk is more automated than filtering but both got the job done. Thanks again!

Excel question: I have used the formula in a database =if(d1-d2, 0, 1). I am able to view the duplicates because they are 0's but is there a way to do a mass deletion. But is it possible for it to delete the entire row based upon the zero. The database contains over 10,000 items therefore...

I am pasting the 2nd block under the 1st.

I am using Excel. I am merging them by just copy & paste together.

I'll try not to be too confusing. [ponder] I have two inventory databases, A & B. I am merging Database B(updated database) into A. Once merged, is there a formula that will tell me which info is from "B" and which is from "A." I know "B" will have duplicate data...

Thanks Bowers74. It works great.

I need help in adding parenthesis in a column. I need to keep the text in column A but add the parenthesis around the current text. Any help is appreciated.

Thanks to all of you! That works! The proper worked great.

I am looking for a formula that can be used in a column. Currenly, I have a column that the text is all uppercase. Is there a formula, that can change the the first letter of the word to uppercase & the rest of the word to be lowercase. Any help you can send me is greatly appreciated! Thanks in...

Thanks VBONLY. I like those both methods.

I forgot to mention spreadsheet two is slightly different. With very few variations from spreadsheet. thanks again Aco

I need help in trying to figure out how to merge two excel sheets. I have two databases both are exactly the same. One is in excel & once you copy the second database into excel. I want it to tell me which entry is duplicate or slightly different? Or even just eliminate that duplicate...