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
Running total resets by category using SCAN

Reset SCAN by Another Column in Google Sheets and Excel

Prashanth K V 0
Example of how to get the fastest time for each person in Google Sheets

How to Get the Fastest Time for Each Person in Google...

Prashanth K V 0
Example of highlighting the smallest N values in each column in Google Sheets

Highlight the Smallest N Values in a Column in Google Sheets

Prashanth K V 0
Example showing how to sort each row individually in Excel using a LAMBDA formula

Sort Each Row Individually in Excel Using a LAMBDA Formula

Prashanth K V 0
Sort data by field label selected from a drop-down list in Excel

Sort by Field Labels Using the SORT and XMATCH Combo in...

Prashanth K V 0
Sorting pie slices with aggregating data

How to Sort Pie Slices in Google Sheets

Prashanth K V 0
Example of Filtering Names Unique to Groups in Google Sheets

Filter Items Unique to Groups in Google Sheets

Prashanth K V 0
Highlighting items that appear in all columns in the range

Find Common Items Across Multiple Columns in Google Sheets

Prashanth K V 0
Sort Column by Length in Google Sheets with the QUERY Function

Sort Column by Length of Text in Google Sheets

Prashanth K V 0
Example of inserting two blank rows in a table in Excel

Dynamic Way to Insert Blank Rows in a Table in Excel

Prashanth K V 2
Example of inserting empty cells between values in a column in Excel using a dynamic array formula

Insert N Empty Cells Between Values in Excel (Dynamic Array)

Prashanth K V 0
Extract the last N non-blank rows in Excel dynamically

How to Extract the Last N Non-Blank Rows in Excel Dynamically

Prashanth K V 0
1...91011...135Page 10 of 135