Home Authors Posts by Prashanth KV

Prashanth KV

Prashanth KV
1594 POSTS 2432 COMMENTS
Your Trusted Google Sheets and Excel Expert Prashanth KV 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
Using ARRAYFORMULA with XLOOKUP to apply lookup to entire structured column in Google Sheets

Use XLOOKUP in a Structured Table in Google Sheets (Single and...

Prashanth KV 0
Running total resets by category using SCAN

Reset SCAN by Another Column in Google Sheets and Excel

Prashanth KV 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 KV 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 KV 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 KV 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 KV 0
Sorting pie slices with aggregating data

How to Sort Pie Slices in Google Sheets

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

Filter Items Unique to Groups in Google Sheets

Prashanth KV 0
Highlighting items that appear in all columns in the range

Find Common Items Across Multiple Columns in Google Sheets

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

Sort Column by Length of Text in Google Sheets

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

Dynamic Way to Insert Blank Rows in a Table in Excel

Prashanth KV 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 KV 0
1...789...133Page 8 of 133