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 TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. blondwitch

    slow sheet

    I have a lot of data in it, but I did not have any problem untill today when I was copying adding removing sheets. Suddenly it became very slow, so after entering each cell I have to wait like 2 seconds to go to another cell. Any tips? Thanx!
  2. blondwitch

    a simple question: the reference of a cell

    Great! Thanx!!!
  3. blondwitch

    a simple question: the reference of a cell

    Ok I found it. But now why this does not work: If: =ADDRESS(Match(32,A:A),1,4,TRUE) returns the 'A13' and =Offset(A13,1,0,1,1) returns the value of the cell A14, why does =Offset(ADDRESS(Match(32,A:A),1,4,TRUE),1,0,1,1) does not return the value of the cell A14???
  4. blondwitch

    a simple question: the reference of a cell

    My problem is that it returns the reference in form $D$15 when I need it only D15. Is there any cure?
  5. blondwitch

    a simple question: the reference of a cell

    I am not very good with excel... Looking for a command that would search for a given value in a column and return a reference (in a form C32 for. eg.) of the cell that value is in. How can i do that?

Part and Inventory Search

Back
Top