PDA

View Full Version : Solved: Reorgranize data



username123
11-18-2008, 05:39 PM
I have a worksheet with data looking as follows:

Serial# result1 result2 ... resultn
A
A
A
B
B
B
C
C
C
.
.
.
X
X
X

i want to make these into tables

result1
serial# trial1 trial2 trial3
A
B
C
.
.
.


result2
serial# trial1 trial2 trial3
A
B
C
.
.
.


any ideas on how to do this.

MaximS
11-18-2008, 07:52 PM
check attachment for details i hope that will do the job.

username123
11-19-2008, 11:18 AM
THANKS MaximS!!!

I think this is awesome...it should do the trick.

I really appreciate the help!

username123
11-19-2008, 02:24 PM
Hey MaximS

your unique function is great!

how would i modify that fuction to return the number of each serial number occuring (i.e. 3 for the example in the original post)?


thanks!

MaximS
11-19-2008, 07:55 PM
Try this:

Cells(1,1).Value = UBound(Category)


this should fill "A1" with nuber of unique serial numbers

username123
11-20-2008, 12:53 PM
No, I mean if I want to store the occurrences of each serial number in an array..so the array is like this:


Serial1, 5
Serial2, 3
Serial3, 2
Serial4, 3
Serial5, 3
.
.
.


basically, i want to make the program more usable...so as opposed to each serial number occurring 3 times...if some occur 2 others 4 it will list the trials according to the largest number of occurrences, leaving trial4, etc.. blank if that particular serial number does not have that many trials, i.e:

result1
serial# trial1 trial2 trial3 trial4 trial5
A data data data
B data data data data data
C data data
.
.
.


result2
serial# trial1 trial2 trial3 trial4 trial5
A data data data
B data data data data data
C data data
.
.
.


Do you understand what I am saying

I really appreciate the help...let me know if you need ANYTHING! :)

MaximS
11-20-2008, 01:26 PM
I will look in to this.

username123
11-20-2008, 02:18 PM
Thanks...you are seriously the best!

MaximS
11-22-2008, 12:43 AM
try now this will work no matter how many trials per item (ie A or B) you have.

username123
11-24-2008, 10:12 AM
I will try this out and let you know how it goes. THANK YOU!

username123
11-24-2008, 11:30 AM
works fine...thats for all the help.

i really appreciate it :friends: