LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darren1o1
 
Posts: n/a
Default To get values into an array

I need a function to check a Column of data and check if it is "Feasible" or
"Unfeasible". In the next column of data the is measurements. I need to get
the measurements of the "Feasible" data into of an array.
Eg.
Column a = Feasible?
Column b = Inductance (Tesla)

Feasible? Inductance (Tesla)
Feasible 1,17621E-06
Feasible 1,59844E-06
Feasible 2,05083E-06
Feasible 2,5937E-06
Feasible 3,16673E-06


Should end up with the inductance values in an array if they are feasible.
Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filling Source Data Array with Decimal Values John Michl Charts and Charting in Excel 6 March 22nd 06 04:17 PM
How to find the largest product of an array of values? ryesworld Excel Worksheet Functions 3 December 2nd 05 06:09 PM
Help with an array function malik641 New Users to Excel 4 June 10th 05 05:09 PM
Array Manipulation [email protected] Excel Worksheet Functions 1 December 22nd 04 10:11 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM


All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"