Methods and systems for presenting drop-down, pop-up or other presentation of a multi-value data set in a spreadsheet cell

A device including a processor and memory, the memory loaded with instructions that, when executed, cause the processor to carry out an improved method for applying a spreadsheet function running that operates on values in a list or range of cells the improvement including:

• evaluating the list or range on which an improved spreadsheet function operates and identifying a reference to a first cell;
• returning from the first cell multiple values stored within that cell;
• and
• applying the spreadsheet function to calculate an algebraic or statistical result using the multiple values returned from the first cell, as if they were individual values returned by reference to multiple cells of the spreadsheet.

A tangible computer readable storage media loaded with instructions that, when combined with a hardware device, configures the hardware device to carry out an improved method for applying a spreadsheet function running that operates on values in a list or range of cells the improvement including:

• evaluating the list or range on which an improved spreadsheet function operates and identifying a reference to a first cell;
• returning from the first cell multiple values stored within that cell;
• and
• applying the spreadsheet function to calculate an algebraic or statistical result using the multiple values returned from the first cell, as if they were individual values returned by reference to multiple cells of the spreadsheet.