Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page What formula can I use to get the information What formula can I use to get the information
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-14-2021, 08:11 PM
Purfleet Purfleet 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: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
I have managed to do with a couple of formula's but it needs helper columns and as p45cal has stated it is all based on spaces (which is rubbish)

Also it is an array formula so you will need to press ctrl+shift+enter
Attached Files
File Type: xlsx Copy of example_AR12.xlsx (12.1 KB, 10 views)
Reply With Quote
 

« Previous Thread | Next Thread »


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 02:13 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