![]() |
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