Thread: How to compare data based on value and re-arrange it
View Single Post
 
Old 05-12-2015, 02:04 AM
PRA007's Avatar
PRA007 PRA007 is offline Windows 7 32bit Office 2010 32bit
Competent Performer
  
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default How to compare data based on value and re-arrange it
Is it possible to compare values in excel based on closeness of + 0.2 and re-arrange values based on match.

For example I have talbe like this.


and want to convert it to table like this.



Hereis the file of raw data to be processed.
https://sites.google.com/site/rtsk20...edirects=0&d=1

Here is the desired file I made manually.
https://sites.google.com/site/rtsk20...edirects=0&d=1
Last edited by PRA007; 05-12-2015 at 10:57 PM. Reason: Uploaded Files
Reply With Quote