Looking to see if it is possible to create a formula to show my account number
Navigating complex data extraction in Excel can be challenging. This user is seeking a formula to automatically populate account numbers from intermittently listed cells, specifically targeting the middle six digits. While a simple drag-down formula works for consistent data, recognizing account number changes across rows presents a hurdle. Explore innovative solutions to streamline your spreadsheet workflows; similar challenges in data visualization are addressed in our article, "Struggling with creating a stack? bar? chart." Discover how to empower your data journey and eliminate manual work.
Perspectives on Modern Data

Talks to sell PayPal to Stripe and Advent are heating up
How much does adding an honest limitations section hurt the paper? [D]
Field Notes & Updates
How to get a table to match the number of rows, and row order, of a parent table
Need to streamline your data management? When adding new expense types to your parent table, automatically populate corresponding rows in linked tables—saving valuable time. This approach ensures consistent data structure and eliminates manual row insertion. It’s a powerful way to maintain data integrity and workflow efficiency. Discover how to configure this feature, mirroring your parent table's growth across related sheets. For troubleshooting formula errors that might arise, see our article, "Pls help - Need to fix formula with Spill Error," for helpful guidance.
Am trying to update my excel but where should i go to update my excel version
Updating your Excel version can seem daunting, especially if you're new to the process. To explore the latest features and improvements, navigate directly to the Microsoft Office website and locate the download center. There, you can find the appropriate version for your operating system and begin the update. If you're also looking to streamline your spreadsheet tasks, consider how formulas like those discussed in "Looking to see if it is possible to create a formula to show my account number" can help automate workflows.
Formula for extracting information from one worksheet's column to different worksheet giving blank result.
Encountering blank results when attempting to transfer data between worksheets in Excel 365 (build 16.0) is a common challenge. The provided formula, designed to populate a course sheet with tee color data from a "Scores" sheet based on matching course name and date, appears to be experiencing a logical mismatch. Specifically, the formula’s range references need careful review to ensure accurate data retrieval.
Open-source Python library + no-code web dashboard for evaluating oncology AI models at clinical decision thresholds. [P]
Clinical decision-making in oncology hinges on reliable AI model performance *at specific thresholds*, a critical evaluation often overlooked by standard metrics like AUC. Oncothresh, a dependency-light Python library, addresses this gap by providing precise assessments of sensitivity, specificity, and related metrics at defined cutoffs, alongside confidence intervals and decision-curve analysis. A companion no-code web dashboard simplifies this analysis—simply upload data and generate comprehensive reports. Explore Oncothresh and oncothresh-web (github.com/omkaradhali/oncothresh) and contribute feedback to refine this valuable tool.
Seeking Excel shortcut for entering times without typing the colon
Entering times in Excel can be surprisingly tedious, especially with high-volume data entry. Fortunately, there’s a straightforward solution to bypass repetitive colon typing. Leverage Excel's custom cell formatting to automatically convert four-digit inputs (like "1436") into recognized time values—either 12-hour (with AM/PM) or 24-hour format. This empowers you to streamline your workflow and boost productivity. Explore this transformative approach to data entry, and discover how a simple formatting change can significantly reduce manual effort.
How do I use the green square/fill handle without a mouse?
Navigating Excel’s autofill feature without a mouse can streamline your workflow. The green fill handle, typically double-clicked to extend formulas or data down a column, presents a challenge when mouse access is limited. Currently, Excel lacks a dedicated keyboard shortcut to replicate this double-click action directly.

Self-driving trucks are officially testing on California highways
The future of freight is arriving on California highways. Aurora Innovation and Kodiak AI, leading developers of self-driving truck technology, have secured permits from the California Department of Motor Vehicles to begin official testing. This marks a significant step toward wider adoption of autonomous trucking, promising increased efficiency and potentially reshaping the logistics landscape. Interested in the broader implications of AI-driven systems?
Excel adds file:/// automatically to every server link which breaks the link updating automatically
Excel users encountering broken server links due to the automatic addition of "file:///“ are not alone. This frustrating issue, as reported by /u/cocacola87559, renders dynamic linking unreliable, requiring constant manual updates—an unsustainable workflow. Excel's behavior of rewriting these links upon reopening appears to be a persistent problem, despite attempts to disable automatic link updates. While server-side restrictions limit immediate solutions, understanding the root cause is the first step toward a future-focused data management strategy.
Creating an “app” for my work
You're envisioning a powerful solution: transforming your Excel inspection reports into a mobile-accessible tool for field employees. Consolidating those seven reports into a single, interconnected workbook is a smart first step toward creating a custom reporting system—effectively, your own "app." This approach empowers your team while avoiding costly subscription fees. To achieve this, focus on structuring your workbook for seamless data flow and accessibility.
Struggling with creating a formula for twice monthly overtime pay
Calculating overtime with bi-monthly pay periods and a Sunday-to-Saturday work week presents a unique challenge. Many spreadsheet users encounter this complexity when tracking fluctuating hours. To accurately reflect overtime earned across pay periods, you'll need a formula that accounts for the work week’s span regardless of the pay period's end date. Explore our resources for deeper insights into similar data management complexities, such as the recent article discussing Airtable’s valuation shifts—understanding these broader trends can inform your approach.
Struggling with creating a stack? bar? chart
Visualizing "before and after" questionnaire results can be tricky! Many users find accurately representing data for stacked or bar charts in Excel challenging. We understand the frustration of getting those headlines and values just right. To achieve the diagram you envision, focus on structuring your Excel data with clear labels and corresponding values for each category—before and after. For more complex data manipulation, consider exploring techniques like those discussed in our article, "I created a triple nested XLOOKUP formula...
Vlookups and filtered tables
Navigating shared names in your municipality data is a common challenge. While Excel doesn’t directly support compound references within VLOOKUP, your instinct to filter is sound. Creating separate, filtered tables—village, town, city, county—is the most reliable approach to ensure accurate lookups. This strategy isolates data, preventing mismatched results. For those seeking broader automation strategies, explore "Is it possible to automate data input from multiple workbooks," which delves into streamlining data handling across spreadsheets.
More Articles

What we know about the alleged Iranian hacks on US water utilities
I created a triple nested XLOOKUP formula. Is there a more efficient way to do what I'm doing?
Can I simplify my formula?
Are there any theoretically-guided practices left in machine learning nowadays? [D]
Link QR code to a specific cell?
VBA coding for organizing
How do you track a large inventory of original artwork in Excel without it getting out of hand?

Read-it-later app Pocket shut down — here are the best alternatives
A linter for PyTorch 'torch-preflight' [P]
Is it possible to automate data input from multiple workbooks
Is there a way to change the position of digits in excel?
Sort Order and Locking Cells

GLM-5.3 is here with advanced cyber capabilities — and reportedly already found a 'serious vulnerability' in Cursor
How to append sheet titles to table names automatically, and fill them into formulas
Standard derivation of the last three data in a column
For the people who got reviews back from neurips, cvpr, eccv, etc and also tested their paper through an agentic reviewer like the stanford one, how different were the reviews? [D]
Pls help - Need to fix formula with Spill Error
I inadvertently became the team lead in PQ as a novice and now they want me to host a lunch-and-learn

Thrive’s Joshua Kushner chides Silicon Valley VCs over AI euphoria
I compiled Doom's renderer into a 21B-parameter transformer -- no training anywhere [P]

Cloudflare Migrates JavaScript CDN Serving 9B Requests a Day to Its Developer Platform

My Model Was Cheating on Its Own Test

RAG Workflow and Loop Engineering: The Dispatcher That Decides When to Loop and When to Stop

Google will now allow users to remove visible watermark from its AI generations

How to Build a Simple AI Web Scraper with Python

A Day in the Life of a Data Scientist in 2026

US courts will start publishing how often the government uses spyware

Kog is going deeper to squeeze more inference out of GPUs

Apple proposes to take a 15% cut of purchases made outside the App Store

Hyperscalers might regret embracing natural gas if new forecast proves correct

Does Mark Zuckerberg really believe AI is ‘for everyone’?
