Excel Magic Trick 1402 Part 4: UNICHAR & UNICODE Functions for Unicode Value

preview_player
Показать описание
Download Files:

Part 4

Part 5

Learn about UNICHAR & UNICODE Functions for Unicode Values by putting a check in the cell when the value is greater than zero. This is a cool trick from Oxyz at YouTube.
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:03:41

Excel Magic Trick 1402 Part 2 Formula to Put Check Mark In Cell If Number Great than 0 without CHAR

Excel Magic Trick 0:05:59

Excel Magic Trick 1402 Part 3: Power Query to Put Check Mark In Cell If Number Greater Than 0

Excel Magic Trick 0:06:05

Excel Magic Trick 1402: Formula to Put Check Mark In Cell If Number Greater Than Zero

Excel Magic Trick 0:02:21

Excel Magic Trick 1402 Part 5: Conditional Formatting to Show Check Mark When Number Bigger Than 0

Excel Magic Trick 0:04:43

Excel Magic Trick 1402 Part 4: UNICHAR & UNICODE Functions for Unicode Value

Excel Magic Trick 0:10:20

Excel Magic Trick 1450: Replace VLOOKUP When Making PivotTables with Excel 2016 Relationships

Excel Magic Trick 0:19:34

Excel Magic Trick 1400 Part 2: Conditionally Format Row with Complex Criteria (3 More Examples)

Excel Magic Trick 0:10:51

Excel Magic Trick 1400: Conditionally Format Row in Class Enrollment Table with Complex Criteria

Excel Magic Trick 0:08:54

Excel Magic Trick 1442 DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In Li...

Excel Magic Trick 0:11:22

Excel Magic Trick 1403: DAX Formulas: Explicit or Implicit Measures? Why Explicit is Better.

Excel Magic Trick 0:03:54

Excel Magic Trick 1399: Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula

Excel Magic Trick 0:12:46

Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables

Show Formula & 0:03:35

Show Formula & Cell Location with Excel Text Formula, Unicode Arrow too - Excel Magic Trick 1584

Excel Magic Trick 0:04:41

Excel Magic Trick 1404: Sales Per Working Day by Month using Power Query

Excel Magic Trick 0:06:07

Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Tota...

Excel Magic Trick 0:11:08

Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)

Excel Magic Trick 0:07:27

Excel Magic Trick 1401: Conditionally Format Row For BOLD Date

Excel Magic Trick 0:19:28

Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Ch...

Excel Formula for 0:03:29

Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604

Excel Magic Trick 0:18:52

Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & Mor...

Excel Magic Trick 0:16:08

Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Example...

Excel Magic Trick 0:06:07

Excel Magic Trick 1414: Power Query Text.PadStart Function to Correctly Format Account Numbers

Excel Magic Trick 0:07:54

Excel Magic Trick 1368: How To get SUMIFS to Calculate Sum Of Amazon And Google Under Each Region

Excel Magic Trick 0:37:16

Excel Magic Trick 1471: Array Formula: Add Daily Rainfall 5 AM to 5 AM Next Day: (Most Automatic)

Комментарии
Автор

When it comes to Excel I consider Mike's YouTube Channel the ultimate resource. There is simply no equivalent when it comes to learning about formulas & functions, array formulas, Excel for Business Intelligence or even a refresher on business math. Thank you for sharing your knowledge so altruistically!

Al-Ahdal
Автор

Well that sure simplifies everything. New functions UNICODE and UNICHAR allow Conditional Formatting for checkmarks and exes (x) to be done in a single cell. Way to go Mike and 0xyz! Awesome.

drsteele
Автор

Nice Video Mike 📹 u always bring the best out there 👍

nadermounir
Автор

Just great! Thanks for sharing these functions. I hadn't used them. Always great to find gold nuggets on your channel....and there is A LOT of them :)

LeilaGharani
Автор

Mike, these tricks are awesome. thank you so much.

amitkumar-ipyv
Автор

Great job Mike. Looking forward to a part 5. Lol.

krn
Автор

Great as always!!! Thanks, Mike.
Can i propose another one way, to do this? ;-)
Copy your symbol from C14 (from formula bar).
In B18 put reference on to A18 (=A18)
Choose custom number format like this: ✅;; (first symbol is from clipboard -> CTRL+V)
Copy B18 down.
That is all ;-)

BillSzysz
Автор

Hi, I have an impossible excel question. Is there a way to use a date formula but make it fixed (not constantly recalculate), without using VBA or iternative calculation/circular referencing function?? If there is, .. sigh..

ryanjhcho
Автор

Hi Mike,
Thanks for the interesting series on checkboxes.
Please see yet another way of doing this:
Hope it is a useful addition, otherwise feel free to delete the comment.

OakleyTurvey