truncating formulas that point to several worksheets to a few

W

wolfpacker

I cannot figure out how to take this formula which takes values from multiple
worksheets:

=MIN('1'!H6,'2'!H6,'3'!H6,'4'!H6,'5'!H6,'6'!)

and truncate it to ignore worksheets '3' through '6'):

=MIN('1'!H6,'2'!H6)

all while preserving the ability to increment the row # to ultimately copy
the formula throughout a large spreadsheet. I want to update all formulas
such that the #REF! error when worksheets '3' through '6' are deleted.

Thanks for any advice!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top