Home Authors Posts by Prashanth K V

Prashanth K V

Prashanth K V
1624 POSTS 2437 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
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 K V 0

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

Prashanth K V 0
Mode of Comma-Separated Numbers in Google Sheets

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

Prashanth K V 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 K V 0
Count consecutive workday absences in Google Sheets using a formula that skips weekends and holidays

Count Consecutive Workday Absences in Google Sheets

Prashanth K V 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 K V 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 K V 0
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
1...91011...136Page 10 of 136