View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sushil[_3_] Sushil[_3_] is offline
external usenet poster
 
Posts: 1
Default Formula to explain

Can any one please explain this:

=SUM(MID(0&D19,LARGE(IF(ISNUMBER(MID(0&D19,ROW($1: $256),
1)*1),ROW($1:$256),1),ROW($1:$256)),1)*1)*10^(ROW( $1:$256)-1)

Though it was put in and explained by my manager, but I don't
remember.


Thanks in advance.