Microsoft Office Forums Kutools

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2019, 06:50 AM
Ahmedfares Ahmedfares is offline Kutools Windows 10 Kutools Office 2016
Novice
Kutools
 
Join Date: Mar 2019
Posts: 2
Ahmedfares is on a distinguished road
Default Kutools

Hi
I have kutools programme and I need to range multi cells to match each other,
Is there a way to do this using KUtools or anything else?



for e.g. ( first Colom is serial numbers, second Colom is random numbers)
how can I range random numbers in second Colom to match with same number in first Colom by one click?
thank you
Reply With Quote
  #2  
Old 03-14-2019, 09:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Kutools Windows 7 64bit Kutools Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,396
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please post a sample file with some data and expected results. Thanks
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 03-17-2019, 06:27 AM
Ahmedfares Ahmedfares is offline Kutools Windows 10 Kutools Office 2016
Novice
Kutools
 
Join Date: Mar 2019
Posts: 2
Ahmedfares is on a distinguished road
Default

If you have two lists in a sheet, and both of them have same value but in different order, how can you sort one list to match another list as below :

A column B column
E2. Bb4
D6. E2
Bb4. D6

Thank you
Note :sorry for I canít attach file from my phon
Reply With Quote
  #4  
Old 03-20-2019, 10:17 AM
jolivanes jolivanes is offline Kutools Windows 10 Kutools Office 2013
Advanced Beginner
 
Join Date: Sep 2011
Posts: 86
jolivanes will become famous soon enough
Default

What about the values that don't match?
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -7. The time now is 01:46 PM.


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