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!

  • Congratulations bkrike 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: *

  • Users: Acowaz
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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.
  5. 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...
  6. 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