On May 3, 1:20 pm, "T. Valko" wrote:
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

"Toppers" wrote in message

...



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),""),RO W(A1)),"")

"Toppers" wrote:

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),""),RO W(A1)))

Copy down.

"Nikki" wrote:

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- Hide quoted text -

- Show quoted text -

Thanks Biff, Works great!!

Nikki