Compare relative value with respect to specific column

PRA007 · #1 01-21-2016, 01:17 AM

I asked this a year ago and is the only question still waiting fro reply.
https://www.msofficeforums.com/excel...e-arrange.html

I want to make little bit easier this time.

I want to compare value of any column with respect to specific column.

for example I have This.

Code:

10.0    10.1
10.2    12.4
10.4    13.5
10.6    14.4
10.8    
11.0    
11.2    
11.4    
11.6    
11.8    
12.0    
12.2    
12.4    
12.6    
12.8    
13.0    
13.2    
13.4    
13.6    
13.8    
14.0    
14.2    
14.4

Want to convert it to this.

Code:

10.0    10.1
10.2    
10.4    
10.6    
10.8    
11.0    
11.2    
11.4    
11.6    
11.8    
12.0    
12.2    
12.4    12.4
12.6    
12.8    
13.0    
13.2    
13.4    13.5
13.6    
13.8    
14.0    
14.2    
14.4    14.4

or say this If better feasible

Code:

10.0	10.1	10.1
10.2	12.4	
10.4	13.5	
10.6	14.4	
10.8		
11.0		
11.2		
11.4		
11.6		
11.8		
12.0		
12.2		
12.4		12.4
12.6		
12.8		
13.0		
13.2		
13.4		13.5
13.6		
13.8		
14.0		
14.2		
14.4		14.4

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract data based on pattern with respect to specific column	PRA007	Excel Programming	14	12-04-2015 04:32 AM
Code to Sum Column of Content Control Values In Specific Tables?	warbird	Word VBA	2	07-13-2015 05:44 AM
How to obtain a column total using only specific cells	Jo Freeman	Excel	3	03-20-2015 06:18 AM
Excel copy two numbers between specific column and paste in next sheet	visha_1984	Excel	1	12-26-2014 07:59 PM
Lookup multiple values and compare different scenarios to get a specific result	mws	Excel	5	05-24-2014 04:52 AM