Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
DEV Community
Close
#
spreadsheets
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
How to Fuzzy Match in Google Sheets (3 Ways)
Snakbacks
Snakbacks
Snakbacks
Follow
Nov 19
How to Fuzzy Match in Google Sheets (3 Ways)
#
googlesheets
#
spreadsheets
#
appsscript
#
tutorial
Comments
Add Comment
5 min read
Moderation
Test the Business Asset Disposal Relief conditions in a spreadsheet
Key Ledgers Global
Key Ledgers Global
Key Ledgers Global
Follow
Nov 19
Test the Business Asset Disposal Relief conditions in a spreadsheet
#
tax
#
spreadsheets
#
excel
#
finance
Comments
Add Comment
12 min read
Moderation
Match Names with Typos in Google Sheets (Fuzzy Name Matching)
Snakbacks
Snakbacks
Snakbacks
Follow
Nov 19
Match Names with Typos in Google Sheets (Fuzzy Name Matching)
#
googlesheets
#
spreadsheets
#
appsscript
#
tutorial
Comments
Add Comment
4 min read
Moderation
Printing address labels for holiday cards from a spreadsheet
Label Peel
Label Peel
Label Peel
Follow
Nov 18
Printing address labels for holiday cards from a spreadsheet
#
spreadsheets
#
excel
#
printing
#
tutorial
Comments
Add Comment
4 min read
Moderation
XLOOKUP vs VLOOKUP: switch for new files, keep the old ones
Daylongs
Daylongs
Daylongs
Follow
Nov 17
XLOOKUP vs VLOOKUP: switch for new files, keep the old ones
#
excel
#
xlookup
#
vlookup
#
spreadsheets
Comments
Add Comment
4 min read
Moderation
How to make a pivot table in Excel in five steps (no formulas)
Daylongs
Daylongs
Daylongs
Follow
Nov 16
How to make a pivot table in Excel in five steps (no formulas)
#
excel
#
spreadsheets
#
productivity
Comments
Add Comment
4 min read
Moderation
#NAME? "Unknown function" in Google Sheets: fix the misspelled function name
SheetError
SheetError
SheetError
Follow
Nov 16
#NAME? "Unknown function" in Google Sheets: fix the misspelled function name
#
googlesheets
#
spreadsheets
#
productivity
#
tutorial
Comments
Add Comment
2 min read
Moderation
FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first
SheetError
SheetError
SheetError
Follow
Nov 12
FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first
#
googlesheets
#
spreadsheets
#
productivity
#
tutorial
Comments
Add Comment
2 min read
Moderation
Our Fuel Card Statement Went Through Excel and Three Drivers Were Accused of Buying Each Other's Diesel
Serguey Shinder
Serguey Shinder
Serguey Shinder
Follow
Nov 10
Our Fuel Card Statement Went Through Excel and Three Drivers Were Accused of Buying Each Other's Diesel
#
sergueyshinder
#
data
#
spreadsheets
#
fleet
1
 reaction
Comments
Add Comment
2 min read
Moderation
Did that cancellation actually work? A cancellation check log in Google Sheets
Richard C
Richard C
Richard C
Follow
Nov 9
Did that cancellation actually work? A cancellation check log in Google Sheets
#
googlesheets
#
productivity
#
personalfinance
#
spreadsheets
Comments
Add Comment
5 min read
Moderation
How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)
Sheet & Flow
Sheet & Flow
Sheet & Flow
Follow
Nov 9
How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)
#
excel
#
spreadsheets
#
realestate
#
tutorial
Comments
Add Comment
6 min read
Moderation
IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip
SheetError
SheetError
SheetError
Follow
Nov 10
IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip
#
googlesheets
#
spreadsheets
#
productivity
#
tutorial
Comments
1
 comment
3 min read
Moderation
How to Reconcile Marketplace Sales, Fees, Refunds and Payouts in a Spreadsheet
Seller Sheets Lab
Seller Sheets Lab
Seller Sheets Lab
Follow
Nov 7
How to Reconcile Marketplace Sales, Fees, Refunds and Payouts in a Spreadsheet
#
spreadsheets
#
tutorial
#
bookkeeping
#
ecommerce
Comments
Add Comment
7 min read
Moderation
Formula parse error in Google Sheets after pasting a formula: commas vs semicolons
SheetError
SheetError
SheetError
Follow
Nov 7
Formula parse error in Google Sheets after pasting a formula: commas vs semicolons
#
googlesheets
#
spreadsheets
#
productivity
#
tutorial
Comments
Add Comment
2 min read
Moderation
How to Build a Monthly Budget Spreadsheet with Formulas
Seller Sheets Lab
Seller Sheets Lab
Seller Sheets Lab
Follow
Nov 5
How to Build a Monthly Budget Spreadsheet with Formulas
#
spreadsheets
#
tutorial
#
productivity
#
beginners
Comments
1
 comment
5 min read
Moderation
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account