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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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