How To Find Highest Value In A Row And Return Column Header

ballpoint · #1 02-23-2018, 10:23 AM

I have a CSV file which is the result of running topic modeling on a series of texts.

Code:

TextID	Topic 1	Topic 2	        Topic 3	Topic 4	Topic 5
Text1        0.013935811	0.013935917	0	0	0.788958907	0
Text2        0	                0.012022536	0	0	0.961937606	0
Text3        0.067361109	0.08958181	0	0	0.822918177	0

The idea is that the algorithm I have extracts a series of topics from the texts and looks at how similar the sampled texts (Text1, Text2, Text3) are to the 'model'. The numbers are odd because there are more topics than this. There are also lots of rows, hence the need of a different solution.

Clearly, this makes it for a difficult reading. Is there a way to look for the highest value in a number of columns within a row and move it to a another column in the row? The idea would be that, if the highest value pertains to Topic 3, a new column would be created in the same row, reading "Topic 3". Does it make any sense? Is this even possible?

I thought so, and this seemed to answer my question, but I can't seem to make it work: https://www.extendoffice.com/documen...umn-title.html

Thanks!

ballpoint · #2 02-23-2018, 11:18 AM

My apologies, the formula works just fine, I am just stupid. Solved!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup dates that are higher than a given one	JFokker	Excel	2	02-15-2018 09:03 AM
Replace a number with one higher	urbandekay	Word	7	03-27-2016 01:41 AM
Tasks with higher priorities	jamiespear	Project	1	02-10-2015 03:29 PM
find and navigation dialogue in Word 2010 and higher	franklekens	Word	3	09-18-2013 10:24 AM
Top of 2nd page higher than 1st	Anne at ppf	Word	7	03-23-2013 07:55 AM