Home Authors Posts by Prashanth KV

Prashanth KV

Prashanth KV
1538 POSTS 2412 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 Twitter
Example showing custom sort order of QUERY pivot headers with multiple aggregation columns in Google Sheets

Custom Order for QUERY Pivot Headers in Google Sheets

Prashanth KV 0
Calculating trip duration by month from a list of start and end dates in Google Sheets

Calculate Trip Days by Month (Start, End, and Full Days) in...

Prashanth KV 0

Mode of Comma-Separated Numbers in Excel (Dynamic Array)

Prashanth KV 0
Mode of Comma-Separated Numbers in Google Sheets

How to Find Mode of Comma-Separated Numbers in Google Sheets

Prashanth KV 0
Example showing the count of merged cells in a column in Google Sheets using a formula

How to Count Merged Cells in Google Sheets (and Get Their...

Prashanth KV 0
Count consecutive workday absences in Google Sheets using a formula that skips weekends and holidays

Count Consecutive Workday Absences in Google Sheets

Prashanth KV 0
Stacked bar chart in Google Sheets visualizing top N sellers for top N products using chart-ready formula output

Top N Products and Top N Sellers in Google Sheets (Top...

Prashanth KV 0
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
123...154Page 1 of 154