recentpopularlog in

excel

« earlier   
How to Use XLOOKUP in Excel: VLOOKUP on Steroids | Tom's Hardware
First added to current release versions of Excel in February 2020, XLOOKUP is meant to improve upon the popular VLOOKUP function. It also does everything that HLOOKUP does. 

Advantages of XLOOKUP over VLOOKUP:
- Can copy multiple columns at once.
- Doesn't require the reference cell to be in first cell on the left
- Defaults to exact matches only (VLOOKUP didn't)
- Can use wildcards for inexact matches
- Lets you specify "not found" text for when there are no matches
- Only three required parameters
Excel  How-to 
yesterday by jasonsamuels
amzn/computer-vision-basics-in-microsoft-excel: computer vision basics in microsoft excel (using just formulas)
"computer vision is often seen by software developers and others as a hard field to get into. in this article, we'll learn computer vision from basics using sample algorithms implemented within microsoft excel, using a series of one-liner excel formulas."
cv  excel 
yesterday by chl
Twitter
Tip - Easily create a searchable drop down list in using the FILTER function.
Excel  twinztalk  twinztechtip  347  from twitter
2 days ago by dtomoff
paulhodel/jexcel: jExcel is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with Excel or any other spreadsheet software.
jExcel is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with Excel or any other spreadsheet software. - paulhodel/jexcel
javascript  excel  spreadsheet 
2 days ago by geetarista

Copy this bookmark:





to read