Sorting the results gives the entire list, so if you have 1000 lines you have to go through all of them. In this example after applying the formula, there are 32 distinct patterns, I just want to list the pattern and its frequency only once, e.g.:
0000000 32
1000000 20
and so on. Sorting will list'000000' 32 times then '100000' 20 times, then the next, etc.
Thanks
Hi,
I don't understand your difficulty.
I didn't say to sort the original data
If you've followed my method you will end up in the results column K with (say) 32 unique patterns (with the original columns L:Q) and column R with the frequency. So just sort K:R using column R as the sort key in descending order.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I used "=SUMPRODUCT(--($B$4:$B$318&$C$4:$C$318&$D$4:$D$318&$E$4:$E$318&$F$4:$F$318&$G$4:$G$318=$B$4&C4&D4&E4&F4&G4))" in column 'I' and I sorted the six columns using 'I' the sort key. in the example the pattern in columns L:P is not known.
There are only 64 variations, list them all, then use Richard's or my original suggestion , and you will get what you want, including the sequencesthat have no matches.Originally Posted by shart2k12
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks