I have been using computers for about 16 years, never used excel or similar software, maybe once. So my excel knowledge is 0. Maybe what I'm about to ask is easy maybe not. The first part of the question is:
I have a big excel file, which I'm editing in Gnumeric, and I also have kingsoft office, which looks like this
I'm interrested in cloumn D, E, F, G, H, I
. Each rank represents a sequence.
3,4,6,12,16,19
is a sequence. 1,6,21,24,38,42
is another sequence.
I want to compare these sequences and see if there's a sequence repeated more than once. Order doesn't matter. for instance 3,4,6,12,16,19
is the same sequence as 19,4,6,12,16,3
, it's a duplicate.
I want to represent them in a chart which highlights the duplicates and if possible the dates when the duplicate sequence was created. The dates are in coloumn B
and C
.
I'm running Xubuntu 14.04 64 bit.
- I don't care about the tool used, maybe I have to download another software or use a web service or maybe it could be down with Gnumeric.
- I'd prefer if the final result including the chart can be exported to something like XML because I still have to sort it, using python, it's the second part of the question, I won't ask about it now, I don't want to make the question more complicated. I just want the result to be in a file that can be easily manipulated using programming languages.
- The tool used must be free.
- I prefer not to use microsoft software running on Wine, either Linux software or web services.