View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nikki Nikki is offline
external usenet poster
 
Posts: 24
Default Return value(s) based on selected checkboxes

Hello Everyone,

I seem to have come across another problem I cannot figure out how to
solve in Excel.

In column T, rows 26:43, I have certain "Slice Thicknesses", values
ranging from 0.5 to 10, no real method to the madness of the intervals
between numbers-- (0.5, 0.625, 1, 1.25, 1.5, 2, 2.5, 3, 3.75, 4, 5, 6,
7, 7.5, 8, 9, 10). T44 is "Other".

In column U, rows 26:44, is the TRUE/FALSE result from checkboxes of
the user filled worksheet, corresponding to the slice thicknesses
available.

I would like to return, in a single cell (ideally), or array of cells
starting at W25, the slice thicknesses available - all the values that
return TRUE. If in a single cell, a string value with the thicknesses
available separated by ",".

For now, we can ignore the "Other" option, I'll brainstorm how to
conquer that particular problem later.

A note: it is possible to have all the given slice thicknesses, as
well as any combination, or even just one or two selected.

Any help is appreciated,
Thank you in advance!

Nikki