Prashant Gupta

Make Google Sheets enter "London" in column D every time I enter "Diana" in Column C

Compare two cells for Exact match (Case sensitive) in Excel

Checkbox (Form Control) in Excel VBA

Excel: Compare two columns using Vlookup

Excel VBA: an example on IIF statement

Excel: split two-line rows into separate rows

Save Excel file as PDF using VBA- Tutorial 2

Capitalize first letter of each word within cell in Excel

Add all borders to a selected range in Excel using VBA

Change the font of checkbox (ActiveX) in Excel VBA

Macro to convert worksheet data to PDF file in Excel

Use Vlookup to compare two columns in Excel

Count number of values based on criteria in another column in Excel

Excel: Hide already used items in drop down list

Filter one column based on values of another column in Excel

Return the date of previous or current Monday for a given date in Excel

Separate phone numbers as per different country codes in Excel

Calculate sum of values for a given day in Excel

Highlight blank cells using Conditional Formatting in Excel

Filter by cell background color in Excel using VBA

Excel: filter by color

Create Google docs in landscape mode

Highlight an entire row in excel based on one cell value

Two dimensional array in Excel VBA

An example of message box command with InputBox command in Excel VBA

Add 1 before phone numbers in Excel

Excel: hide percentage symbol without changing the values

Replace multiple strings in Excel in one go

Change Idle timeout on Yahoo Messenger

Count cells containing specific text in Excel

Search whether a text exists within a range or not in Excel

Remove dollar sign from values in Excel

Find largest & smallest negative value from a range in Excel

Highlight decimal numbers from an array in Excel using Conditional Formatting

Round prices to x.99 with formulas in Excel

Find your computers operating system name and version using Excel VBA

Consolidate data from multiple worksheets in Excel

Separate area code from phone number in Excel

Insert checkbox (ActiveX) in Userform in Excel VBA

Excel: hide row numbers & column letters

Remove formulas in Excel and keep the values as text

Remove parentheses (brackets) in Excel

Find the last value in a row in Excel using formula

Delete blank cells in Excel

Convert numbers to text in bulk with a single click in Excel

Calculate Yes or No percentage from a list in Excel

Remove hours & minutes from dates in Excel

Check if a range contains a value greater than zero in Excel

IF D5=10 then D7 must be Sheet3 E5 in Excel

Extract text between parenthesis (brackets) in Excel

Hide rows based on color in Excel