ISNUMBER Archives - Xelplus - Leila Gharani

How to Create Excel Searchable Drop-Down Lists for Every Row

Leila Gharani — Thu, 16 Apr 2020 09:00:00 +0000

Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it much easier to find an item from a large data validation list.

The post How to Create Excel Searchable Drop-Down Lists for Every Row appeared first on Xelplus - Leila Gharani.

How to Create a Barcode in Excel

Leila Gharani — Thu, 06 Feb 2020 10:00:00 +0000

Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

The post How to Create a Barcode in Excel appeared first on Xelplus - Leila Gharani.

Excel Function to Check IF Cell Contains Specific Text

Leila Gharani — Sat, 01 Jun 2019 22:31:00 +0000

How can you use wildcards in Excel's IF Function - with this method you can easily check for a partial text match. It's a clever method to get the IF function to check if the cell value contains a word.

The post Excel Function to Check IF Cell Contains Specific Text appeared first on Xelplus - Leila Gharani.

Searchable Drop Down List in Excel (With FILTER Function)

Leila Gharani — Fri, 25 Jan 2019 16:16:00 +0000

This is the easiest searchable drop-down list you'll be creating in Excel. It uses the new Excel FILTER function and dynamic array functionality. Download the workbook to practice along.

The post Searchable Drop Down List in Excel (With FILTER Function) appeared first on Xelplus - Leila Gharani.

Excel Custom Data Validation

Leila Gharani — Thu, 24 May 2018 06:49:00 +0000

Learn how to create data validation rules with formulas for custom conditions, such as alphanumeric codes or ids that have to follow a specific pattern. With formula, you can check for text, numbers & length of the entered text.

The post Excel Custom Data Validation appeared first on Xelplus - Leila Gharani.