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

XLOOKUP with Match Mode 3 in Excel (Regex Match)

Prashanth K V 0
Example of converting a Google Sheets calendar into a structured table

Convert Google Sheets Calendar into a Table

Prashanth K V 0
Filter Today's Events from a Calendar Layout in Google Sheets

Filter Today’s Events from a Calendar Layout in Google Sheets

Prashanth K V 0
Example of Column Total in the First Row of a Structured Table in Google Sheets

Google Sheets Structured Table: Column Total in the First Row

Prashanth K V 0
Example of hierarchical number sorting in Excel, demonstrating how numbers are organized in a multi-level structure

Hierarchical Number Sorting in Excel with Modern Functions

Prashanth K V 0
Example of summing every 7 rows in Excel using a drag-down formula

Dynamic Formula to Sum Every 7 Rows in Excel

Prashanth K V 0
Example of Extracting All Numbers from Text in Excel Using Regex

How to Extract Numbers from Text in Excel with Regex

Prashanth K V 0
Example of using OFFSET and MATCH together in Google Sheets

Using OFFSET and MATCH Together in Google Sheets: Advanced Tips

Prashanth K V 0
Using OFFSET and XMATCH functions to extract values between one distinct value and another duplicate value in Excel

How to Use OFFSET and XMATCH Functions Together in Excel

Prashanth K V 0
Spreadsheet example of maximum drawdown calculation

How to Calculate Maximum Drawdown in Excel and Google Sheets

Prashanth K V 0
Example of a running count calculated using structured table references in Google Sheets

Running Count with Structured References in Google Sheets

Prashanth K V 0
Running total using structured table references in Google Sheets - array formula

Running Total with Structured Table References in Google Sheets

Prashanth K V 0
1...121314...135Page 13 of 135