|
|
|
|
#1
11-15-2023, 06:24 PM
|
||||
|
||||
Two offers in the attached:
1. In Sheet1 cell E1, a formula (lambda). Also derivation of the lambda formula in cell E7 This cell is not needed, only there for information. See Defined names. 2. In sheet Sheet1 PQ, a Power Query solution. Should the data in the source columns A & B change, the result table at cell D1 will need refreshing by right-clicking anywhere in that results table and choosing Refresh. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Unique data per record in mail merge chart
|
aplarsen | Word VBA | 2 | 02-16-2018 04:01 PM |
| Pulling Unique Data from a Table A Certain Number of Times (Advanced) | nath1235 | Excel | 3 | 09-14-2017 04:21 PM |
|
Appending unique data from one worksheet to existing data on another worksheet
|
EdStockton | Excel | 1 | 08-06-2014 11:00 PM |
| Excel list to Word with Page Break on new unique data | jeverett1 | Mail Merge | 3 | 07-30-2014 11:59 AM |
|
data roll up under unique identifier
|
NewGirl | Mail Merge | 1 | 11-15-2012 04:47 PM |
Windows 10 
Office 2021
Hybrid Mode