Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2015, 02:04 AM
PRA007's Avatar
PRA007 PRA007 is offline How to compare data based on value and re-arrange it Windows 7 32bit How to compare data based on value and re-arrange it Office 2010 32bit
Competent Performer
How to compare data based on value and re-arrange it
 
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
Reply

Tags
microsoft excel, vba code



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to compare data based on value and re-arrange it Need code to Parse and arrange data based on heading winmaxservices2 Excel Programming 1 01-01-2015 01:04 AM
Retrieving data from data base based on text selection capitala PowerPoint 0 12-10-2014 08:10 AM
Re-Arrange Generated Data flds Excel 4 06-29-2012 08:17 AM
How to compare data based on value and re-arrange it Using COMPARE to compare more than two variables Wyskers Word 1 12-03-2011 01:37 AM
How to compare data based on value and re-arrange it Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft