DEV Community

loading...
Andrews profile picture

Andrews

Founder of Geek Excel!! Blog for Excel Tutorials

Location Denmark Joined Joined on  Twitter logo Youtube logo Mastodon logo Website logo
Work

CER at Organisee Network

How to Compare Two Ranges using Macros (VBA) in Excel 365?

How to Compare Two Ranges using Macros (VBA) in Excel 365?

Comments
3 min read
Excel Formulas: IF Function with Wildcard Characters!!

Excel Formulas: IF Function with Wildcard Characters!!

Comments
3 min read
Excel Formulas: IF Function with Other Calculations!!

Excel Formulas: IF Function with Other Calculations!!

Comments
2 min read
Deselect Cells from Selected Range using Macros (VBA) in Excel 365!!

Deselect Cells from Selected Range using Macros (VBA) in Excel 365!!

Comments
3 min read
Excel Formulas to Test If a Cell Value is X and (Y or Z)!!

Excel Formulas to Test If a Cell Value is X and (Y or Z)!!

Comments
3 min read
Excel Formulas to Check If the Cell Value is (X and Y)!!

Excel Formulas to Check If the Cell Value is (X and Y)!!

Comments
3 min read
Create Folders Based on Cell Values using Macros (VBA) in Excel 365!!

Create Folders Based on Cell Values using Macros (VBA) in Excel 365!!

Reactions 1 Comments
2 min read
Excel Formulas to Test Multiple Cells and Return Non-Blank Value!!

Excel Formulas to Test Multiple Cells and Return Non-Blank Value!!

Comments
3 min read
Excel Formulas to Check If the Cell Value is NOT This or That!!

Excel Formulas to Check If the Cell Value is NOT This or That!!

Comments
3 min read
Merge Multiple Cells into One Cell using Macros (VBA) in Excel 365!!

Merge Multiple Cells into One Cell using Macros (VBA) in Excel 365!!

Comments
3 min read
Excel Formulas to Check If the Cell is This or That with OR Function!!

Excel Formulas to Check If the Cell is This or That with OR Function!!

Reactions 1 Comments
3 min read
Excel Formulas to Check the Cell Value Based on IF Else Condition!!

Excel Formulas to Check the Cell Value Based on IF Else Condition!!

Reactions 1 Comments
3 min read
Excel Formulas to Test If a Cell Value is (X or Y) and Z!!

Excel Formulas to Test If a Cell Value is (X or Y) and Z!!

Comments
3 min read
How to Copy a Cell to Clipboard using Macros (VBA) in Excel 365?

How to Copy a Cell to Clipboard using Macros (VBA) in Excel 365?

Comments
2 min read
How to Highlight All Errors Using Macros (VBA) In Excel Office 365?

How to Highlight All Errors Using Macros (VBA) In Excel Office 365?

Comments
2 min read
Highlight & Count a Specified Value using Macros in Excel 365!!

Highlight & Count a Specified Value using Macros in Excel 365!!

Comments
3 min read
Excel Formulas to Check If Cell Value is Greater than Given Criteria!!

Excel Formulas to Check If Cell Value is Greater than Given Criteria!!

Comments
3 min read
Excel Formulas to Find If the Cell is Not Blank ~ Simple Tutorial!!

Excel Formulas to Find If the Cell is Not Blank ~ Simple Tutorial!!

Comments
3 min read
Highlight Cells with a Single Space using Macros (VBA) in Excel!!

Highlight Cells with a Single Space using Macros (VBA) in Excel!!

Comments
2 min read
Excel formulas to Find IF Cells Equal to a Certain Value!! 

Excel formulas to Find IF Cells Equal to a Certain Value!! 

Comments
2 min read
Excel Formulas to Check If the Cell is Blank or Not!!

Excel Formulas to Check If the Cell is Blank or Not!!

Comments
3 min read
Highlight Max Value in Selection using Macros (VBA) in Excel 365!!

Highlight Max Value in Selection using Macros (VBA) in Excel 365!!

Comments
2 min read
Excel Formulas to Check If the Cells Contain This or That!!

Excel Formulas to Check If the Cells Contain This or That!!

Comments
3 min read
Excel Formulas to Check If the Cells Contain Certain Text!!

Excel Formulas to Check If the Cells Contain Certain Text!!

Comments
3 min read
Highlight Min Value in Selection Using Macros in Excel Office 365!!

Highlight Min Value in Selection Using Macros in Excel Office 365!!

Comments
2 min read
Excel Formulas to Check the Values If Cells Begin with Given Criteria!!

Excel Formulas to Check the Values If Cells Begin with Given Criteria!!

Comments
2 min read
Excel Formulas to Hide the #N/A Error with VLOOKUP Function!!

Excel Formulas to Hide the #N/A Error with VLOOKUP Function!!

Comments
3 min read
Highlight Unique Values in Selection using Macros in Excel 365!!

Highlight Unique Values in Selection using Macros in Excel 365!!

Comments
2 min read
Excel Formulas to VLOOKUP with Numbers and Text ~ Easy Steps!!

Excel Formulas to VLOOKUP with Numbers and Text ~ Easy Steps!!

Comments
3 min read
Excel Formulas to VLOOKUP with Two Client Rates!!

Excel Formulas to VLOOKUP with Two Client Rates!!

Comments
2 min read
How to Convert Selection to UPPERCASE using Macros in Excel?

How to Convert Selection to UPPERCASE using Macros in Excel?

Comments
3 min read
Excel Formulas to Lookup Two Tables with VLOOKUP Function!!

Excel Formulas to Lookup Two Tables with VLOOKUP Function!!

Comments
3 min read
How to Protect All Cells with Formulas using Macros in Excel 365?

How to Protect All Cells with Formulas using Macros in Excel 365?

Comments
2 min read
Excel Formulas to Lookup Multiple Criteria with VLOOKUP Function!!

Excel Formulas to Lookup Multiple Criteria with VLOOKUP Function!!

Comments
2 min read
Excel Formulas to VLOOKUP Override Output ~ Useful Guide!!

Excel Formulas to VLOOKUP Override Output ~ Useful Guide!!

Comments
2 min read
Excel Formulas to VLOOKUP from Another Workbook ~ Easy Tricks!!

Excel Formulas to VLOOKUP from Another Workbook ~ Easy Tricks!!

Comments
3 min read
Convert Formulas into Values using Macros (VBA) in Excel 365!!

Convert Formulas into Values using Macros (VBA) in Excel 365!!

Comments
2 min read
Excel Formulas to VLOOKUP a data From Another Worksheet!!

Excel Formulas to VLOOKUP a data From Another Worksheet!!

Comments
2 min read
Remove Extra Spaces from Selection Using Macros (VBA) in Excel!!

Remove Extra Spaces from Selection Using Macros (VBA) in Excel!!

Comments
2 min read
Remove Characters at the Start using Macros (VBA) in Excel 365!!

Remove Characters at the Start using Macros (VBA) in Excel 365!!

Comments
3 min read
Excel Formulas to VLOOKUP by Date ~ Simple Tutorial!!

Excel Formulas to VLOOKUP by Date ~ Simple Tutorial!!

Comments
3 min read
How to Find the Approximate Match with VLOOKUP in Excel?

How to Find the Approximate Match with VLOOKUP in Excel?

Comments
3 min read
Excel Formulas to Find the Two-way Lookup with VLOOKUP Function!!

Excel Formulas to Find the Two-way Lookup with VLOOKUP Function!!

Comments
2 min read
Kutools For MS Excel & Office 365 Download & Tutorials!

Kutools For MS Excel & Office 365 Download & Tutorials!

Comments
27 min read
How to use VLOOKUP to Match Two Tables with Excel Search Box?

How to use VLOOKUP to Match Two Tables with Excel Search Box?

Comments
3 min read
Add a Degree Symbol to Selection Range using Macros (VBA) in Excel!

Add a Degree Symbol to Selection Range using Macros (VBA) in Excel!

Comments
3 min read
Reverse Text Function using Macros (VBA) in Excel Office 365!!

Reverse Text Function using Macros (VBA) in Excel Office 365!!

Comments
3 min read
Excel Formulas to Find the Two-Way Approximate Match Lookup!!

Excel Formulas to Find the Two-Way Approximate Match Lookup!!

Comments
3 min read
Change Chart Type using Macros (VBA) in Excel Office 365!!

Change Chart Type using Macros (VBA) in Excel Office 365!!

Comments
3 min read
Excel Formulas to Find the Two-Way Lookup with INDEX and MATCH!!

Excel Formulas to Find the Two-Way Lookup with INDEX and MATCH!!

Comments
2 min read
How to use VLOOKUP to Create a Search Box? ~ Complete Guide

How to use VLOOKUP to Create a Search Box? ~ Complete Guide

Comments
3 min read
Resize All Charts using Macros (VBA) in Excel Office 365!!

Resize All Charts using Macros (VBA) in Excel Office 365!!

Comments
2 min read
Convert Chart into Image using Macros (VBA) in Excel Office 365!!

Convert Chart into Image using Macros (VBA) in Excel Office 365!!

Comments
3 min read
Excel Formulas to Lookup Table Based on Multiple Criteria with SUMIFS

Excel Formulas to Lookup Table Based on Multiple Criteria with SUMIFS

Comments
2 min read
Count Number of Cells with String Length Greater than X!!

Count Number of Cells with String Length Greater than X!!

Comments
2 min read
How to Add Chart Title using Macros (VBA) in Excel Office 365?

How to Add Chart Title using Macros (VBA) in Excel Office 365?

Comments
2 min read
How to Share an Excel File with Email? ~A Complete Guide!!

How to Share an Excel File with Email? ~A Complete Guide!!

Comments
2 min read
Excel Formulas to Find the Position of Maximum Value From the List!!

Excel Formulas to Find the Position of Maximum Value From the List!!

Comments
3 min read
How to Share Excel File with People? ~ A Simple Guide!!

How to Share Excel File with People? ~ A Simple Guide!!

Comments
2 min read
How to Separate Negative and Positive Values From a Column in Excel?

How to Separate Negative and Positive Values From a Column in Excel?

Comments
3 min read
loading...