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:
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.