Dear reader.
I have an attached (hopefully working) Excel document. I will always paste text from Notepad into this document with fixed words which are Sales, Shipping documents, Stock, Paperwork and Quality. Between those words are instructions for workers and need this automatically categorized as explained in the Excel sheet. Can somebody help.
Many, many thanks
H13=IFERROR(INDEX(INDEX($C$12:$C$27,MATCH(H$12,$C$12:$C$27,0)+1):INDEX($C$12:$C$27,IFERROR(MATCH(I$12,$C$12:$C$27,0)-1,ROWS($C$12:$C$27))),ROWS(H$13:H13)),"")
Try this and copy across
Assuming that the Order in Column C is as same of Order in Row 12
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
or try below array formula in h13 and copy and paste across
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Please Login or Register to view this content.
Hello,
Please try attached file
Please Login or Register to view this content.
Many, many thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks