LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print a selection based on checked checkboxes Stefan van der Hooft Excel Worksheet Functions 0 May 2nd 07 09:34 AM
Return value based on checkboxes selected -- IF() LOOKUP() William Horton Excel Worksheet Functions 3 April 17th 07 07:56 PM
Return value based on checkboxes selected -- IF() LOOKUP() dq Excel Worksheet Functions 2 April 17th 07 07:48 PM
Multiple CheckBoxes can be selected require additional info if sel Goldenfoot Excel Worksheet Functions 1 April 3rd 07 01:46 PM
Sum Based on Checkboxes Vassago Excel Discussion (Misc queries) 6 August 2nd 06 09:15 PM


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"