Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Extract a matrix of another matrix defined by selected rows marked with an x Extract a matrix of another matrix defined by selected rows marked with an x
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2019, 09:15 AM
Tommy7571 Tommy7571 is offline Extract a matrix of another matrix defined by selected rows marked with an x Windows 10 Extract a matrix of another matrix defined by selected rows marked with an x Office 2010
Novice
Extract a matrix of another matrix defined by selected rows marked with an x 		 
Join Date: Mar 2019
Posts: 11
Tommy7571 is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
Hi and welcome


could you please provide a thread title in English please, so that our other members looking for a similar solution can find their way?
Thank you

Off course I already tried but it was not possible to edit the title.

"Extract a matrix of another matrix defined by selected rows marked with an x"


Can you edit it ?


Thanks


Tommy7571
Reply With Quote
  #2  
Old 03-18-2019, 11:32 AM
xor xor is offline Extract a matrix of another matrix defined by selected rows marked with an x Windows 10 Extract a matrix of another matrix defined by selected rows marked with an x Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
I don't know if the attached can be of some inspiration.

Be aware however that it makes use of the function TEXTJOIN which I think is only available in the newest version of Excel.
Attached Files
File Type: xlsx Extract_Rows.xlsx (10.7 KB, 9 views)
Reply With Quote
  #3  
Old 03-18-2019, 10:13 PM
Tommy7571 Tommy7571 is offline Extract a matrix of another matrix defined by selected rows marked with an x Windows 10 Extract a matrix of another matrix defined by selected rows marked with an x Office 2010
Novice
Extract a matrix of another matrix defined by selected rows marked with an x 		 
Join Date: Mar 2019
Posts: 11
Tommy7571 is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
I don't know if the attached can be of some inspiration.

Be aware however that it makes use of the function TEXTJOIN which I think is only available in the newest version of Excel.

This doesn't help me. I could not use the resulting structure for the work I want to do.


Thanks for the trial...


Tommy7571
Reply With Quote
  #4  
Old 03-19-2019, 12:16 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Extract a matrix of another matrix defined by selected rows marked with an x Windows 7 64bit Extract a matrix of another matrix defined by selected rows marked with an x Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Quote:
Originally Posted by Tommy7571 View Post
"Extract a matrix of another matrix defined by selected rows marked with an x"
Can you edit it ?

Thank you - Done


And BTW, do not quote entire posts unnecessarily. If they are out of sequence, just quote what is necessary to make your post understandable. It makes threads easier to read
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
matrix, sverweis

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Zeilen vergleichen und Meldung ausgeben Bravo Excel 1 02-23-2018 06:31 AM
Extract a matrix of another matrix defined by selected rows marked with an x 2nd matrix gives a resut that doesn´t match numbers in the 1st matrix Diver Excel 25 02-22-2017 04:39 PM
How to get value through a matrix? Xemx Excel 3 10-21-2014 05:46 AM
Extract a matrix of another matrix defined by selected rows marked with an x Dot Matrix Printing Angela Office 2 05-15-2012 08:56 PM
Matrix Algebra judicial85 Excel 3 10-12-2011 05:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:31 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