How to Manage Lottery Results in Excel

[hitherto]

hello.
help me, please !

i have file of lottery results. lottery is from 1 to 45. and there is 5 diferent winning numbers each time and i want that each winning number i can paste accordingly
the number of row or column.


example:
1. i copy lottery results

2 4 7 10 14


2. then i WANT paste this numbers in this way

1|2|3|4|5|6|7|8|9|10|11|12|13|14|15| ....

|_|2|_|4|_|_|7|_|_|10|__|__|__|14|__|


but not in this


1|2|3|4|5|6|7|8|9|10|11|12|13|14|15| ....

2 4 7 10 14


i hope you understand what i mean.



thanks.
This message was edited by hitherto on 2002-08-27 06:47
This message was edited by hitherto on 2002-08-27 06:59

 

[Tommy Bak]

I don't think you can paste this way without macros, but you can use the HLOOKUP-function.
Just write the formula in A2 and copy sidewards and then down

Book5
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
2		2		4		6		8		10				14
3				4	5		7			10			13		15
4
5
6
7
8
9	Results
10	2	4	6	8	10	14
11	4	5	7	10	13	15
12
Sheet1

regards tommy
This message was edited by Tommy Bak on 2002-08-27 13:52