to extract the same four number but in different order from the same set of data

[Harrold]

Hi

How am i able to extract all number in different orders in a set of data? say if i click 1000 then, i am also able to see 0001,0010 and 0100 if available. & its number of occurence for the total of these numbers. The other info available is the date.

Thanks

[Harrold]

can someone please help?

Thanks

[scottylad2]

Ok, you might need to convert to text to keep your leading zeros. But try this, set out your data in A1:A4. In B1:B4 do = Rand() which will generate a 7 digit number between 0 and 1
In C1:C1000, =Index(A$1:A$4,Large((B$1:B$4,randbetween(1,4)))

That will simulate what ylu require, 1000 random generated clicks. Then copy and past values only with your C column and use the countif with your contents of celks A1:A4 as criteria.

[zbor]

Can you upload example workbook with your inputs and desired output?

[Harrold]

Hi

Please find attached a copy of my data. Columns A to C are raw data while columns F & G are pivot table.

What i would like to achieve is, the number of occurrence of the same numbers which also includes its permutation & combination eg in different orders. For examples, 3991 occured in 3rd September. I would like to find out whether the same number and its permutation & combination like 3919,3199,9391, etc to be shown also in other date and its number of occurrence.

Thanks

[zbor]

Is this what you want?

[Harrold]

Hi Zbor,

Thanks for your answer. After posting the thread and viewing your reply, i realise that my requirement is more complex than what i initially thought. As such, i posted the same question to Programming forum.

http://www.excelforum.com/excel-prog...t-of-data.html

Thanks again ;-)