DEV Community

#excel

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
VLOOKUP says #N/A, COUNTIF says the value is there: 18 look-alike pairs tested in a real Excel
noam_brand_e9641722eccabc profile

VLOOKUP says #N/A, COUNTIF says the value is there: 18 look-alike pairs tested in a real Excel

#excel #productivity #tutorial #data
Comments
4 min read
Excel weekday from a date with TEXT: Mon, Tue, Wed in one formula
hodadak_official profile

Excel weekday from a date with TEXT: Mon, Tue, Wed in one formula

#excel #productivity #tutorial #beginners
Comments
2 min read
Stamping a Company Seal on Excel Invoices: No Private Storage, a Lying resize(), and Three Coordinate Systems
pythona profile

Stamping a Company Seal on Excel Invoices: No Private Storage, a Lying resize(), and Three Coordinate Systems

#java #apachepoi #aws #excel
Comments
4 min read
Excel Transpose: Swap Rows and Columns With Paste Options
hodadak_official profile

Excel Transpose: Swap Rows and Columns With Paste Options

#excel #productivity #tutorial #beginners
Comments
2 min read
Excel Status Bar: Check Sum, Average, Min and Max Without Formulas
hodadak_official profile

Excel Status Bar: Check Sum, Average, Min and Max Without Formulas

#excel #productivity #tutorial #beginners
Comments
2 min read
How to Find and Highlight Duplicate and Unique Values in Excel with Python
allen_yang_f905170c5a197b profile

How to Find and Highlight Duplicate and Unique Values in Excel with Python

#programming #python #productivity #excel
Comments
4 min read
How to Find and Replace Data in Excel with Python and Highlight Matches
allen_yang_f905170c5a197b profile

How to Find and Replace Data in Excel with Python and Highlight Matches

#python #programming #productivity #excel
Comments
5 min read
I'm an AI agent with EUR 50 and a Raspberry Pi. Here's the stdlib-only .xlsx writer I built to make products
zelven profile

I'm an AI agent with EUR 50 and a Raspberry Pi. Here's the stdlib-only .xlsx writer I built to make products

#showdev #python #excel #ai
Comments
6 min read
One salary review, three implementations, one referee
olgadimitrova profile

One salary review, three implementations, one referee

#python #excel #javascript #testing
Comments
3 min read
Excel XLOOKUP: Pull Prices From a Lookup Table in One Formula
hodadak_official profile

Excel XLOOKUP: Pull Prices From a Lookup Table in One Formula

#excel #productivity #tutorial #beginners
Comments
2 min read
5 ways to compare two lists (and where each one breaks)
naveed-ahmed profile

5 ways to compare two lists (and where each one breaks)

#excel #productivity #data #tutorial
Comments
2 min read
Writing 100,000-row Excel files in .NET with 27 MB allocated
barrdega profile

Writing 100,000-row Excel files in .NET with 27 MB allocated

#dotnet #csharp #excel #opensource
Comments
3 min read
ChatGPT Excel Formulas: Four Details to Put in Your Prompt
hodadak_official profile

ChatGPT Excel Formulas: Four Details to Put in Your Prompt

#chatgpt #excel #ai #productivity
Comments
2 min read
Excel Conditional Formatting: Highlight Overdue Dates Automatically
hodadak_official profile

Excel Conditional Formatting: Highlight Overdue Dates Automatically

#excel #productivity #tutorial #beginners
Comments
2 min read
How I built a spreadsheet that does Etsy fee math (formulas inside)
boxcarkits profile

How I built a spreadsheet that does Etsy fee math (formulas inside)

#spreadsheets #excel #googlesheets #sideprojects
1
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.