RemoveUndefined`[]`

Command: RemoveUndefined[ <List> ]

RemoveUndefined[<list>] creates a new list in which all of the undefined elements of list have been removed. More

Example 1: See interactivity below

In the spreadsheet, define A1=75, A2=82, A3=79, A4=72, A5=91 and
define A6 through A10 "=0/0" (thus undefined and will have "?" for entries).
Define: Scores=RemoveUndefined[A1:A10].
- At this point, Scores={75,82,79,72,91}.
Click in A6 and type in a number - say "82".
- Automatically the list Scores becomes: Scores={75,82,79,72,91,82}.

Define list1=RemoveUndefined[Sequence[(-1)^i, i, -3, -1, 0.5]]
- This removes the second and fourth element of the sequence which have a non-integer exponent and therefore, are undefined.
- This means list1={-1,1,-1}.

Click in the spreadsheet cells with a "?" and input a value. The list Scores will change as will the Box-and-Whiskers (BoxPlot).

So the RemoveUndefined[] command allows dynamic lists from the spreadsheet!

BoxPlot idea by P.Chandra and solution using RemoveUndefined by Murkle.