Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Merge Group Name between two Excel Sheets Merge Group Name between two Excel Sheets
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2017, 09:10 PM
coemaw coemaw is offline Merge Group Name between two Excel Sheets Windows 10 Merge Group Name between two Excel Sheets Office 2010 64bit
Novice
Merge Group Name between two Excel Sheets 		 
Join Date: Feb 2017
Posts: 2
coemaw is on a distinguished road
Smile Merge Group Name between two Excel Sheets
Hi



I have two excel sheets. One sheet includes Group and their respective items. Another sheet shows the items and their quantity. How can I add group name column in second sheet? Group name has to show beside of their respective items in second sheet. Quite noob in excel .. please help.

Reply With Quote
  #2  
Old 02-16-2017, 11:32 PM
xor xor is offline Merge Group Name between two Excel Sheets Windows 10 Merge Group Name between two Excel Sheets Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Like this?
Attached Files
File Type: xlsx Groups.xlsx (23.9 KB, 9 views)
Reply With Quote
  #3  
Old 02-17-2017, 12:33 AM
coemaw coemaw is offline Merge Group Name between two Excel Sheets Windows 10 Merge Group Name between two Excel Sheets Office 2010 64bit
Novice
Merge Group Name between two Excel Sheets 		 
Join Date: Feb 2017
Posts: 2
coemaw is on a distinguished road
Default
Yep Bro Xor, Thanks
Reply With Quote
  #4  
Old 02-17-2017, 12:52 AM
xor xor is offline Merge Group Name between two Excel Sheets Windows 10 Merge Group Name between two Excel Sheets Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Try to read Excel's help to the two functions, INDEX and MATCH.
If you, after having done that, have questions, please come back.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Group Category Mail Merge fairchance Mail Merge 18 11-29-2015 03:52 AM
Merge Group Name between two Excel Sheets Mail merge from excel - need to create sheets and create a table bluenosebex Mail Merge 5 08-02-2015 05:34 PM
How to group with mail merge pintail Mail Merge 1 05-28-2014 03:17 PM
Group Table Rows/Column (like Excel Group) eoinymc Word 1 03-11-2014 04:51 AM
merge excel sheets Mahen Excel 2 08-03-2011 12:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 PM.

Contact Us - Privacy Statement - Top

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