Formulyo

Excel & Google Sheets formula guides

Every formula explained in 1 minute, with a real example you can copy. Free, in English, Spanish and Portuguese.

Clean messy data

TRIM + PROPERClean messy names in one goLOWERMake any text lowercaseSUBSTITUTEReplace any character everywhereTEXTSPLITSplit text into columns with a formulaSORT + UNIQUEA clean A–Z list in one formula

Dates and deadlines

NETWORKDAYSWorking days left to the deadlineWORKDAYGet the deadline in working daysEOMONTHThe last day of any month, instantlyDATEDIFExcel's hidden formulaTEXTTurn any date into its weekday

Sales reports

SUMIFSAdd up only what matches your rulesCOUNTIFSCount with several conditionsMAXIFSThe maximum, with conditionsRANK.EQRank anything automatically% changeThe growth formula every report needs

Text

LEFTTake the first characters of any textMIDTake text from the middleRIGHTMask numbers with RIGHTTEXTBEFORECut any text before a characterTEXTAFTERCut any text after a character

Modern formulas (Excel 365)

FILTER (2 conditions)FILTER with two conditionsSEQUENCENumber any list instantlyTAKEAlways show the latest rowsVSTACKStack lists on top of each other

Stop doing it by hand

Running totalRunning totals with one $Progress %Project progress in one cellIFERRORHide every #DIV/0!&Join cells with one symbolROUNDRound any number the right way

IF and conditions

IFLet Excel decide for youIFSStop nesting IF inside IFCOUNTIFCount anything in one secondAVERAGEIFAverage only what countsMINIFSThe minimum, with conditions

Formulas written with AI

AI promptAsk AI, paste, doneAI promptAI wrote this formula for meAI promptInitials from any name, written by AIXLOOKUP (2 criteria)XLOOKUP with two conditionsISNUMBER + SEARCHCheck if a cell contains a word

Conditional formatting

Conditional formattingMake late tasks turn redFind duplicatesSpot duplicates instantlyHighlight weekendsMake weekends pop outHighlight the topMake the top value glowBelow targetSpot who's below target

More formulas

XLOOKUPStop using VLOOKUPFILTERShow only the rows you care aboutTEXTJOINMerge a whole list into one cellGOOGLETRANSLATEGoogle Sheets translates for youUNIQUERemove duplicates without deleting% of totalThe $ that saves your formulasSORTA ranking that sorts itselfRANDBETWEENPick a random winner in one formulaINDEX + MATCHThe lookup that works in every ExcelSUMPRODUCTMultiply and add in one stepCOUNTA + UNIQUECount unique valuesLARGEYour top 3 in one formulaCOUNTBLANKFind missing data fastDAYSDays between two datesLENCount characters in any cellQuarterAny date into a quarter

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →