Thread: [Solved] What formula can I use to get the information
View Single Post
 
Old 08-14-2021, 08:11 PM
Purfleet Purfleet is offline Windows 10 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, 8 views)
Reply With Quote