Results 1 to 10 of 538

Thread: Appendix Thread. 3 TEST COPY

Threaded View

DocAElstein Appendix Thread. 3 TEST COPY 09-16-2015, 03:25 PM
DocAElstein Function Code for getting... 06-08-2016, 02:24 PM
DocAElstein Grid coordinates for a Range... 06-08-2016, 11:12 PM
DocAElstein Alternative Codes using [ ] ... 06-08-2016, 11:42 PM
DocAElstein More Named Range Scope Wonks.... 06-26-2016, 10:27 PM
DocAElstein Array List Sort of Referrences 10-23-2016, 02:19 PM
DocAElstein Code For Nelson 01-30-2017, 04:58 AM
DocAElstein Code for Nelson in this... 02-03-2017, 07:13 PM
DocAElstein Second Code for Nelson using... 02-05-2017, 07:02 PM
DocAElstein 'Testies: NOT FINAL CODE ---... 02-09-2017, 02:39 PM
DocAElstein Results for RaghavendraPrabhu 03-23-2018, 12:48 PM
DocAElstein Final Results for Code 2b)... 03-24-2018, 02:17 PM
DocAElstein Code for last post Sub... 03-24-2018, 02:49 PM
DocAElstein Search for text in txt File... 03-28-2018, 12:48 AM
DocAElstein Using this File: ... 03-28-2018, 01:36 PM
DocAElstein Finding and deleteing .exd... 03-29-2018, 04:13 PM
DocAElstein Screenshots and extra notes... 04-02-2018, 02:00 PM
DocAElstein From last post... This... 04-02-2018, 02:01 PM
DocAElstein For this Post... 04-02-2018, 02:26 PM
DocAElstein From last Post... master File... 04-02-2018, 03:16 PM
DocAElstein Master File After First... 04-02-2018, 05:28 PM
DocAElstein Bottom part of worksheet... 04-02-2018, 05:47 PM
DocAElstein Some similar results to the... 04-02-2018, 05:44 PM
DocAElstein Typical Updated Data File,... 04-02-2018, 05:55 PM
DocAElstein Run Code Sub ExportByName()... 04-02-2018, 06:26 PM
DocAElstein “zMasterAfter1stConsolidationN... 04-02-2018, 06:15 PM
DocAElstein Corresponding updated data... 04-02-2018, 06:31 PM
DocAElstein Data Files just before second... 04-02-2018, 06:44 PM
DocAElstein Final results for first half... 04-02-2018, 06:55 PM
DocAElstein Second half of master... 04-02-2018, 06:57 PM
DocAElstein Data files after final... 04-02-2018, 07:01 PM
DocAElstein Code for anwser to this... 04-02-2018, 07:17 PM
DocAElstein Checked Library Infomation... 04-07-2018, 12:43 AM
DocAElstein Test data supplied by... 05-13-2018, 02:28 PM
DocAElstein Table from above again Using... 05-13-2018, 02:32 PM
DocAElstein Code for this Thread:... 05-13-2018, 02:40 PM
DocAElstein Another view of last table ... 05-13-2018, 02:31 PM
DocAElstein Re Post code with Code tags 05-24-2018, 01:24 PM
DocAElstein Code in code tags from here:... 06-02-2018, 11:30 AM
DocAElstein Share account for testing... 06-22-2018, 10:34 AM
DocAElstein Testing Hyperlinks in... 06-30-2018, 02:36 PM
DocAElstein Code for Thai . Option... 07-01-2018, 02:17 PM
DocAElstein First test code for solution... 07-07-2018, 01:37 PM
DocAElstein Test runs from code Sub... 07-19-2018, 02:24 PM
DocAElstein Code in support of this Post... 07-19-2018, 02:40 PM
DocAElstein Code in support of this Post... 07-23-2018, 03:57 PM
DocAElstein Code in support of this Post... 07-23-2018, 04:03 PM
DocAElstein Results in support of answer... 07-26-2018, 02:33 PM
DocAElstein Code corresponding to last... 07-26-2018, 02:43 PM
DocAElstein Suggested test data to answer... 07-29-2018, 11:51 AM
DocAElstein Code to answer this post:... 07-29-2018, 01:31 PM
DocAElstein Sample test results for code... 07-29-2018, 01:33 PM
DocAElstein In the last code , ( Sub... 07-29-2018, 12:00 PM
DocAElstein Code for alternative(2)... 07-30-2018, 12:38 PM
DocAElstein test results from code above,... 07-30-2018, 12:43 PM
DocAElstein Test data in support of this... 07-31-2018, 12:54 PM
DocAElstein Attaching a File to a Thread... 08-02-2018, 11:57 AM
DocAElstein Attaching a File to a Thread... 08-02-2018, 11:57 AM
DocAElstein In support of this Post... 08-02-2018, 12:18 PM
DocAElstein Loop through closed workbooks... 11-04-2018, 06:43 PM
DocAElstein Named Ranges scope defines... 11-11-2018, 03:47 PM
DocAElstein Further Practice with using... 11-18-2018, 06:03 PM
DocAElstein Second main Demo Code in... 11-18-2018, 06:06 PM
DocAElstein Support Called routines for... 11-18-2018, 06:08 PM
DocAElstein In support of this post: ... 11-18-2018, 06:21 PM
DocAElstein VBA named range scope not... 11-20-2018, 06:12 PM
DocAElstein NameObjectFile.xls as Zip 11-20-2018, 09:44 PM
DocAElstein ClsData.xls as Zip File 11-21-2018, 02:02 AM
DocAElstein Summary of info in the XML... 11-21-2018, 06:13 PM
DocAElstein A brief introduction to... 12-06-2018, 10:13 PM
DocAElstein Pubic Properly Leting Get in... 12-09-2018, 08:40 PM
DocAElstein Continuation fron last Post... 12-09-2018, 08:42 PM
DocAElstein Sub ... 12-24-2018, 01:10 PM
DocAElstein Sub... 12-24-2018, 01:12 PM
DocAElstein Sub... 12-24-2018, 01:16 PM
DocAElstein Code for Yassser here:... 12-30-2018, 08:47 PM
DocAElstein ' Sub... 12-31-2018, 12:43 AM
DocAElstein Code for suppot of this... 01-01-2019, 07:41 PM
DocAElstein 4, 5, 6 and 7 data section... 01-01-2019, 07:51 PM
DocAElstein First 3 section output after... 01-01-2019, 07:49 PM
DocAElstein Coding for Update Lists 01-09-2019, 09:11 PM
DocAElstein This is required for the... 01-09-2019, 09:29 PM
DocAElstein UDF that can change values in... 01-09-2019, 09:11 PM
DocAElstein Part 2 of Main code. This... 01-09-2019, 09:27 PM
DocAElstein UDF that can change values in... 01-09-2019, 09:27 PM
DocAElstein UDF that can change values in... 01-09-2019, 09:29 PM
DocAElstein Appendix to .. 01-09-2019, 09:54 PM
DocAElstein Full demo code to accompany... 01-09-2019, 09:56 PM
DocAElstein UDF that can change values in... 01-09-2019, 09:54 PM
DocAElstein XXNVCX:;YNXYN 01-09-2019, 09:56 PM
DocAElstein Continued from last post ... 01-09-2019, 09:55 PM
DocAElstein Some other notes for a Thread... 01-09-2019, 09:55 PM
DocAElstein Test Sort Routine 01-30-2019, 01:08 AM
DocAElstein Sub subArrayMergeSort( _ ... 01-30-2019, 01:18 AM
DocAElstein Test Sort Routine 01-30-2019, 01:08 AM
DocAElstein Routines called by test code... 01-30-2019, 01:18 AM
DocAElstein KVKDLDKLJ 01-30-2019, 01:18 AM
DocAElstein VBA Filter for Columns... 02-03-2019, 04:46 PM
DocAElstein Filter for columns not for... 02-03-2019, 04:52 PM
DocAElstein Simplified coding 02-03-2019, 08:06 PM
DocAElstein Sir Narios ... Positioning of... 02-05-2019, 08:44 PM
DocAElstein "What’s in a String"- VBA... 02-07-2019, 10:50 PM
DocAElstein This is the second part of... 02-07-2019, 10:52 PM
DocAElstein Simple Array Bubble Sort... 02-18-2019, 02:51 PM
DocAElstein Further Examples using the... 02-18-2019, 02:58 PM
DocAElstein Simpla Array Bubble Sort... 02-19-2019, 10:52 PM
DocAElstein Simple Array Bubble Sort... 02-19-2019, 11:55 PM
DocAElstein The sorted array is displayed... 02-20-2019, 12:12 AM
DocAElstein First step in turning Bubble... 02-20-2019, 10:28 PM
DocAElstein Because we are using ByRef ... 02-21-2019, 01:15 PM
DocAElstein Initial Function for Simple... 02-21-2019, 05:24 PM
DocAElstein Some typical resullts using... 02-21-2019, 05:47 PM
DocAElstein Final Demo of recursion array... 02-22-2019, 06:20 PM
DocAElstein Final Main recursion Array... 02-22-2019, 06:56 PM
DocAElstein Typical results using coding... 02-22-2019, 08:23 PM
DocAElstein Code to simulate Click on... 03-02-2019, 10:44 PM
DocAElstein Clear Windows ClIpboard 03-03-2019, 05:46 PM
DocAElstein Early Binding and Later Late... 03-03-2019, 09:16 PM
DocAElstein Sub TestieSimpleArraySort7() ... 03-13-2019, 09:38 PM
DocAElstein Main recursion routine ... 03-13-2019, 09:45 PM
DocAElstein Sub TestieSimpleArraySort8()... 03-14-2019, 03:52 PM
DocAElstein Sub SimpleArraySort8( 03-14-2019, 04:30 PM
DocAElstein Coding for this excelfox... 03-16-2019, 10:09 PM
DocAElstein Sub BubblesIndexIdeaWay As... 03-17-2019, 02:21 PM
DocAElstein Sub BubblesIndexIdeaWay As... 03-17-2019, 02:22 PM
DocAElstein Original test data range , (... 03-17-2019, 02:59 PM
DocAElstein Sub... 03-17-2019, 03:25 PM
DocAElstein Recursion routine for this... 03-17-2019, 08:23 PM
DocAElstein Some Killing File tests /... 03-31-2019, 02:31 PM
DocAElstein There is a second argument to... 04-02-2019, 03:17 PM
DocAElstein Deafault item to use if empty... 04-02-2019, 03:19 PM
DocAElstein Dir Order 04-02-2019, 03:16 PM
DocAElstein Coding in suport of these... 04-06-2019, 01:15 PM
DocAElstein Initial coding for solution... 04-20-2019, 03:10 PM
DocAElstein In support of answer to this... 04-21-2019, 03:06 PM
DocAElstein _____ Workbook: Data Sheet... 04-24-2019, 11:36 AM
DocAElstein In support of this thread ... 04-24-2019, 11:34 AM
DocAElstein _____ Workbook: Data Sheet... 04-24-2019, 11:47 AM
DocAElstein Full data Sheet1 data ( part... 04-24-2019, 12:31 PM
DocAElstein Full data input sheet2... 04-24-2019, 12:34 PM
DocAElstein A typical test run of the... 04-25-2019, 01:51 PM
DocAElstein Corresponding Sheet1 for the... 04-24-2019, 12:26 PM
DocAElstein Version 3 code for Haider,... 04-25-2019, 01:49 PM
DocAElstein Notes in support of these... 06-07-2019, 03:13 PM
DocAElstein Notes in support of these... 06-08-2019, 11:04 AM
TallPaulUK Hi Alan... Thank you so much... 06-10-2019, 05:00 PM
DocAElstein You're welcome , Paul ,... 06-10-2019, 10:14 PM
DocAElstein macro recording example 06-22-2019, 03:17 PM
DocAElstein In support of answer to this... 06-22-2019, 03:31 PM
DocAElstein In support of answer to this... 06-26-2019, 03:08 PM
DocAElstein In support of this main Forum... 08-02-2019, 02:13 PM
DocAElstein In support and appendix for... 08-03-2019, 12:26 PM
DocAElstein Testing for this Thread Post:... 08-11-2019, 12:15 PM
DocAElstein In support of this Thread:... 08-26-2019, 11:48 AM
DocAElstein For... 08-26-2019, 12:01 PM
DocAElstein In support of this Thread:... 09-04-2019, 11:48 AM
DocAElstein Using data from last post ... 09-04-2019, 03:03 PM
DocAElstein Making Lr dynamic ( using... 09-05-2019, 10:52 AM
DocAElstein in support of this Thread: ... 09-10-2019, 11:57 AM
DocAElstein In support of this Thread:... 09-10-2019, 12:57 PM
DocAElstein Some further notes and... 09-11-2019, 05:03 PM
DocAElstein e) Evaluate Range 09-13-2019, 12:40 PM
DocAElstein in support of this post: ... 09-13-2019, 04:41 PM
DocAElstein Some supporting notes for... 10-04-2019, 04:18 PM
DocAElstein In support of answers to... 10-29-2019, 02:00 PM
DocAElstein In support to answer of this... 11-06-2019, 05:06 PM
DocAElstein follow on from last post: ... 11-06-2019, 06:43 PM
DocAElstein Follow on from last 2 posts ... 11-06-2019, 07:56 PM
DocAElstein Coding for this Thread ... 12-18-2019, 11:04 PM
DocAElstein Notes in support of this... 12-19-2019, 06:28 PM
DocAElstein Thoughts on adding split... 12-20-2019, 04:41 PM
DocAElstein Some notes in support of... 12-21-2019, 05:02 PM
DocAElstein Local Host address, Computer... 12-22-2019, 05:55 PM
DocAElstein Coding in support of this... 12-27-2019, 04:49 PM
DocAElstein The procedure entry point... 12-31-2019, 01:57 AM
DocAElstein Re installing in XP Using... 01-01-2020, 12:51 AM
DocAElstein Strangely …. KB4461526... 12-31-2019, 09:37 PM
DocAElstein Test draft copy of forum... 01-01-2020, 01:47 AM
DocAElstein In support of these Thread... 01-01-2020, 07:40 PM
DocAElstein Coding for this Thread post ... 01-04-2020, 01:30 AM
DocAElstein Coding in support of these... 01-07-2020, 05:50 PM
DocAElstein In support of this Thread... 01-10-2020, 12:31 AM
DocAElstein In support of this Thread... 01-10-2020, 12:31 AM
DocAElstein In support of this Thread... 01-10-2020, 12:31 AM
DocAElstein In support of this Thread... 01-10-2020, 12:42 AM
DocAElstein In support of this Thread... 01-10-2020, 12:31 AM
DocAElstein In support of this Post: ... 01-11-2020, 06:29 PM
DocAElstein Coding for these Threads ... 01-20-2020, 06:34 PM
DocAElstein Coding in support of this... 01-21-2020, 04:57 PM
DocAElstein In support of this thread ... 02-05-2020, 10:50 PM
DocAElstein In support of this Post: ... 02-08-2020, 07:32 PM
DocAElstein _____ Workbook:... 02-08-2020, 07:34 PM
DocAElstein In support of this post ... 02-08-2020, 07:57 PM
DocAElstein In support of this post ... 02-08-2020, 07:57 PM
DocAElstein In support of this post ... 02-08-2020, 11:26 PM
DocAElstein In support of this Post... 02-11-2020, 11:50 PM
DocAElstein In support of this Post... 02-12-2020, 12:31 AM
DocAElstein In Support of this Post... 02-16-2020, 06:51 PM
DocAElstein In support of this postpost ... 02-16-2020, 10:07 PM
DocAElstein Some coding in support of... 02-18-2020, 12:27 PM
DocAElstein Some additional coding to... 02-18-2020, 08:08 PM
DocAElstein In support of this post... 02-18-2020, 09:12 PM
DocAElstein Some additional coding to... 02-18-2020, 10:52 PM
DocAElstein ' Macro to color text of... 02-19-2020, 03:18 AM
DocAElstein list all file types , and (... 02-19-2020, 02:03 PM
DocAElstein In support of this post... 02-20-2020, 10:10 PM
DocAElstein In support of this post... 02-24-2020, 02:42 AM
DocAElstein In support of this post:... 02-23-2020, 11:03 PM
DocAElstein in support of this Thread... 02-25-2020, 04:45 PM
DocAElstein In support of this post... 02-26-2020, 02:38 AM
DocAElstein In support of this post ... 02-29-2020, 10:34 PM
DocAElstein In support of this Thread: ... 03-03-2020, 01:10 AM
DocAElstein In support of this Post ... 03-03-2020, 10:04 PM
DocAElstein In support of this post ... 03-03-2020, 06:47 PM
DocAElstein In support of this post... 03-05-2020, 09:49 PM
DocAElstein Do While Loop start further... 03-06-2020, 12:47 AM
DocAElstein In support of answer for this... 03-06-2020, 08:27 PM
DocAElstein In support of this Forum... 03-07-2020, 06:52 PM
DocAElstein Macro for last post Sub... 03-07-2020, 06:52 PM
DocAElstein In support of this Thread... 03-09-2020, 01:51 AM
DocAElstein In support of this post ... 03-09-2020, 02:29 AM
DocAElstein In support of this Post ... 03-10-2020, 02:46 PM
DocAElstein In support of these threads.... 03-12-2020, 12:33 AM
DocAElstein In support of this post:... 03-12-2020, 10:40 PM
DocAElstein In support of this Post... 03-13-2020, 10:17 PM
DocAElstein In support of this Thread... 03-18-2020, 03:35 PM
DocAElstein In support of these posts... 03-19-2020, 05:54 PM
DocAElstein In support of this Post... 03-20-2020, 01:34 AM
DocAElstein In support of this post... 03-21-2020, 02:17 AM
DocAElstein In support of this post ... 03-21-2020, 05:38 PM
DocAElstein In support of this post. ... 03-22-2020, 07:24 PM
DocAElstein Test blog post, and function... 03-24-2020, 01:23 AM
DocAElstein In support of this post… ... 03-24-2020, 01:11 AM
DocAElstein In support of this post... 03-24-2020, 06:28 PM
DocAElstein Macro for this post solution,... 03-24-2020, 11:12 PM
DocAElstein In support of this post... 03-24-2020, 08:12 PM
DocAElstein In support of these posts ... 03-25-2020, 03:34 AM
DocAElstein http://www.excelfox.com/forum/... 03-25-2020, 05:58 PM
DocAElstein In support of this Thread... 03-27-2020, 01:46 AM
DocAElstein In support of this Post:... 03-30-2020, 12:35 AM
DocAElstein Macro for this Post ' ... 04-16-2020, 01:47 PM
DocAElstein In support of this question ... 04-18-2020, 01:41 PM
DocAElstein test Evaluate range for this... 04-18-2020, 03:18 PM
DocAElstein in support of this forum post... 04-20-2020, 12:48 PM
DocAElstein VBA Solution to above, and... 04-21-2020, 01:11 PM
DocAElstein In support of this Thread... 04-26-2020, 02:02 PM
DocAElstein From last post Before ... 04-26-2020, 03:27 PM
DocAElstein In support of this post ... 04-26-2020, 06:10 PM
DocAElstein Macro used to get the results... 04-27-2020, 01:15 PM
DocAElstein In support of this post... 04-27-2020, 01:15 PM
DocAElstein New macro ( for... 04-27-2020, 04:54 PM
DocAElstein Macro for this Post... 04-28-2020, 01:19 PM
DocAElstein Notes for this Post... 04-28-2020, 01:19 PM
DocAElstein macro solution for last post... 05-03-2020, 09:36 PM
DocAElstein In support to answer to this... 05-05-2020, 11:48 AM
DocAElstein Function required for last... 05-05-2020, 12:45 PM
DocAElstein Some Development results from... 05-05-2020, 02:43 PM
DocAElstein In support of this Post ... 05-07-2020, 02:05 PM
DocAElstein Next solution attempt for... 05-05-2020, 02:39 PM
DocAElstein In support of these Post ... 05-07-2020, 01:27 PM
DocAElstein In support of these Post ... 05-07-2020, 01:27 PM
sandy666 easy, easy, this is a... 05-07-2020, 02:34 PM
DocAElstein It is character building.... 05-07-2020, 02:47 PM
DocAElstein Try number 12976436.... 05-08-2020, 12:57 PM
DocAElstein In Support of this forum... 05-08-2020, 12:57 PM
DocAElstein Another attempt to geuss what... 05-08-2020, 12:57 PM
DocAElstein In Support of this forum... 05-13-2020, 12:58 PM
DocAElstein Macro accomnpanying last post... 05-13-2020, 01:15 PM
DocAElstein Some notes related to these... 05-15-2020, 08:18 PM
DocAElstein Some notes related to these... 05-15-2020, 08:18 PM
DocAElstein Some notes related to these... 05-15-2020, 08:18 PM
DocAElstein Some notes related to these... 05-15-2020, 08:18 PM
DocAElstein Some notes related to these... 05-15-2020, 08:18 PM
DocAElstein https://excelfox.com/forum/sho... 05-15-2020, 08:18 PM
DocAElstein csv to Excel 05-15-2020, 08:18 PM
DocAElstein Just testing links to... 06-11-2020, 03:22 PM
DocAElstein Text File 05-15-2020, 08:18 PM
DocAElstein Excel File 05-15-2020, 08:18 PM
DocAElstein Data File 05-15-2020, 08:18 PM
DocAElstein Some notes related to these... 05-15-2020, 08:18 PM
DocAElstein Some notes related to these... 05-15-2020, 08:18 PM
DocAElstein Some notes related to these... 05-15-2020, 08:18 PM
DocAElstein In support of this post: ... 05-18-2020, 01:19 PM
DocAElstein Some notes in support in... 05-18-2020, 03:30 PM
DocAElstein macro for solution to this... 05-18-2020, 06:20 PM
DocAElstein Notes for question 2 here ... 05-19-2020, 02:57 AM
DocAElstein Macro for last post Sub... 05-19-2020, 03:26 AM
DocAElstein Macro for this post: ... 05-19-2020, 03:08 PM
DocAElstein Macro for last post, and to... 05-20-2020, 12:24 AM
DocAElstein Test ranges used to answer... 05-20-2020, 12:12 AM
DocAElstein Just testing ignore all this... 05-20-2020, 02:23 AM
DocAElstein Macro for this Thread post ... 05-24-2020, 12:58 PM
DocAElstein macro for this post ... 05-24-2020, 11:14 PM
DocAElstein In support of this Thread ... 05-25-2020, 02:44 PM
DocAElstein Macro solution for this post:... 05-25-2020, 03:05 PM
DocAElstein test asdsdklj ... 05-26-2020, 02:16 PM
DocAElstein assfhshffhsfskfh 05-26-2020, 02:16 PM
DocAElstein In support of answer for this... 05-26-2020, 02:16 PM
DocAElstein Sub... 05-26-2020, 02:16 PM
DocAElstein Sample2After.csv ... 05-26-2020, 02:16 PM
DocAElstein Macro for this post:... 05-26-2020, 02:16 PM
DocAElstein Macro for this post... 05-26-2020, 02:16 PM
DocAElstein Macro to answer this Thread... 05-26-2020, 02:16 PM
DocAElstein Macro for this post:... 05-26-2020, 02:16 PM
DocAElstein In support of these posts... 05-26-2020, 02:16 PM
DocAElstein Macro for this post:... 05-26-2020, 02:16 PM
DocAElstein Add Worksheets from name list... 05-30-2020, 12:49 PM
DocAElstein Macros for this post (... 05-30-2020, 01:30 PM
DocAElstein Macro for these posts ( ... 05-31-2020, 12:56 PM
DocAElstein Macros for this post... 06-01-2020, 02:32 PM
DocAElstein kkfhhfsfhsah 06-07-2020, 09:07 PM
DocAElstein In suppot of this forum post... 06-08-2020, 08:39 PM
DocAElstein In suppot of this forum post... 06-08-2020, 08:39 PM
DocAElstein lKSHFLhlhfl 06-10-2020, 02:09 PM
DocAElstein lKSHFLhlhfl 06-10-2020, 02:09 PM
DocAElstein lKSHFLhlhfl 06-10-2020, 02:09 PM
DocAElstein test ... test ... 06-10-2020, 02:09 PM
DocAElstein lKSHFLhlhfl 06-10-2020, 02:09 PM
DocAElstein In support of this thread... 06-12-2020, 12:52 PM
DocAElstein In support of the answer to... 06-27-2020, 02:58 PM
DocAElstein post to get the URL - for... 06-28-2020, 02:37 AM
DocAElstein post to get the URL - for... 07-03-2020, 03:16 PM
DocAElstein Solution1 fo this Thread... 07-03-2020, 02:47 PM
DocAElstein Solution 2 07-05-2020, 05:07 PM
DocAElstein Solution 3 07-05-2020, 09:39 PM
DocAElstein Solution 4 07-06-2020, 02:31 AM
DocAElstein Macro solution for this post:... 07-07-2020, 12:25 PM
DocAElstein Notes in support of this... 07-07-2020, 11:56 AM
DocAElstein Macro for this post... 07-07-2020, 04:46 PM
DocAElstein Noptes in support of answer... 07-11-2020, 12:27 AM
DocAElstein Macro for last post, and also... 07-15-2020, 01:54 PM
DocAElstein Alternative solution to... 07-16-2020, 01:48 PM
DocAElstein test post to get URL for... 07-16-2020, 12:18 PM
DocAElstein Full macro versions for this... 07-24-2020, 01:59 PM
DocAElstein Full macro version for this... 07-24-2020, 03:12 PM
DocAElstein Full macro versions for this... 07-24-2020, 04:21 PM
DocAElstein Post for later use Required... 07-26-2020, 11:45 AM
DocAElstein In support of this Thread... 07-26-2020, 11:26 PM
DocAElstein In support of this Thread:... 08-09-2020, 01:51 PM
DocAElstein In support of this Thread:... 08-09-2020, 01:52 PM
DocAElstein In support of this Thread:... 08-09-2020, 01:57 PM
DocAElstein In support of this Thread... 08-15-2020, 02:34 AM
DocAElstein In support of this Thread... 08-16-2020, 06:04 PM
DocAElstein In support of this Thread... 08-16-2020, 01:53 PM
DocAElstein In support of this Thread... 08-16-2020, 06:05 PM
DocAElstein In support of this Post... 08-16-2020, 06:08 PM
DocAElstein Some additional notes and... 09-10-2020, 11:43 AM
DocAElstein Continued from last post... 09-10-2020, 12:14 PM
DocAElstein In support of these Threads ... 09-10-2020, 11:39 AM
DocAElstein Macro for these posts ... 09-10-2020, 02:47 PM
DocAElstein Macro to get the text file... 10-10-2020, 02:18 PM
DocAElstein Some notes in support of... 10-10-2020, 02:18 PM
DocAElstein In support of this Thread ... 10-14-2020, 12:46 PM
DocAElstein In support of this answer ... 10-25-2020, 12:27 PM
DocAElstein In support of this Thread ... 10-25-2020, 03:11 PM
DocAElstein Some extra clarifying info... 10-26-2020, 03:42 PM
DocAElstein Some extra clarifying info... 10-26-2020, 03:33 PM
DocAElstein In suppot of this Thread... 11-01-2020, 03:39 PM
DocAElstein In support of this Thread ... 11-01-2020, 03:41 PM
DocAElstein In support of this Thread ... 11-01-2020, 03:45 PM
DocAElstein In support of this Thread ... 11-01-2020, 04:59 PM
DocAElstein Test post for later use 11-18-2020, 01:48 PM
DocAElstein Some extra notes for a few... 11-30-2020, 02:47 PM
DocAElstein Some extra notes for a few... 11-30-2020, 02:47 PM
DocAElstein Some extra notes for a few... 11-30-2020, 02:47 PM
DocAElstein Some extra notes for a few... 11-30-2020, 02:47 PM
DocAElstein Some extra notes for a few... 11-30-2020, 02:47 PM
DocAElstein Some extra notes for a few... 11-30-2020, 02:47 PM
DocAElstein macro or this Post:... 12-08-2020, 05:21 PM
DocAElstein In support of these Thread... 12-10-2020, 04:03 PM
DocAElstein Coding for this Thread... 01-15-2021, 10:53 PM
DocAElstein Coding for this Thread... 01-15-2021, 10:58 PM
DocAElstein post for later use..... 01-16-2021, 02:25 PM
DocAElstein post for later use- 01-16-2021, 02:25 PM
DocAElstein post for later use 01-16-2021, 02:25 PM
DocAElstein ( In this example, Indx, is... 01-16-2021, 02:24 PM
DocAElstein post for later use 01-16-2021, 02:25 PM
DocAElstein MID(... 01-16-2021, 10:13 PM
DocAElstein In support of this post ... 01-24-2021, 07:33 PM
DocAElstein macro for last two posts ... 01-24-2021, 07:33 PM
DocAElstein MID(... 01-16-2021, 10:13 PM
DocAElstein In support of this posting... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein post to use later 01-24-2021, 07:32 PM
DocAElstein post to use later 01-24-2021, 07:32 PM
DocAElstein In support of this post ... 01-24-2021, 07:33 PM
DocAElstein In support of this post ... 01-24-2021, 07:33 PM
DocAElstein Macro for last two posts ... 01-24-2021, 07:33 PM
DocAElstein In support of this post ... 01-24-2021, 07:33 PM
DocAElstein In support of this post ... 01-24-2021, 07:33 PM
DocAElstein macro for last two posts ... 01-24-2021, 07:33 PM
DocAElstein In support of this post ... 01-24-2021, 07:33 PM
DocAElstein macro for last two posts ... 01-24-2021, 07:33 PM
DocAElstein ycb<ybc,bc,ybcybyb 01-24-2021, 07:33 PM
DocAElstein In support of this posting... 01-24-2021, 07:33 PM
DocAElstein In support of this posting... 01-24-2021, 07:33 PM
DocAElstein Macro for last 3 posts ... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein ahdlaKHDLakhdalkhd 01-24-2021, 07:33 PM
DocAElstein Links hcDHADLHADHAD 01-24-2021, 07:33 PM
DocAElstein AKHDalkhd 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein ADLAdlAHDLAhdlakHDLadh 01-24-2021, 07:33 PM
DocAElstein I forgot about this Blog tip... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Another example, possibly,... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein ADHLhdlhd 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein Links relavent to the last 9... 01-24-2021, 07:33 PM
DocAElstein In support of this post... 01-24-2021, 07:33 PM
DocAElstein In support of this post... 01-24-2021, 07:33 PM
DocAElstein In support of this post... 01-24-2021, 07:33 PM
DocAElstein In support of this post... 01-24-2021, 07:33 PM
DocAElstein In support of this post... 01-24-2021, 07:33 PM
DocAElstein In support of this post... 01-24-2021, 07:33 PM
DocAElstein Macro for last post ... 02-09-2021, 10:53 PM
DocAElstein In support of this post... 02-27-2021, 06:18 PM
DocAElstein Some notes from this... 03-05-2021, 05:17 PM
DocAElstein macro for last two posts ... 01-24-2021, 07:33 PM
DocAElstein macro for last two posts ... 01-24-2021, 07:33 PM
DocAElstein In suppot of this thread... 02-09-2021, 10:52 PM
DocAElstein for later use 02-27-2021, 06:17 PM
DocAElstein Post for later use 03-05-2021, 05:17 PM
DocAElstein Continued from last post:... 03-05-2021, 05:26 PM
DocAElstein Some notes for this question:... 03-05-2021, 10:51 PM
DocAElstein extended coding notes for... 03-05-2021, 11:11 PM
DocAElstein This is a slightly more sane... 03-06-2021, 12:47 AM
DocAElstein In support of these Threads... 03-06-2021, 02:23 PM
DocAElstein Full macro for last post ... 03-06-2021, 05:11 PM
DocAElstein I am not quite sure what got... 03-06-2021, 07:02 PM
DocAElstein I can sanitise the last... 03-07-2021, 03:59 PM
DocAElstein If I use a Transpose function... 03-07-2021, 04:24 PM
DocAElstein post for latzer use View... 03-07-2021, 05:46 PM
DocAElstein In support of these post... 03-07-2021, 05:47 PM
DocAElstein Post for later use 03-07-2021, 04:23 PM
DocAElstein I have done another couple of... 03-07-2021, 05:49 PM
DocAElstein Transpose Function Way ... 03-08-2021, 12:53 AM
DocAElstein Some extra solutions for this... 03-22-2021, 03:02 PM
DocAElstein pconlife.com 03-30-2021, 01:14 PM
DocAElstein Windows XP Home Edition x32... 03-31-2021, 12:46 PM
DocAElstein 2007 04-07-2021, 01:34 PM
DocAElstein In support of this Thread... 04-07-2021, 01:06 PM
DocAElstein 2010 04-07-2021, 01:38 PM
DocAElstein 365 04-07-2021, 05:46 PM
DocAElstein XP 2010 04-07-2021, 08:22 PM
DocAElstein Some extra macros for this... 04-12-2021, 05:07 PM
DocAElstein An extra macro for this... 04-12-2021, 05:12 PM
DocAElstein post for later use 04-12-2021, 05:03 PM
DocAElstein Some extra macros for this... 04-12-2021, 05:10 PM
DocAElstein Some extra notes for the... 04-23-2021, 09:41 AM
DocAElstein In support of this answer... 04-24-2021, 10:49 AM
DocAElstein Some further tests in support... 05-07-2021, 10:38 AM
DocAElstein Continued from last post ... 05-07-2021, 11:03 AM
DocAElstein Another alternative solution... 05-09-2021, 12:08 PM
DocAElstein In support of this Thread ... 08-11-2021, 09:34 AM
DocAElstein .... test post for later ... 08-11-2021, 09:34 AM
DocAElstein testing image links Hallo... 08-22-2021, 02:32 PM
DocAElstein In support of these forum... 08-26-2021, 10:30 AM
DocAElstein Some extra notes in support... 10-19-2021, 03:15 PM
DocAElstein Some extra notes in support... 10-19-2021, 02:38 PM
DocAElstein Some extra notes in support... 10-19-2021, 03:24 PM
DocAElstein Some extra notes in support... 10-19-2021, 03:31 PM
DocAElstein Some extra notes in support... 10-19-2021, 03:25 PM
DocAElstein Macro coding for this Thread:... 10-20-2021, 12:12 AM
DocAElstein Copy from here ... 10-24-2021, 11:31 AM
DocAElstein In support of this post:... 11-05-2021, 01:13 PM
DocAElstein In support of this post:... 11-05-2021, 01:13 PM
DocAElstein In support of this post ... 11-09-2021, 01:06 PM
DocAElstein Coding for these Threads ... 11-25-2021, 12:12 PM
DocAElstein In support of this Thread... 12-06-2021, 02:49 PM
DocAElstein In support of this Thread ... 12-13-2021, 04:36 PM
DocAElstein In support of this Thread ... 01-01-2022, 03:39 PM
DocAElstein In support of the forum post:... 02-06-2022, 07:26 PM
DocAElstein Test # Add-Type... 02-06-2022, 07:32 PM
DocAElstein In support of this forum post... 02-08-2022, 09:29 PM
DocAElstein In support of this forum post... 02-08-2022, 09:29 PM
DocAElstein In support of this forum post... 02-08-2022, 09:29 PM
DocAElstein In support of this forum post... 02-08-2022, 09:29 PM
DocAElstein In support of these forum... 02-09-2022, 07:58 PM
DocAElstein In support of these forum... 02-09-2022, 07:58 PM
DocAElstein Macro for this post ... 02-09-2022, 11:45 PM
DocAElstein test ... 02-09-2022, 11:45 PM
DocAElstein test ... 02-09-2022, 11:45 PM
DocAElstein Macro for this post ... 02-09-2022, 11:45 PM
DocAElstein test ... 02-09-2022, 11:45 PM
DocAElstein test ... 02-09-2022, 11:45 PM
DocAElstein <div class="gmail_chip... 02-09-2022, 11:45 PM
DocAElstein In support of this post... 02-09-2022, 11:45 PM
DocAElstein In support of this post ... 02-09-2022, 11:45 PM
DocAElstein jADHKJASHDKJahdjkAHD 02-09-2022, 11:45 PM
DocAElstein <div class="gmail_chip... 02-09-2022, 11:45 PM
DocAElstein khskjhkshhhfhfhfslhafhalfh 02-09-2022, 11:45 PM
DocAElstein In support of these issues ... 03-28-2022, 04:13 PM
DocAElstein Test ... 04-16-2022, 10:23 PM
DocAElstein In support of this Thread... 04-26-2022, 12:19 PM
DocAElstein Coding so far , for last... 04-26-2022, 06:16 PM
DocAElstein Spare post for later ... 04-26-2022, 06:18 PM
DocAElstein Following on from posts, ... 04-26-2022, 06:40 PM
DocAElstein Coding for these posts ... 04-26-2022, 07:40 PM
DocAElstein Some extra notes for this... 06-17-2022, 02:10 AM
DocAElstein some more notes on it.... ... 06-22-2022, 12:42 PM
DocAElstein This is post... 06-22-2022, 12:43 PM
DocAElstein Here is the full workings for... 06-24-2022, 03:56 PM
DocAElstein In support of this main Forum... 07-17-2022, 12:10 PM
DocAElstein In support of this main Forum... 07-17-2022, 12:58 PM
DocAElstein Some extra notes for this... 07-22-2022, 12:03 PM
DocAElstein Here is an alternative single... 07-24-2022, 12:02 PM
DocAElstein Spare post for sharing some... 07-24-2022, 12:49 PM
DocAElstein In support of this main forum... 08-01-2022, 12:01 PM
DocAElstein Some notes in support of this... 10-01-2022, 01:21 PM
DocAElstein in VBA if the given string is... 10-02-2022, 05:49 PM
DocAElstein Test I see what you are... 10-02-2022, 02:24 PM
DocAElstein In support of this main Forum... 10-02-2022, 09:33 PM
DocAElstein Output required ( ... 10-03-2022, 02:52 PM
DocAElstein In support of this thread ... 10-03-2022, 02:42 PM
DocAElstein Further info for the last two... 10-03-2022, 04:30 PM
DocAElstein This is post... 12-06-2022, 01:44 PM
DocAElstein Coding for last post '... 12-08-2022, 12:38 PM
DocAElstein Some notes for this main... 04-21-2023, 11:18 PM
DocAElstein _____ Workbook: report.xls (... 04-21-2023, 11:18 PM
DocAElstein Some notes for this main... 04-22-2023, 01:07 AM
DocAElstein I missed the point, (... 04-23-2023, 11:15 AM
DocAElstein Sub AlanReporting() ' ... 04-24-2023, 03:56 PM
DocAElstein We note a slight difference... 04-24-2023, 04:23 PM
Previous Post Previous Post   Next Post Next Post
  1. #11
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,522
    Rep Power
    10
    Transpose Function Way

    Code:
    
    
    '   Using  Transpose  for the transposing
    Sub Pretty3dTranspose()  '
    Rem 0 worksheets info
    Dim Ws1 As Worksheet
     Set Ws1 = ThisWorkbook.Worksheets.Item("Sheet1")
    Dim M As Long: Let M = Ws1.Range("A" & Ws1.Rows.Count & "").End(xlUp).Row
    
    
    Dim arrTemp() As Variant
    Rem  To get the results in  column  T  ( same as Yassers or Hans Results
     ' Ths first forumula gives me all the matches for F in the C ( helper column )  or error for no match
     Let arrTemp() = Evaluate("=If({1},MATCH(F2:F" & M & ",Int(B2:B" & M & "),0))")   '   If({1},____)    may not be needed for Excel 2016 and higher   The first formula does the main work
     ' The multiplication by $A$2:$A$1000=$I$1 limits the range used by effectively making 0 check dates outside or range of interest
     Let arrTemp() = Evaluate("=IF({1},MATCH(F2:F" & M & ",Int(B2:B" & M & ")*($A$2:$A$1000=$I$1),0))")   '  $A$2:$A$1000=$I$1 gives us an array full of  Falses and Trues , which Excel will interpret mathematically as 0 or 1   This has the effect of giving us a 0 multiplyer on numbers outside our range of interst, so in total a 0 for outside our range of interest.   Our range of interest gets a 1 multiplier so has therefore no change and we can find those numbers whereas we wont find a 0, well actually we will find a zero if the range to search for has a zero as it does further down, so we take care of that in the next line
     ' The above formula has one problem with the supplied data in that empty cells are seen in this formula as 0 which gives a match
     Let arrTemp() = Evaluate("=IF(F2:F" & M & "=0,0,MATCH(F2:F" & M & ",C2:C" & M & "*(A2:A" & M & "=I1),0))")   '   In looking in the range to find a match in ( the range to be searched we have all 0s outside the range caused by the previous $A$2:$A$1000=$I$1  So the first of these 0s will be seen as the match cell for all cells in  F  that are empty.  So i take care here of the situation where an empty cell in  F  is by  giving a  0  output   So far two things retrn me a zero.   You often find in formula building that the coercing  If({1},___) suddenly is not needed. Her we find that the newly used here  IF(F2:F463=0,0,___)  is doing the required co oecing
     ' we will now do a simple  If(ISERROR( ) , Row( ) , 0 ) on the above . This will give us a row indicie for the missing data,  and  a  0  for the found data
     Let arrTemp() = Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)")
     ' At this point we have wanted data or zeros. I want to conveniently use some VB string fuction which annoyingly on work on 1 D arrays, so we convert it by a transpose in the next code line
     'Let arrTemp() = Application.Transpose(arrTemp())
     ' Or
     Let arrTemp() = Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)"))
     
     
     ' The next few lines get rid of the  0s   ( 2 lines commented out to prevent the shortened line messing up )
    Dim StrTemp As String: Let StrTemp = "#" & Join(arrTemp(), "#") ' Convert the array to a string with a  #  in between each data.  The extra # allows us to remove all  0  entries via removing all  #0  Without this we might get one left at the start
    ' Let StrTemp = Replace(StrTemp, "#0", "", 1, -1, vbBinaryCompare) ' This effectiveely removes the  0s   data ( and its seperator )
    ' Let StrTemp = Mid(StrTemp, 2) '  Because I omit the third optional ( length ) argument I get all the remaing string after the first one. This effectively takes off the extra  #  which I don't need
    Dim arrStrTemp() As String: Let arrStrTemp() = Split(StrTemp, "#", -1, vbBinaryCompare) ' remake the array
    ' Or ,
     Let arrStrTemp() = Split(Mid(Replace("#" & Join(Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)")), "#"), "#0", ""), 2), "#")
     ' We need a "vertical" array for output, so we  transpose to the original orientation, and I need a variant type for that regardless of if  i use the in built  Transpose  way or my preferred  Index  way since  both those will return elements in Variant type
     Let arrTemp() = Application.Transpose(arrStrTemp())
    ' Or
     Let arrTemp() = Application.Transpose(Split(Mid(Replace("#" & Join(Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)")), "#"), "#0", ""), 2), "#"))
     Let arrTemp() = Application.Index(Worksheets("Sheet1").Columns(6), arrTemp(), 1) ' finally we want the  dates  ( so far we have the row indicies obtained from  Match   Note. this formula has the problem that we get the results  a row out of step... Its actually very convenient because if i use  Cells typically, here a column  then I have a nice solution
    ' Or
     Let arrTemp() = Application.Index(Worksheets("Sheet1").Columns(6), Application.Transpose(arrStrTemp()), 1) ' finally we want the  dates  ( so far we have the row indicies obtained from  Match   Note. this formula has the problem that we get the results  a row out of step... Its actually very convenient because if i use  Cells typically, here a column  then I have a nice solution
    ' Or
     Let arrTemp() = Application.Index(Worksheets("Sheet1").Columns(6), Application.Transpose(Split(Mid(Replace("#" & Join(Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)")), "#"), "#0", ""), 2), "#")), 1)
     Let Range("T2").Resize(UBound(arrTemp(), 1), 1).Value = arrTemp()
    ' Or
     Let Range("T2").Resize(UBound(arrTemp(), 1), 1).Value = Application.Index(Worksheets("Sheet1").Columns(6), Application.Transpose(Split(Mid(Replace("#" & Join(Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)")), "#"), "#0", ""), 2), "#")), 1)
     Let Range("T2").Resize(UBound(Application.Index(Worksheets("Sheet1").Columns(6), Application.Transpose(Split(Mid(Replace("#" & Join(Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)")), "#"), "#0", ""), 2), "#")), 1), 1), 1).Value = Application.Index(Worksheets("Sheet1").Columns(6), Application.Transpose(Split(Mid(Replace("#" & Join(Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)")), "#"), "#0", ""), 2), "#")), 1)
    
     Let Range("T2").Resize(UBound(arrTemp(), 1), 1).NumberFormat = "yyyy/mm/dd" '  from macro recorder .NumberFormat = "[$-1010000]yyyy/mm/dd,@"
    
    Stop
     Range("T2").Resize(UBound(arrTemp(), 1), 1).ClearContents
      
    End Sub
    Sub SingleLinePretty3dTranspose()
    Dim M As Long: Let M = Worksheets("Sheet1").Range("A" & Worksheets("Sheet1").Rows.Count & "").End(xlUp).Row
     Let Range("T2").Resize(UBound(Application.Index(Worksheets("Sheet1").Columns(6), Application.Transpose(Split(Mid(Replace("#" & Join(Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)")), "#"), "#0", ""), 2), "#")), 1), 1), 1).Value = Application.Index(Worksheets("Sheet1").Columns(6), Application.Transpose(Split(Mid(Replace("#" & Join(Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=I1),0)*(A2:A" & M & "=I1)),ROW(F2:F" & M & "),0)")), "#"), "#0", ""), 2), "#")), 1)
    End Sub
    
    Function ShortPretty3dFunctionTranspose(ByVal Nme As String) As Variant
    Dim M As Long: Let M = Worksheets("Sheet1").Range("A" & Worksheets("Sheet1").Rows.Count & "").End(xlUp).Row
     Let ShortPretty3dFunctionTranspose = Application.Index(Worksheets("Sheet1").Columns(6), Application.Transpose(Split(Mid(Replace("#" & Join(Application.Transpose(Evaluate("=IF(ISERROR(MATCH(F2:F" & M & ",Int(B2:B" & M & ")*(A2:A" & M & "=" & """" & Nme & """" & "),0)*(A2:A" & M & "=" & """" & Nme & """" & ")),ROW(F2:F" & M & "),0)")), "#"), "#0", ""), 2), "#")), 1)
    End Function
    Sub TestShortPretty3dFunctionTranspose()
    Dim arrTemp() As Variant
     Let arrTemp() = ShortPretty3dFunctionTranspose("aa")
     Range("T2").Resize(UBound(arrTemp(), 1), 1).ClearContents
     Let Range("T2").Resize(UBound(arrTemp(), 1), 1).Value = arrTemp()
     Let Range("T2").Resize(UBound(arrTemp(), 1), 1).NumberFormat = "yyyy/mm/dd"
    End Sub
    Attached Files Attached Files

Similar Threads

  1. Replies: 189
    Last Post: 02-06-2025, 02:53 PM
  2. Replies: 539
    Last Post: 04-24-2023, 04:23 PM
  3. Appendix Thread. 3 *
    By DocAElstein in forum Test Area
    Replies: 540
    Last Post: 04-24-2023, 04:23 PM
  4. Replies: 293
    Last Post: 09-24-2020, 01:53 AM
  5. Appendix Thread. Diet Protokol Coding Adaptions
    By DocAElstein in forum Test Area
    Replies: 6
    Last Post: 09-05-2019, 10:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •