Take the following example:
clear allName1 = {'Data1','Data2','Data3','Data4'};Data = {6.2,6,3.2,8};CombnsName = nchoosek(Name1,2);CombnsData = nchoosek(Data,2);for i = 1:length(CombnsData); multiplied{i} = CombnsData{i,1}.*CombnsData{i,2};endmultiplied = multiplied';Final = [CombnsName, multiplied];Rankd = sort(cell2mat(multiplied));
Here, Final represents the values gained by multiplying every possible combination of 'Name1'. Now, I'm trying to find a way of changing the order of 'Final' to correspond to the ranking order defined by 'Rankd'. For example the first 'line' of Final should read 'Data2 'Data3' 19.2; and the last 'line' should read 'Data1' Data4' 49.6.
Is there a method for doing this?
Best Answer