[Affiliate]
Blog Stats
- 3,324,640 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Dropdown calendar in Excel
- Perform VLOOKUP with 2 lookup values
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- Copy data from strictly-protected sheet
- Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
- Convert an 8-digit number into Excel-recognizable Date
- About
- Advanced vlookup - wildcard characters "?" and "*"
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Sequential number for visible rows only
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Keep Unique
A twist to turn Keep Duplicates into Keep Unique in #PowerQuery
In Power Query Editor, there is a button of “Keep Duplicates” in the ribbon. It’s located under Keep Rows in the section of Reduce Rows in the Home tab of the ribbon. With this, it is super easy … Continue reading



