Skipping blank and plotting remaining

Hello Friends

Please find the attached 2010 excel file <Skipping blank and plotting remaining 121015.xlsx>

I want to skipping the blank in the cells A2:C151 and plotting in the light yellow cells by formula.

thanks in advance

thilag.

See attached for one way of accomplishing this.

BSB

I am not sure what you mean by plotting by formula. Use the standard plot functions under "Insert" (?)

The attached lists the non=blank data.

=IFERROR(INDEX($A$2:$A$151,SMALL(IF($A$2:$A$151<>"",ROW($A$2:$A$151)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

Entered with Ctrl+Shift+Enter

Change INDEX to ranges B & C for Letter & Number

Hello BSB & JohnTopley

thanks for your formulas.

thanks again thilag