Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Acowaz

    Excel Cell Help Needed

    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...
  2. Acowaz

    EXCEL MASS DELETE

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

    EXCEL MASS DELETE

    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...
  4. Acowaz

    Excel Notify Duplicate Data

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

    Excel Notify Duplicate Data

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

    Excel Notify Duplicate Data

    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...
  7. Acowaz

    Excel - adding parenthesis

    Thanks Bowers74. It works great.
  8. Acowaz

    Excel - adding parenthesis

    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.
  9. Acowaz

    EXCEL - column

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

    EXCEL - column

    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...
  11. Acowaz

    Excel - Duplicate Data

    Thanks VBONLY. I like those both methods.
  12. Acowaz

    Excel - Duplicate Data

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

    Excel - Duplicate Data

    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...

Part and Inventory Search

Back
Top