I have large data base which needs to be sorted out.
1st Column is fixed with each cell having equal interval 10, 20, 30... And 2nd Column is having variable with colours Yellow and Red at random interval.
Sorting is required only for any one colour (For example Yellow, then in Coloumn (C3) & (C4) it should return 20(in C3) -40 (in C4), 80(in C3) -130 (in C4).
Solved by I. C. in 21 mins