|
|
#1
05-12-2015, 02:04 AM
|
||||
|
||||
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 
|
| Tags |
| microsoft excel, vba code |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 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 |
|
Using COMPARE to compare more than two variables
|
Wyskers | Word | 1 | 12-03-2011 01:37 AM |
|
Compare data in different columns in an Excel sheet
|
kgfendi | Excel | 5 | 05-16-2009 05:42 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode