Advertisement
Guest User

Untitled

a guest
Jul 25th, 2014
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. =IF(ISTEXT(Sheet1!A2), Sheet1!A2, "")
  2.  
  3. = IFERROR( INDEX(INDIRECT("EsZkouska");
  4. SMALL(IF((INDEX(INDIRECT("EsZkouska");;1‌​;1)="ČSN721180")*(INDEX(INDIRECT("EsZkouska");;9;1)="RC_P_B");
  5. ROW(INDIRECT"EsZkouska"))-MIN(ROW(INDIRECT("EsZkouska")))+1;"");1);17;1);"")
  6.  
  7. {=IF(RC_P_B<>""; RC_P_B;"---")}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement