Home Authors Posts by Prashanth K V

Prashanth K V

Prashanth K V
1617 POSTS 2436 COMMENTS
Your Trusted Google Sheets and Excel Expert Prashanth K V is a Diamond Product Expert in Google Sheets, officially recognized by Google for his contributions to the Docs Editors Help Community and featured in the Google Product Experts Directory. Explore his blog to learn advanced formulas, automation tips, and problem-solving techniques to elevate your spreadsheet skills.
Facebook Pinterest X

How to Jump to the Current Date Cell in Excel

Prashanth K V 0
Example of a dynamic total row added to FILTER function results

Adding a Dynamic Total Row to Excel FILTER Function Results

Prashanth K V 0

How to Apply Nested Column and Row Filters in Excel

Prashanth K V 0
Replace the first two characters in Excel

Remove First Two Characters from a Cell in Excel – 3...

Prashanth K V 0
Highlighting parent and child columns in Excel

Excel: Highlighting Parent and Child Rows or Columns

Prashanth K V 0
Explained: Filtering data with a dropdown menu and 'All' option

Excel: Filter Data with a Dropdown and ‘All’ Option (Dynamic Array)

Prashanth K V 0
Case-sensitive running count array formula

Case-Sensitive Running Count in Google Sheets

Prashanth K V 0
Testing the fix for fractional percentage formatting in Sheets

Fix Fractional Percentage Formatting Issues in Google Sheets

Prashanth K V 0
Lookup smallest value in 2D array with matching dates in Google Sheets - Example

Lookup the Smallest Value in a 2D Array in Google Sheets

Prashanth K V 2
Duplicating Rows Based on Cell Values in a Column in Excel

How to Duplicate Rows Dynamically Based on Cell Values in Excel

Prashanth K V 0
Remove duplicates by section in a column

Unique List by Section in Excel

Prashanth K V 0
Combination of REDUCE and HSTACK functions in Excel

REDUCE Function in Excel: Transform Arrays with Ease

Prashanth K V 0
1...161718...135Page 17 of 135