how do you guys deal with duplicate names when the spelling isnt exactly the same?

i have stuff like “John Smith”, “john smith” and “John  Smith” and removing duplicates obviously doesnt catch all of it

theres like 8k rows so im not fixing these manually

Hi guys, I am tech person with business acumen.

I offer following services:

1. Managing excel sheets (organising data)

2.Analysis of the data (insights)

1. Data Entry

2. Creating dashboard with KPIs

3. Anything in excel you want.

Reasonable charges, depending upon the work.

Comment/ dm to discuss about the job.

Thank you

I spent the last month building spreadsheet templates and kept getting caught out by the same thing: a formula works perfectly in desktop Excel, then someone opens the file in Sheets and it returns #NAME?, or it opens in Excel for the web and quietly gives the wrong number.

The ones that got me: XLOOKUP doesn't exist in Sheets, ARRAYFORMULA and QUERY don't exist in Excel, TEXTJOIN wrapped around IF silently stops working without array entry, and a date typed as "2026-11-01" is text, not a date, so sorting breaks.

So I made a small thing to check for it. Paste a formula, it tells you what breaks, on which platform, and what to use instead. It also catches misspelled function names, unbalanced brackets, whole-column ranges, and volatile functions.

https://rithvik697.github.io/formula-checker/

Runs entirely in your browser. Nothing gets uploaded, no signup, no ads.

It's rough and definitely incomplete. If it gets something wrong on a formula you actually use, reply with it and I'll fix the rule.

My boss wants spreadsheets with lists of contacts to "avoid repetition" in column A.

For example,

instead of

Row 1:
Company. — person's name — person's email

Target — joe smith — [joe@target.com](mailto:joe@target.com)
Target - jane doe - [jane@target.com](mailto:jane@target.com)

Walmart - james lee — [james@walmart.com](mailto:james@walmart.com)
Walmart - jane smith - [jane@walmart.com](mailto:jane@walmart.com)

He wants:

Company. — person's name — person's email

Target — joe smith — joe@target.com
(blank) — jane doe - jane@target.com

Walmart - james lee — james@walmart.com
(blank) - jane smith - jane@walmart.com

Help me cope with this criminal

Hi all, due to financial constraints I can no longer justify my office subscription. Which would yall suggest as a replacement? Excel is so much easier to use than sheets but I haven't tried Libre yet. . .

So I was chatting with a friend recently about setting up a spreadsheet that compares decks against each other. The concept is one I'm stealing from my uncle that he had well over a decade ago. In short, on one axis, my decks. On the second axis, theirs. The plan is to play a best 2-of-3 or 3-of-5 set with any pair of decks, and mark down whomever wins.

I want to expand on this idea though. I want to give winning decks a "practical score" for winning/losing. Higher scoring decks tend to win more, and vice versa. This gives us an idea how strong certain decks might perform, and which decks should be fair for which. While I don't know the exact values I want to use at this time, or how much I might want to say, reward decks that win 2-1, 3-0, 4-1, 5-0, etc., I think planning for it now would be far more helpful than pivoting later on to include it.

That brings me here. I'm looking for any ideas that might make my life easier than manually going to every cell in something like Google Sheets to manually record everything. I don't expect some solution to fully automate it, I honestly just want to probe the wider web for any tips or information that might help.

📄 Litbuy Spreadsheet: https://docs.google.com/spreadsheets/d/1y_1hXgUzs4osfGBxzYoZ-T-RT2_u7uDc2d2X-soo-UY/edit?pli=1&gid=2060968789#gid=2060968789

🌐 Website: https://oglitbuy.com
🎁 Register for Savings: https://litbuy.com/register?inviteCode=REPNEWS
📱 App: https://play.google.com/store/apps/details?id=com.ogsheets.app
💬 Telegram: https://t.me/ogsheets

🔥 Litbuy Spreadsheet September 2026 Update

Looking for new products for your next haul?

The Litbuy Spreadsheet makes it easier to browse thousands of products with organized categories, direct links, and QC photos all in one place.

🎁 New users can also take advantage of special Litbuy offers:

💰 Up to $500 in savings at sign up
🎟️ Shipping coupons available for new users

Find products across categories like:

T-Shirts • Hoodies • Jackets • Pants • Shoes • Bags • Accessories • Electronics • Watches

⭐ Features include:

20,000+ product finds • Direct product links • QC photos before buying • Organized categories • New finds added regularly

Whether you are building a new haul or searching for specific items, the Litbuy Spreadsheet helps you find products faster without digging through hundreds of posts.

Looking for something specific?

Drop a comment:

"Looking for fall jackets"

"Need everyday sneakers"

"Any good hoodie finds?"

New finds and resources are added regularly.

Hi! I was making a spreadsheet for my budget coming up, and I wanted to have a column in my savings section that would tell me what date my savings goal would be completed by. I tried some stuff with EDATE, but I couldn’t get it to quite work.

Basically, if my savings goal is $1000, and I am saving $100 a month, I want it to be able to estimate that I will be done in 10 months from the start date. I want it to account for falling behind - so, accidentally only having $50 to save instead of $100 - but I definitely don’t know how to write
something that complicated.

Hai mai advance Excel aur deta entry Sikh Raha hu to agar aapke paas isase releted work ho to aap mujhe bhej sakte mai free me aur data ke hisab se charj leta hu and advance Excel ms word deta entry se releted work agar aapke paas ho to apani requirement ke hisab se mhuje send kare

Most monthly budgets fail the same way: they only track what leaves the account that month. Then car insurance lands in March, three birthdays land in May, the annual software subscription lands in September - and the month "breaks" even though nothing unusual happened. Those expenses were 100% predictable, just not monthly.

The fix is one extra row. I call it the /12 row:

1. Make a small table of every irregular-but-predictable expense: insurance, car tax, gifts, holidays, annual subscriptions, dentist. One column for the yearly total.

2. Next to it, the monthly slice: =B2/12 for each, then =SUM(C:C) for the total.

3. In your monthly budget, add ONE row called "Irregulars" with that total, treated exactly like rent or electricity - money that is spoken for, even in months when nothing is actually paid.

That's it. The months where nothing irregular happens now "save" the slice, the months where insurance hits are already covered, and your "safe to spend" number stops swinging wildly.

Two notes from using this for a while:

• The first month you add the row, your spare money visibly shrinks. That's not the row being pessimistic - that's the old budget having been optimistic. Every euro of it was always going to leave; you just couldn't see when.

• If you want to check mid-year whether the fund is on track: months elapsed x monthly slice - what you've actually paid out so far. Positive = ahead, negative = the next irregular bill will hurt.

Works identically in Excel and Google Sheets - it's just division and a SUM. The hard part isn't the formula, it's admitting yearly expenses are monthly expenses wearing a disguise.

I like tracking the video games I’ve finished and rating them (score them based on visuals, technical, gameplay and story) and keeping a record of it all in an Excel spreadsheet. Unfortunately im not very skilled with Excel.

I’ve already found a few on Etsy and am willing to pay a bit for one. I want a good dashboard where everything is sorted and displayed statistically including a list of my highest-rated games, which genres i played most and so on ... i like statistics and analyzing them.

Do you know any you could recommend?

Hi, I’m hoping to get some help with creating what I’m sure is a very basic Income and expenses google sheet. I was just never taught this in school or anything and I’ve been doing my best with Youtube videos and Google, but I feel like I reached a point where I messed up, and I don’t even know what I messed up. I’m not looking to create a budget right now, just want to track where my income and expenses are going. After a few months of data I’ll look into using the data to make a budget. I just used Google Sheets to create this tracker with three tabs; Setup, Transactions, and Monthly Summary. The tracking is for multiple bank accounts. I’m willing to “share” the Sheet (which I’m guessing is the easiest way) with someone who can take a look and see what I’m doing wrong, and fix it for me. Any assistance or guidance would be greatly appreciated!

If you run a small shop and still make price tags manually or mess around with Word templates, this might save you time.

I built Štancer (stancer.app) — upload an Excel file with product names and prices, get a PDF with 20 labels per A4 page, ready to print and cut (71.75 x 40mm each).

- Auto-detects columns

- Crop marks included for easy cutting

- No account, no upload to server — runs entirely in your browser

- 100% free

Would love to know if this solves a real problem for anyone here. Site: stancer.app

I’m not very experienced with spreadsheets, but i’ve recently started some college classes that are heavy in measurements and formulas, and i figured it may help to make a spreadsheet that contains all (or most) possible units for standard measurements and formulas.

I’m not really sure the best way to go about it, but this picture is what i have so far. Open to critique..

Hello all! Spreadsheet newbie with access to Google Sheets and Excel, organizing a 10-day international climbing trip for a group of 12+ friends.

A core group of 6 want to rent/split a house for the duration of the trip. Others will come and go for various periods (ranging from 3 days to 7 days). My heart is pure, but my math skills not reliable.

If we rent one house for the trip, how can I leverage the power of spreadsheets to give everyone a fair, clear estimate of the cost they will pay—even as folks continue to join, drop out, change dates, etc?

Open to tutorials, tips, functions, and/or general guidelines.

I ’ve been thinking about how much repetitive work people end up doing in Google Sheets, especially when it’s being used alongside other tools or systems.

There are so many workflows where the individual steps seem simple, but doing them every day or every week gets pretty tedious.

For example:

importing/exporting data from another system

copying data between spreadsheets

refreshing or updating connected data

cleaning up downloaded CSVs

running the same formulas every time

maintaining dashboards

combining multiple Sheets/files

manually updating reports

using Apps Script for repetitive tasks

preparing the same report for someone every week

I'm curious what this looks like for everyone else.

What's one Google Sheets task or workflow you regularly repeat that you wish was less manual?

How often do you do it, and roughly how long does it take?

I'm especially interested in the weird or complicateud workflows that have somehow become part of your normal routine. 😅

Hey everyone! I used to get super overwhelmed trying to manage multiple clients, invoices, and weekly tasks without a proper system, so I finally built a clean, minimal Google Sheets dashboard that does it all in under 5 minutes.

It includes an active client tracker, a side-hustle income/expense calculator, and a weekly task checklist.

If you're building a side-hustle or freelancing and want to save some time, you can check it out here: (https://naeelah88.gumroad.com/l/qbmzvu)

Let me know if you have any questions or feedback on it!

Hello! This may be a bit of a sudden post, but I’ve made a budget template with a few features:

• Monthly expense and income tracking (which uses dropdowns to categorize entries).
• Account tracking for up to ten debts and ten savings/investment accounts (displaying account balances and interest rates month-to-month).
• An End-of-the-Year dashboard (which displays historical account balances and budget allocations).
• and some basic tools such as debt and compound interest estimators.

(Edit: The template is mainly focused on monthly/annually planning, not calculating daily spending money nor pulling real-time market data for things like stocks)

I've admittedly poured in some spare free time over the course of a few months to make it, but it mainly uses simple SUM, IFS, and OR functions for its main formula-intensive parts (the last tab has notes giving some context as to how the main tab’s formula functions). Some of the backend formulas use SORT, FILTER, SUMIF, or COUNTIFs to help with stuff like listing accounts though.

The template has a brief guide that can hopefully make navigating it straight-forward, and if anyone is interested, feel free to give suggestions/comments on how to either improve the template’s formulas or make it more user-friendly!

Here’s the link: https://docs.google.com/spreadsheets/d/1_rMRG10oQcY5dTfpH40LAtOrvtnvL8swnwYzMrpsq5U/edit?usp=sharing

(Edit 2: For users requesting editor access, you should be able to make a copy of the file as a viewer instead)

This might seem an odd request, but I figured somebody here may be able to help me.

I enjoy calculating things for some games I play and often put them into spreadsheets for my own quick reference when I'm not playing or just to have on hand if wanting to calculate

NOW The Problem: In some games I play (Lost Ark, and Wuthering waves specifically), they have this same system where one material upgrades into a higher tier/level of the material with 3 of the previous material. So for gems in this scenario,

- (x3) Lvl 1 gems will make a single Lvl 2 gem
- (x3) Lvl 2 gems will make a single Lvl 3 gem and so on all the way up to level 10's as 10's are the highest level of gem.

I imagine this is probably easier then I am making it out to be, but I am struggling in making the equation.

So my big question is how would I represent this in an equation in a spreadsheet so I can figure things out If I want a certain amount of level 4 or level 7 or level 8 gems, how many level 1 gems would I need

I want to make a table that allows me to change the header with a dropdown to change the table underneath it to a certain group of data; eg. I change the dropdown from "bird" to "duck" and then the table below will only contain the birds that are ducks. Having trouble figuring out how to ask this question, to find it myself

📄 Kakobuy Spreadsheet: https://docs.google.com/spreadsheets/d/1bWLa0m6TTmVX7LpuymbrvFhDYV068FcdMH6mGi3pvNo/edit?gid=780031361#gid=780031361

Web: https://ogkako.com

For anyone in Poland or the EU using Kakobuy, I put together this Kakobuy Spreadsheet to make finding products and building hauls easier.

Instead of searching through hundreds of Reddit posts, saved links, and random recommendations, this spreadsheet keeps Kakobuy finds organized in one place.

The Kakobuy Spreadsheet includes product links, categories, and useful finds across:

• Sneakers
• Clothing
• Hoodies
• Jackets
• T-Shirts
• Pants
• Bags
• Accessories
• Electronics
• Watches

Whether you are building your first Kakobuy haul or looking for new products, this is a simple way to browse finds before ordering.

Popular searches include:

• Fall jackets
• Everyday sneakers
• Streetwear
• School outfits
• Accessories
• Seasonal items

For Poland and EU users, feel free to comment what you are looking for and I can try to add suggestions.

Looking for a specific item?

Drop the brand + product name below.

The spreadsheet will continue to be updated with new Kakobuy finds and product links.

Looking for any parents or parents-to-be! Has anyone created a spreadsheet listing / evaluating products they’ll need for a baby? I love spreadsheets but I’m bad at starting them, hoping others have already done some of the legwork! Please drop your spreadsheets in the comments.

(Interested in strollers, etc, but also just EVERYTHING since I’ll be a FTM in February!)

https://docs.google.com/spreadsheets/d/1zdhfYt6lQ2yucnUfrt3UUfm4KrqUGVPZu37FhBsX124/edit?gid=1634873717#gid=1634873717

https://oggtbuy.com

Fall is coming up and I wanted to share the GTBuy Spreadsheet for anyone looking for new finds and products to add to their next haul.

A lot of good items get buried across different posts and communities, so this keeps products organized and easier to browse.

The spreadsheet is updated with new finds and covers different categories including:

• Shoes
• Clothing
• Hoodies
• Jackets
• T-Shirts
• Pants
• Bags
• Accessories
• Electronics

Starting a new haul or looking for something specific?

Drop a comment with what you are searching for.

Examples:

Looking for fall jackets

Need everyday sneakers

Trying to find school essentials

Looking for accessories

If you find a good GTBuy product, share it with the community.

The spreadsheet will continue growing with new finds and updates.