ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   extract values (https://www.excelbanter.com/excel-programming/297129-extract-values.html)

monika

extract values
 
my columns have values like P-DSO-12-2,P-DSO-20-7,PG-LFBGA-
80-6,P-LFBGA-81-1, PG-LFBGA-81-1, PG-TSSOP-28-1,PG-TSSOP-
28-1...etc..
I have to insert a new row inbetween these columns
wherever the value is fitting the best. Like say for an
example i have to insert a row with value "P-VQFN-64-
1" ...now this shoudl ideally check where "VQFN" is found
(the value after the 1st hyphen) and should be between :=
P-VQFN-56-1 & PG-VQFN-64-4; ie between 56 and 64.

which is the best logic to work it out...
any sugg will be highly appreciated


All times are GMT +1. The time now is 09:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com