Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Lookup and Textjoin help
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 08-26-2021, 04:40 AM
p45cal's Avatar
p45cal p45cal is offline Lookup and Textjoin help Windows 10 Lookup and Textjoin help Office 2019
Expert
  
Join Date: Apr 2014
Posts: 962
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
For a given member in a given quarter you want separate total Hrs for each Eng?
Not easy using this path.

Are you sure it's not a pivot table you want?

See attached at cell G1, and another, slightly different arrangement at cell Q1. These take seconds to set up.
Attached Files
File Type: xlsx msofficeforums47554TextjoinPivots.xlsx (36.6 KB, 7 views)
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
LOOKUP - Complex lookup with 2 lookups in 1 cell sglandon Excel 6 05-05-2016 09:44 AM
Lookup and Textjoin help Lookup Tony Singh Excel 3 03-06-2015 11:03 AM
Lookup angie.chang Excel 1 07-27-2012 09:45 PM
Lookup and Textjoin help Possible Lookup Karen222 Excel 3 01-10-2012 05:41 AM
Lookup and Textjoin help LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:11 AM.

Contact Us - Privacy Statement - Top

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