I'm trying to overcome an issue in Excel that is generated by an output (which creates the .xlsx, but I can't get it fixed in that step even through it would probably be the best option). I'm hoping I could create a script within Excel to fix my issue, however it isn't my forte...
So I have 4 cells in each row that I'm working with, and about 150 rows. Each cell contains a string of values, the first text (letters & numbers) and the other 3 just numbers. The values within each cell are separated by commas (csv in a cell) and each position in the cell equates to the same position in the other 3 cells.
I need a system that looks at the third cell (A3, for example), finds the largest value, takes note of the position of this value in the string, and pulls the values from all four cells for that position and adds them somewhere else (so A1:A4 becomes a single position from the strings in A5:A8)....
Unable to provide the data, but an example could be:
A1: Alpha, Bravo, Charlie, Delta, Echo
A2: 1,2,3,4,5
A3: 4,7,2,5,6
A4: 100,200,300,400,500
In this example, the output would be:
A5: Bravo
A6: 2
A7: 7
A8: 200
Any thoughts?!
So I have 4 cells in each row that I'm working with, and about 150 rows. Each cell contains a string of values, the first text (letters & numbers) and the other 3 just numbers. The values within each cell are separated by commas (csv in a cell) and each position in the cell equates to the same position in the other 3 cells.
I need a system that looks at the third cell (A3, for example), finds the largest value, takes note of the position of this value in the string, and pulls the values from all four cells for that position and adds them somewhere else (so A1:A4 becomes a single position from the strings in A5:A8)....
Unable to provide the data, but an example could be:
A1: Alpha, Bravo, Charlie, Delta, Echo
A2: 1,2,3,4,5
A3: 4,7,2,5,6
A4: 100,200,300,400,500
In this example, the output would be:
A5: Bravo
A6: 2
A7: 7
A8: 200
Any thoughts?!