Thanks for the answer.I think i confused you with my question.Let me make it more clear.My excel sheet has coloumn A with Alphabets A to Z.(these alphabets are repeated several times) Colummn B ignore (some non required data) Coloumn C has some numbers. Coloumn D has time 0000,0030,0100,0130...till 2330.(these alphabets are repeated several times)
Total of 65000 rows. I need to create a matrix so that the output is a array with dimension P[26,49]. I wanted to add value in column C,if column A and Column D in a row are equal to another row with same value for coloumn A and D in the entire excel sheets.I used '3' for loops to create matrix P[26,49]