Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default Random list place in column order.

Hi Everyone

I have a list, A3:I25 that you can select items. The selection is done with
a CheckBox at each items. I would like the items selected to be listed in
column order below the list,ex:A30,31,32 etc.Can you help me, I am not very
good with functions or macro.
Regards
John

  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Random list place in column order.

One play to try .. something along the lines
illustrated in this sample:
http://www.savefile.com/files/1333415
Extract checkbox selections into col.xls

Assume 6 source items are listed in A3:B5, viz:

Item1 Item4
Item2 Item5
Item3 Item6

6 checkboxes are drawn from control toolbox,
with corresponding link cells in E3:F5
(these are set in Properties view.
In design mode, right-click on checkbox choose Properties)

In E10:
=OFFSET($A$3,MOD(ROWS($1:1)-1,3),INT((ROWS($1:1)-1)/3))

In F10:
=IF(OFFSET($E$3,MOD(ROWS($1:1)-1,3),INT((ROWS($1:1)-1)/3)),ROWS($1:1),"")

In G10:
=IF(ROWS($1:1)COUNT($F$10:$F$15),"",SMALL($F$10:$ F$15,ROWS($1:1)))
Select E10:G10, copy down to G15

Then in A10, copied down to A15:
=IF(G10="","",INDEX($E$10:$E$15,G10))

CF is applied to results range A10:A15 using formula is: =A10="",
formatted accordingly to mask with white font/borderless
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote in message
...
Hi Everyone

I have a list, A3:I25 that you can select items. The selection is done
with a CheckBox at each items. I would like the items selected to be
listed in column order below the list,ex:A30,31,32 etc.Can you help me, I
am not very good with functions or macro.
Regards
John



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default Random list place in column order.

I just sent another Request titled " Retrieving data from one form to
another "
Thinking that this request was not clear, please ignore the second request.
Thank you for your reply I will try it and let you know if I can make it
work.
Thanks Again
"Max" wrote in message
...
One play to try .. something along the lines
illustrated in this sample:
http://www.savefile.com/files/1333415
Extract checkbox selections into col.xls

Assume 6 source items are listed in A3:B5, viz:

Item1 Item4
Item2 Item5
Item3 Item6

6 checkboxes are drawn from control toolbox,
with corresponding link cells in E3:F5
(these are set in Properties view.
In design mode, right-click on checkbox choose Properties)

In E10:
=OFFSET($A$3,MOD(ROWS($1:1)-1,3),INT((ROWS($1:1)-1)/3))

In F10:
=IF(OFFSET($E$3,MOD(ROWS($1:1)-1,3),INT((ROWS($1:1)-1)/3)),ROWS($1:1),"")

In G10:
=IF(ROWS($1:1)COUNT($F$10:$F$15),"",SMALL($F$10:$ F$15,ROWS($1:1)))
Select E10:G10, copy down to G15

Then in A10, copied down to A15:
=IF(G10="","",INDEX($E$10:$E$15,G10))

CF is applied to results range A10:A15 using formula is: =A10="",
formatted accordingly to mask with white font/borderless
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote in message
...
Hi Everyone

I have a list, A3:I25 that you can select items. The selection is done
with a CheckBox at each items. I would like the items selected to be
listed in column order below the list,ex:A30,31,32 etc.Can you help me, I
am not very good with functions or macro.
Regards
John




  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default Random list place in column order.

Hi Again
Just to say It works, Thank you Max

"John" wrote in message
...
I just sent another Request titled " Retrieving data from one form to
another "
Thinking that this request was not clear, please ignore the second
request.
Thank you for your reply I will try it and let you know if I can make it
work.
Thanks Again
"Max" wrote in message
...
One play to try .. something along the lines
illustrated in this sample:
http://www.savefile.com/files/1333415
Extract checkbox selections into col.xls

Assume 6 source items are listed in A3:B5, viz:

Item1 Item4
Item2 Item5
Item3 Item6

6 checkboxes are drawn from control toolbox,
with corresponding link cells in E3:F5
(these are set in Properties view.
In design mode, right-click on checkbox choose Properties)

In E10:
=OFFSET($A$3,MOD(ROWS($1:1)-1,3),INT((ROWS($1:1)-1)/3))

In F10:
=IF(OFFSET($E$3,MOD(ROWS($1:1)-1,3),INT((ROWS($1:1)-1)/3)),ROWS($1:1),"")

In G10:
=IF(ROWS($1:1)COUNT($F$10:$F$15),"",SMALL($F$10:$ F$15,ROWS($1:1)))
Select E10:G10, copy down to G15

Then in A10, copied down to A15:
=IF(G10="","",INDEX($E$10:$E$15,G10))

CF is applied to results range A10:A15 using formula is: =A10="",
formatted accordingly to mask with white font/borderless
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote in message
...
Hi Everyone

I have a list, A3:I25 that you can select items. The selection is done
with a CheckBox at each items. I would like the items selected to be
listed in column order below the list,ex:A30,31,32 etc.Can you help me,
I am not very good with functions or macro.
Regards
John





  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Random list place in column order.

Glad to hear that, John.
You're welcome
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote in message
...
Hi Again
Just to say It works, Thank you Max





  #6   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Random list place in column order.

Alternative link:
http://www.freefilehosting.net/download/3b087
Extract checkbox selections into col.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply
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
how do I create and extract a random order from list in Excel? Michael Excel Discussion (Misc queries) 5 August 30th 07 08:02 AM
How do I place items in alphabetical order in a column and keep da Angela33 Excel Worksheet Functions 7 March 16th 07 08:54 PM
extract data from a random list & place in another ordered list sean8690 Excel Discussion (Misc queries) 1 January 2nd 07 07:06 PM
How to sort al list in random order for sampling? NJTom Excel Discussion (Misc queries) 1 September 21st 06 10:50 PM
list names in random order in Excel 2002 John Murf Excel Discussion (Misc queries) 2 February 25th 06 02:58 AM


All times are GMT +1. The time now is 09:16 PM.

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

About Us

"It's about Microsoft Excel"