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

Return value(s) based on selected checkboxes
 

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.

"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

Return value(s) based on selected checkboxes
 

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)),"")

"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),""),ROW (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

Return value(s) based on selected checkboxes
 

On May 3, 11:02 am, Toppers wrote:
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 -

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

Nikki

Return value(s) based on selected checkboxes
 

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

"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),""),ROW (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),""),ROW (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

Return value(s) based on selected checkboxes
 

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