[Affiliate]
Blog Stats
- 3,266,374 hits
-
Join 3,244 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Rename column names in a dynamic way with #Excel #PowerQuery
- Show number in thousand (k) or in million (M) by using custom format
- Perform VLOOKUP with 2 lookup values
- Highlight weekends and holidays using Conditional Formatting in #Excel
- How to put the Date Modified info on #Excel worksheet using #PowerQuery
- #Excel Add current selection to filter. What it does?
- Insert blank columns to table in #PowerBI Desktop
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- When unhide row doesn't work...
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: Excel 365
Create Sequential Numbers in #Excel Easily
There are multiple ways to create a list of sequential numbers in Excel. The most common one should be simply type 1 in a cell, followed by drag and drop (fill-series). Another common approach would be using a simple formula … Continue reading
#Excel IMAGE function is great, but…
If you are using #Excel365, you have the privilege of many powerful functions. IMAGE is one of them! This function works like a charm with just one argument required. Think about a simple formula like this: =IMAGE(A1) It returns the … Continue reading
Combine contents in a range of cells into a singe cell, with TEXTJOIN function in #Excel365
A decade ago, I wrote a blog post about the same in an no-formula approach. Ten years has past and Excel has evolved so much. With Excel 365, the same task can be performed in an efficient and effective manner … Continue reading
VLOOKUP across tables is so easy in #Excel365
Again, a picture tells a thousand words. The following GIF shows what we want to achieve: Seriously? A simple VLOOKUP formula stated below would do. What’s the challenge? =VLOOKUP(G3,B:E,4,FALSE) Yes, you are right if all these tables reside on the same worksheet. What if … Continue reading
Split text with delimiter(s) into columns or rows and even table with TEXTSPLIT in #Excel365
It’s a common task to split text into columns in Excel. We can do that with “Text to Columns” under Data tab. That’s very handy, however it returns only static result (good for one off task) and could not split … Continue reading
Quick #Excel 365 Tip – Combine values from a range of cells into comma separated text
Before 365, this needs to be entered into the CONCATENATE function one by one, not to mention the commas in between. With Excel 365, use the function: ARRAYTOTEXT. Bingo! Say the range of text resides in A1:A9. All you need … Continue reading
Pad a column to fixed length with #Excel formula
Here’s the situation: We have a column of values with various lengths, from 1 to 5 letters. We want to convert that into a fixed length of, say 5 letters, padding with zero(s). The following screenshot illustrates the requirement. How … Continue reading
Simple Basket Analysis – Formula approach with #Excel 365
The challenge – How many transactions with just Brand A and B together? In my previous post / video, I solved this problem with Power Query. If you are using #Excel 365, did you know you can solve this problem … Continue reading
Posted in Excel 365, Excel in Action, Formula
Tagged ARRAYTOTEXT, Filter, Sort, UNIQUE
Leave a comment
Distinct count using functions in #Excel 365 is so easy
Have your ever wanted to count how many distinct items in a range? Though a common task, there was not build-in functional for it. Perhaps we can make a distinct list using advanced filter first then we count the outcome. … Continue reading
The modern way to shortcut in #Excel 365
We all know that shortcut keys boost productivity in Excel as we can perform certain actions quickly with just a few keystrokes… if we can memorize the shortcut key combinations. Be frank, how many shortcut keys do you remember? Normally, … Continue reading
Copy values from Status Bar in #Excel 365
You probably knew it… In Excel, when multiple cells are selected, we will see basic statistics of the selected cells in status bar: This is a very handy feature. But did you know… this handy feature has a nice touch … Continue reading
Workbook Statistics in #Excel 365
Whichever version of Excel you are using, you will see a lot of useful information about your worksheet/workbook in the Status Bar. Having said, many users are not aware of the presence of the status bar. Are you one of … Continue reading
Unhide multiple sheets with #Excel 365
Photo Hunt time – What are the differences between the two screenshots? Three, Two, One… Answer: Did you see it? The long-awaited feature is finally here in Excel 365. The next question is how?
Unselect selected cells with #Excel 365
First of all, I wish you a happy, healthy, and Excellent new year of 2023! Unselect selected cells Maybe you knew this already … we can select multiple cells/ranges by holding CTRL key. However, there was no way to unselect … Continue reading
wmfexcel 