Spreadsheet: 682455d1592120600-formula-needed-for-skip-cells-new-microsoft-office-excel-worksheet-2-
Sheet: Sheet1

pass | pass
pass | pass
pass | pass |  | How do I skip cells with "*" value and jump down to next cell ?
pass | pass |  | As you can see from range a1:a25, there was 3 cells with "*" value, which we reduced in column B, I did it manually but how I can do it with a formula ?
* | pass
* | pass
* | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | pass
pass | fail
pass
pass
fail
pass
pass
pass
fail
pass
fail
pass
pass
*
pass
*
*
pass
pass
pass
pass
pass
pass
*
pass
pass
*
*
pass
fail
pass
*
pass
*
pass
pass
*
*
*
pass
pass
pass
*
*
fail
pass
*
pass
*
*
*
*
*
pass
pass
*
*
*
*
*
pass
pass
fail
pass
pass
*
*
pass
pass
*
*
pass
fail
pass
*
*
pass
*
pass
pass
pass
pass
*
*
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
pass
*
pass
fail
*
*
pass
*
pass
pass
pass
pass
*
*
pass
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
fail
pass
pass
pass
fail
*
*
pass
*
*
*
pass
pass
pass
*
pass
pass
*
*
*
pass
pass
pass
*
pass
pass
pass
pass
*
pass
pass
pass
*
*
pass
pass
*
*
pass
pass
*
pass
*
*
pass
*
pass
pass
pass
pass
pass
fail
pass
pass
pass
pass
pass
*
*
*
*
pass
pass
pass
pass
*
pass
*
*
*
pass
pass
fail
pass
*
pass
pass
*
pass
pass
*
pass
pass
pass
pass
pass
pass
*
pass
*
pass
*
pass
*
*
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
*
*
pass
pass
pass
pass
*
*
*
*
*
pass
pass
pass
*
pass
pass
pass
fail
*
*
pass
*
*
pass
*
*
pass
pass
pass
*
*
*
pass
*
*
*
pass
pass
pass
*
*
pass
pass
*
pass
pass
pass
pass
pass
pass
*
*
pass
*
*
*
pass
pass
pass
*
*
pass
pass
*
pass
pass
pass
pass
pass
*
pass
pass
pass
*
pass
pass
pass
pass
*
pass
*
*
pass
pass
*
fail
*
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
*
*
pass
*
pass
fail
pass
pass
*
pass
pass
*
pass
fail
fail
pass
pass
pass
pass
pass
*
pass
fail
*
*
fail
pass
pass
*
fail
*
pass
*
pass
*
pass
*
*
*
pass
pass
pass
pass
pass
fail
pass
pass
fail
fail
*
pass
pass
*
*
*
pass
pass
pass
pass
*
pass
pass
pass
*
pass
*
*
pass
pass
pass
pass
*
*
pass
pass
*
pass
*
pass
fail
pass
pass
pass
pass
*
pass
*
pass
*
pass
*
*
pass
pass
pass
pass
pass
fail
pass
*
pass
pass
pass
fail
*
pass
*
*
*
pass
pass
*
*
*
pass
*
*
pass
pass
pass
pass
pass
pass
fail
pass
*
*
*
*
pass
fail
fail
*
pass
*
*
pass
*
*
*
*
*
pass
*
pass
pass
pass
pass
pass
fail
pass
pass
pass
pass
pass
pass
*
*
*
*
pass
pass
pass
*
*
pass
*
*
pass
*
*
*
pass
pass
*
*
pass
*
*
*
pass
pass
pass
*
*
pass
*
pass
*
*
pass
*
*
pass
pass
pass
pass
fail
pass
*
pass
pass
pass
pass
pass
pass
pass
*
*
*
*
*
*
*
pass
pass
fail
*
pass
pass
*
pass
pass
pass
pass
pass
*
*
*
*
pass
pass
pass
pass
pass
*
*
*
pass
*
pass
*
pass
*
*
*
*
pass
pass
fail
*
fail
pass
pass
*
pass
pass
pass
pass
*
*
*
*
*
*
pass
pass
pass
pass
pass
*
*
pass
pass
pass
pass
pass
pass
pass
*
pass
*
pass
*
pass
pass
pass
*
pass
pass
*
pass
*
*
*
pass
*
*
pass
fail
*
*
pass
fail
fail
pass
*
pass
pass
pass
*
*
*
*
*
*
pass
pass
*
pass
pass
*
*
pass
pass
pass
fail
pass
pass
pass
pass
*
pass
*
pass
*
pass
pass
*
pass
*
pass
*
pass
*
pass
pass
*
pass
fail
pass
*
pass
fail
pass
pass
pass
pass
pass
fail
pass
*
pass
pass
*
*
*
*
*
*
pass
pass
*
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
*
*
pass
*
pass
pass
pass
*
pass
*
pass
*
*
*
pass
*
*
pass
pass
pass
pass
pass
pass
pass
*
*
pass
pass
pass
pass
*
*
*
*
pass
pass
pass
*
*
pass
*
*
pass
pass
*
pass
pass
pass
pass
pass
*
pass
pass
*
*
pass
pass
*
*
pass
pass
pass
*
*
*
*
*
*
pass
pass
pass
pass
pass
pass
fail
pass
*
pass
fail
pass
*
*
*
*
fail
pass
pass
*
*
pass
*
*
pass
pass
pass
pass
pass
pass
pass
pass
*
pass
*
*
*
pass
*
pass
*
pass
pass
pass
*
pass
pass
*
pass
*
pass
*
*
pass
pass
*
*
*
pass
*
*
*
pass
pass
*
pass
pass
*
*
*
*
pass
pass
*
pass
pass
pass
pass
pass
pass
*
pass
pass
*
*
*
pass
pass
pass
pass
pass
*
*
pass
*
pass
*
*
*
pass
*
*
pass
pass
pass
pass
*
pass
pass
*
pass
pass
pass
pass
pass
*
*
*
*
*
pass
pass
pass
*
pass
*
*
*
pass
pass
pass
pass
*
*
fail
*
pass
*
pass
*
pass
pass
*
pass
pass
*
pass
*
pass
*
pass
*
*
*
fail
fail
pass
*
*
pass
pass
*
pass
pass
pass
*
*
*
*
*
*
pass
fail
pass
pass
pass
pass
pass
pass
fail
*
*
pass
fail
pass
pass
*
*
*
*
*
*
pass
pass
*
pass
pass
*
*
pass
pass
pass
*
*
*
pass
*
pass
*
pass
pass
pass
*
pass
pass
fail
pass
pass
pass
pass
*
*
*
*
*
pass
pass
pass
*
pass
fail
fail
pass
pass
*
pass
pass
pass
*
pass
*
*
*
pass
*
pass
pass
*
pass
*
pass
*
*
*
*
pass
*
*
pass
fail
*
*
pass
*
*
fail
pass
pass
pass
*
*
*
*
*
pass
pass
pass
*
pass
*
*
pass
pass
pass
pass
pass
pass
*
*
fail
*
*
*
*
*
pass
*
*
pass
*
pass
*
pass
*
pass
*
*
*
pass
pass
*
pass
pass
pass
pass
pass
pass
*
pass
*
pass
*
pass
*
*
pass
*
*
pass
pass
pass
*
fail
*
*
pass
*
pass
pass
pass
pass
*
pass
*
*
pass
pass
*
pass
pass
*
*
pass
*
fail
*
pass
*
*
pass
pass
pass
*
*
pass
pass
pass
*
*
*
pass
pass
*
*
*
*
*
pass
pass
pass
*
*
pass
*
pass
fail
pass
pass
pass
pass
fail
*
*
*
pass
*
*
pass
pass
pass
*
*
*
*
*
*
pass
*
*
pass
pass
pass
pass
*
*
*
*
*
pass
pass
pass
*
*
*
*
pass
fail
pass
pass
*
*
*
*
pass
fail
pass
pass
pass
pass
pass
*
*
*
*
*
*
pass
pass
*
pass
*
pass
*
pass
*
pass
*
*
*
*
pass
pass
fail
pass
pass
fail
pass
pass
pass
*
pass
pass
pass
pass
pass
*
*
*
*
pass
pass
pass
pass
*
pass
*
*
pass
pass
pass
pass
pass
*
*
*
pass
pass
*
pass
pass
*
*
*
*
*
*
pass
*
pass
pass
pass
*
*
pass
pass
pass
pass
pass
fail
pass
*
pass
pass
*
*
*
*
*
*
*
pass
pass
pass
*
*
fail
*
pass
pass
pass
pass
pass
pass
pass
*
*
pass
pass
*
*
pass
pass
*
pass
*
*
pass
*
*
*
*
*
pass
pass
pass
pass
pass
pass
pass
*
*
*
*
pass
pass
pass
pass
*
*
pass
pass
pass
pass
pass
pass
pass
pass
*
*
pass
*
pass
pass
pass
*
pass
pass
pass
*
*
*
pass
pass
*
*
pass
*
pass
*
*
*
*
*
pass
pass
pass
pass
pass
pass
*
pass
pass
pass
*
pass
*
*
pass
*
pass
*
*
*
pass
*
pass
pass
*
pass
*
*
pass
pass
fail
*
*
pass
pass
pass
pass
*
fail
pass
pass
pass
pass
*
*
*
*
pass
*
fail
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
fail
fail
pass
*
fail
*
pass
pass
pass
pass
*
*
pass
*
*
pass
pass
pass
*
pass
pass
pass
pass
*
*
*
pass
*
*
pass
*
*
*
*
*
pass
*
*
pass
pass
*
*
pass
pass
pass
pass
pass
*
*
pass
fail
fail
pass
pass
pass
pass
*
*
pass
pass
*
*
pass
pass
*
*
pass
pass
*
pass
pass
pass
pass
pass
*
*
pass
pass
*
pass
pass
pass
pass
pass
*
pass
*
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
pass
fail
pass
pass
*
fail
pass
*
*
*
*
*
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
pass
fail
pass
pass
pass
pass
*
pass
pass
fail
pass
pass
pass
*
*
pass
pass
*
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
*
pass
*
pass
fail
pass
*
*
pass
*
pass
pass
pass
pass
*
pass
*
*
pass
pass
pass
pass
pass
fail
pass
pass
pass
*
fail
pass
*
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
*
pass
pass
pass
pass
pass
*
pass
*
pass
fail
fail
pass
pass
pass
pass
pass
fail
*
pass
pass
pass
fail
pass
pass
pass
pass
pass
*
*
pass
fail
pass
pass
pass
pass
*
*
pass
pass
pass
pass
pass
pass
pass
pass
fail
fail
*
*
pass
*
*
*
pass
pass
pass
pass
pass
*
pass
*
pass
pass
pass
pass
*
pass
*
fail
pass
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
*
*
*
pass
pass
pass
*
*
pass
*
*
pass
pass
pass
*
*
pass
pass
pass
*
*
*
pass
*
pass
pass
pass
pass
*
pass
fail
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
fail
pass
pass
pass
*
pass
pass
pass
fail
pass
pass
*
pass
*
*
pass
pass
pass
pass
pass
pass
*
*
pass
pass
pass
pass
pass
pass
pass
*
pass
*
pass
pass
pass
pass
pass
pass
pass
*
*
pass
pass
pass
pass
pass
pass
pass
pass
fail
pass
fail
pass
pass
pass
pass
pass
fail
*
*
pass
*
fail
fail
pass
pass
*
pass
pass
pass
*
pass
pass
fail
pass
pass
pass
pass
pass
*
*
*
pass
fail
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
fail
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
pass
*
*
pass
pass
pass
pass
*
*
pass
pass
*
*
pass
*
pass
pass
pass
pass
pass
pass
pass
*
*
*
pass
pass
pass
pass
pass
pass
pass
*
pass
pass
fail
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
fail
pass
*
*
pass
pass
pass
*
pass
pass
pass
fail
pass
fail
*
*
pass
pass
pass
pass
pass
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
pass
*
*
pass
pass
pass
fail
pass
pass
pass
pass
pass
pass
pass
pass
fail
pass
pass
pass
pass
*
pass
*
pass
pass
fail
pass
pass
pass
pass
pass
pass
*
pass
pass
fail
pass
pass
pass
pass
pass
pass
pass
*
pass
*
pass
pass
pass
pass
*
pass
pass
fail
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
*
pass
pass
*
*
fail
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
fail
pass
pass
pass
pass
pass
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
fail
pass
pass
pass
pass
pass
pass
fail
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
fail
pass
pass
pass
pass
pass
*
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
pass
pass
fail
fail
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
pass
*
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
pass
*
fail
pass
pass
pass
*
pass
pass
pass
pass
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
*
*
fail
fail
fail
fail
fail
fail
fail
*
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
*
*
fail
fail
fail
fail
fail
fail
fail
fail
fail
*
*
fail
fail
fail
fail
fail
fail
*
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
*
fail
fail
fail
fail
fail
fail
fail
fail
fail
*
*
*
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
fail
*
fail
fail
fail
fail
fail
fail