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 MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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.- Prunus
- Post #3
- Forum: -Engineering spreadsheets
-
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...- Prunus
- Thread
- Replies: 2
- Forum: -Engineering spreadsheets
