binar
12-04-2016, 02:25 PM
Fellow Forum Members,
I am using Excel 2013 and I have 4 columns (Columns A,B,C,D) of numerical data with 300 rows. Is it possible to perform a row power search for a series of 4 numbers such as 11, 5, 9, 14 on a single row between row 20 and row 120? I know it can be partially done using the filter feature, but I'm curious to know if a VBA script can perform such a row power search in a more direct manner. Any help will be greatly appreciated regarding the development of such a VBA script. And below is a screen capture I hope will better explain the power search capability I am seeking to make happen:
17753
Thanks in advance for any help regarding this matter.
I am using Excel 2013 and I have 4 columns (Columns A,B,C,D) of numerical data with 300 rows. Is it possible to perform a row power search for a series of 4 numbers such as 11, 5, 9, 14 on a single row between row 20 and row 120? I know it can be partially done using the filter feature, but I'm curious to know if a VBA script can perform such a row power search in a more direct manner. Any help will be greatly appreciated regarding the development of such a VBA script. And below is a screen capture I hope will better explain the power search capability I am seeking to make happen:
17753
Thanks in advance for any help regarding this matter.