Thread: How to "hard link" two adjacent cells to a data validation drop down list?
View Single Post
 
Old 10-19-2012, 11:56 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Quote:
Originally Posted by Geza59 View Post
Pecoflyer:

Thank you for the array version, it works. Would you please, explain to me what is the advantage of doing this Excel coding with an array? (So, that I will know which one to use in the future.)
Perhaps this link will give you some insight on what array formulas can do.
They do tend to slow things down, though
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote