Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Correction
Can you help me correct this formula.
=IF(New_Table!D2=TRIM(SUBSTITUTE(A1,MID(A1,MIN(FIN D({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),SUM(LEN( A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},"")))),"") )"LT","Part Time, or Temp Student",IF(New_Table!D2="DLT"=TRIM(SUBSTITUTE(A1, MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"01234567 89")),SUM(LEN(A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},"")))),"") ),"Part-Time or Temp Student","Regular Full Time Student")) Assume the contents of Column A1 has a 2 - 3 character letter code along with a 4 digit number. The trim function works correctly to get rid of the number and leaves only the letters. I then need to combine with an if statement to get the results I need posted in the correct column. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula correction in multiple workbooks | Excel Discussion (Misc queries) | |||
correction | Excel Discussion (Misc queries) | |||
correction of formula please............ | Excel Worksheet Functions | |||
Formula correction HELP!!! | Excel Worksheet Functions | |||
formula correction | Excel Worksheet Functions |