Microsoft Office Forums

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
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample file with some data and expected results. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
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: 93
jolivanes will become famous soon enough
Default

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

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 12:13 PM.


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