Hello,
I want to count the first five number in the list (i.e 1,2,2,3,3) and select alongwith the properties in column C and D of the source table to be entered into another table (Bale) as shown below. Also,to extract the next 6 numbers (i.e 4,7,8,9,10) and its properties in A C and D column of the source table. What function can i use to count the first 5 numbers and pick the corresponding properties required? Thanks
SOURCE TABLE
no A B C D
1 61 6 81 19
2 62 7 98 29
2 66 6 81 39
3 67 8 84 79
3 68 6 86 89
4 67 6 88 59
7 67 6 82 79
8 67 6 8 9
9 67 6 8 9
10 50 7 11 1
Bookmarks