Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross 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. Prunus

    Excel indirect address question

    Thank you very, very much mrgoldthorpe. I had made an elementary mistake in my calculations as I had wrote =SUM(INDIRECT(C1:C6)) which was not obviously working.
  2. Prunus

    Excel indirect address question

    Hi A really basic Excel question: I have a complicated sheet with a lot of data and calculations. A function extracts from the data a position where certain rules are fulfilled. The output of the function is in first cell the address where these rules were OK first time and in second cell the...
Back
Top