Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
extract duplicat values | Excel Discussion (Misc queries) | |||
Extract values off a chart??? | Charts and Charting in Excel | |||
Extract values from formulas | Excel Discussion (Misc queries) | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
How do you extract the top ten values in a table? | Excel Programming |