My Excel Solutions

FIND UNIQUE NAMES

Custom Format in Excel | Display Number Lakh into Crores in Excel

Advanced Filter with Searchable key | Data Filter in another Sheet

Record Macro in Excel | Macro | How to Record Macro in Excel

DATA VALIDATION in Excel

Create PDF of Selected Range

Sumifs with Date Range (1100)

Housie Game in Excel

COUNT CELL WORD AND CHARACTER

1018 : Pivot Table in Excel | Auto Refresh in Pivot Table | Pivot Table with Auto Refresh

1011 : Searchable drop down list for multiple cells in excel in Hindi | Drop down list in Excel

1003 : Add ZERO before number in Excel | convert TEXT to VALUE | Convert Value to TEXT in Excel

Measurement conversion in excel | Search | MID MOD ABS LEFT INT CONVERT IFERROR

Age / Tenure Calculation | DATEDIF Function in Excel

SHEET FUNCTIONS | Create Multiple sheet from List

HIGHLIGHT ALTERNATE ROW | Conditional Formatting with ROW + MOD

1013 : GST Invoice free download excel file | Automatic GST Invoice in Excel

Numbers Lakh Crore in Excel | Number Format with condition | Number Lacs | Number in Crores (1099)

1015 : Hand written or typed image or PDF convert in Word | Translate PDF file in other Language

TYPE FILE NAME / SHEET NAME IN CELL WITH OR WITHOUT PATH

FILL SERIES | Generate Series

FIND UNIQUE NAMES

Highlight Row with other reference | Conditional Formatting

Long footer in Excel | Footer more then 255 character in excel (1103)

COUNT ODD AND EVEN NUMBER

PERCENT || PERCENTRANK || PERCENTILE

TIME ROUND IN 10/15/30 MINUTES (1095)

SUM HOUR MINUTES || Right way to SUM hour:Minute (1092)

Highlight active cell row column and both (1102)

Select and Copy Visible cells 4 ways

HIGHLIGHT BLANK AND FORMULA CELLS (1098)

AVERAGE AND WEIGHTED AVERAGE (1094)