Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-14-2021, 09:11 PM
herodot herodot is offline What formula can I use to get the information Windows 10 What formula can I use to get the information Office 2016
Novice
What formula can I use to get the information
 
Join Date: Jun 2020
Posts: 12
herodot is on a distinguished road
Default

Thank you both of all for your time.



You helped me a lot!!!



The data is extracted from Microsoft Project which automatically insert spaces before those names.
Reply With Quote
  #2  
Old 08-15-2021, 05:45 AM
p45cal's Avatar
p45cal p45cal is offline What formula can I use to get the information Windows 10 What formula can I use to get the information Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
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

Quote:
Originally Posted by herodot View Post
The data is extracted from Microsoft Project which automatically insert spaces before those names.
Be careful, if anyone has started an activity or resource name with a space it could mess up.


If you create a pivot table from the range C12:E27 of Purfleet's file you could save yourself having to write out the column and row headers of your table (filter out the blank workers 'though).
2021-08-15_135005.png
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
What formula can I use to get the information formula to grab information on different sheet, only if meeting certain criteria bex_77 Excel 2 10-19-2016 03:42 AM
What formula can I use to get the information Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
One formula required to copy information from YTD spreadsheet onto individual monthly spreadsheets. Jo Freeman Excel 4 10-28-2015 08:09 AM
What formula can I use to get the information I want to use formula to auto update cells with information Steve81uk Excel 15 01-09-2015 12:58 PM
What formula can I use to get the information I can see my TOC but no information Becabica Word 14 05-22-2012 08:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:00 AM.


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