Return value(s) based on selected checkboxes

[Nikki]

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

 

[Guest]

Try this entered with Ctrl+Shift+Enter

in W25:

=IF(COUNTIF($U$26:$U$43,TRUE)>=ROW(A1),SMALL(IF($U$26:$U$43=TRUE,($T$26:$T$43)*($U$26:$U$43),""),ROW(A1)))

Copy down.

 

[Guest]

Minor correction ....

=IF(COUNTIF($U$26:$U$43,TRUE)>=ROW(A1),SMALL(IF($U$26:$U$43=TRUE,($T$26:$T$43)*($U$26:$U$43),""),ROW(A1)),"")

 

[Nikki]

Minor correction ....

=IF(COUNTIF($U$26:$U$43,TRUE)>=ROW(A1),SMALL(IF($U$26:$U$43=TRUE,($T$26:$T$­43)*($U$26:$U$43),""),ROW(A1)),"")







- Show quoted text -

They are even returned in numerical order, Thank you very much!

Nikki

 

[T. Valko]

You can reduce that to (still array entered):

=IF(COUNTIF($U$26:$U$43,TRUE)>=ROW(A1),SMALL(IF($U$26:$U$43,$T$26:$T$43),ROW(A1)),"")

Biff

 

[Nikki]

You can reduce that to (still array entered):

=IF(COUNTIF($U$26:$U$43,TRUE)>=ROW(A1),SMALL(IF($U$26:$U$43,$T$26:$T$43),RO­W(A1)),"")

Biff






- Show quoted text -

Thanks Biff, Works great!!

Nikki