Sampling of data using macros

[Sailadarohit]

Book1 (version 3).xlsb
	A	B	C
1	U.ID(Not Unique)	Main ID (Unique)	Priority
2	1	10	High
3	1	11	Medium
4	2	12	Medium
5	3	13	Low
6	5	14	High
7	4	15	Low
8	7	16	Medium
9	5	17	High
10	7	18	Medium
11	1	19	Medium
12	2	20	Low
13	8	21	High
14	9	22	Low
15	6	23	Medium
16	5	24	High
17	4	25	Medium
18	2	26	Medium
19	8	27	Low
20	1	28	High
21	6	29	Low
22	9	30	Medium
23	3	31	High
24	6	32	Medium
25	9	33	Medium
26	1	34	Low
27	1	35	High
28	2	36	Low
29	3	37	Medium
30	5	38	High
31	4	39	Medium
32	7	40	Medium
33	5	41	Low
34	7	42	High
35	1	43	Low
36	2	44	Medium
37	8	45	High
38	9	46	Medium
39	6	47	Medium
40	5	48	Low
41	4	49	High
42	2	50	Low
43	8	51	Medium
44	1	52	High
45	6	53	Medium
46	9	54	Medium
47	3	55	Low
48	6	56	High
49	9	57	Low
Sheet1

There is a use case where we have U.ID which is not unique, main ID which is unique and priority which covers high, medium and low. In a general scenerio we have mutiple Main ID's associated with one U.ID . For audit purpose we require a sample of this data which will have only 3 random main ID's (not top 3) associated with each U.ID.
Please note in real scenario this is a huge data set so manually doing this is not possible.
Can anyone help with a macro for this as we have more than 5 lakh rows to process and formulas are not working stating error message "excel ran out of resources while attempting to calculate"

 

[Peter_SSs]

Duplicate to: Sampling of data using formula or macros

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.