DEV Community

#spreadsheets

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How to Fuzzy Match in Google Sheets (3 Ways)

How to Fuzzy Match in Google Sheets (3 Ways)

Comments
5 min read
Test the Business Asset Disposal Relief conditions in a spreadsheet

Test the Business Asset Disposal Relief conditions in a spreadsheet

Comments
12 min read
Match Names with Typos in Google Sheets (Fuzzy Name Matching)

Match Names with Typos in Google Sheets (Fuzzy Name Matching)

Comments
4 min read
Printing address labels for holiday cards from a spreadsheet

Printing address labels for holiday cards from a spreadsheet

Comments
4 min read
XLOOKUP vs VLOOKUP: switch for new files, keep the old ones

XLOOKUP vs VLOOKUP: switch for new files, keep the old ones

Comments
4 min read
How to make a pivot table in Excel in five steps (no formulas)

How to make a pivot table in Excel in five steps (no formulas)

Comments
4 min read
#NAME? "Unknown function" in Google Sheets: fix the misspelled function name

#NAME? "Unknown function" in Google Sheets: fix the misspelled function name

Comments
2 min read
FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first

FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first

Comments
2 min read
Our Fuel Card Statement Went Through Excel and Three Drivers Were Accused of Buying Each Other's Diesel

Our Fuel Card Statement Went Through Excel and Three Drivers Were Accused of Buying Each Other's Diesel

1
Comments
2 min read
Did that cancellation actually work? A cancellation check log in Google Sheets

Did that cancellation actually work? A cancellation check log in Google Sheets

Comments
5 min read
How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)

How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)

Comments
6 min read
IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip

IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip

Comments 1
3 min read
How to Reconcile Marketplace Sales, Fees, Refunds and Payouts in a Spreadsheet

How to Reconcile Marketplace Sales, Fees, Refunds and Payouts in a Spreadsheet

Comments
7 min read
Formula parse error in Google Sheets after pasting a formula: commas vs semicolons

Formula parse error in Google Sheets after pasting a formula: commas vs semicolons

Comments
2 min read
How to Build a Monthly Budget Spreadsheet with Formulas

How to Build a Monthly Budget Spreadsheet with Formulas

Comments 1
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.