Beyond Market Intelligence

Acme AI is the next-generation, AI-powered spreadsheet platform built to replace Excel and redefine how analysts, data scientists, and enterprise teams work with data. Read more

Page 68

🐈AI News & Strategy Daily | Nate B Jones
AI News & Strategy Daily | Nate B Jones

Anthropic Might Buy Atlassian For $40B. Here's Why It Makes Sense.

Anthropic's potential acquisition of Atlassian for $40 billion presents a strategic opportunity that aligns with the evolving landscape of collaborative technology and AI integration. As organizations seek innovative solutions to enhance productivity, merging Anthropic’s advanced AI capabilities with Atlassian’s established suite of tools could redefine project management and team collaboration.
How People are Figuring Out Life With Claude
Analytics Vidhya

How People are Figuring Out Life With Claude

In today's digital landscape, AI chatbots like Claude have transformed the way we seek information and guidance. What once was a simple query to Google has evolved into a deeper, more interactive experience. This shift reflects a growing reliance on conversational AI for navigating life's complexities, from choosing the right car to finding the perfect upskilling course. As users embrace this innovative technology, Claude offers personalized insights that empower individuals to make informed decisions and enhance their everyday lives.
How a 2021 Quantization Algorithm Quietly Outperforms Its 2026 Successor
Towards Data Science

How a 2021 Quantization Algorithm Quietly Outperforms Its 2026 Successor

In the evolving landscape of quantization algorithms, a 2021 model has emerged as a surprising frontrunner, outperforming its anticipated 2026 successor. Central to this superiority is a single scale parameter that governs accuracy in rotation-based vector quantization. This analysis delves into the reasons behind the 2021 algorithm's unexpected efficiency, highlighting its innovative approach to data representation. By understanding its mechanisms, users can better appreciate the implications for future developments in AI and machine learning. Discover how this breakthrough reshapes our expectations of algorithm performance.
Which Regularizer Should You Actually Use? Lessons from 134,400 Simulations
Towards Data Science

Which Regularizer Should You Actually Use? Lessons from 134,400 Simulations

In the pursuit of effective model fitting, choosing the right regularizer can significantly impact your outcomes. "Which Regularizer Should You Actually Use? Lessons from 134,400 Simulations" offers a practical decision framework for practitioners navigating Ridge, Lasso, and ElasticNet. By focusing on three quantifiable metrics, this post empowers you to make informed choices before fitting your model. Dive into the insights derived from extensive simulations to discover how these regularizers can enhance your data analysis and streamline your workflow, ultimately driving better results.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to "fact check" with conditional formatting?

To ensure every column in your schedule contains at least one instance of specific text, like "A," "B," "C," or "D," you can use a combination of a formula and conditional formatting in Excel. Start by creating a formula that checks for the presence of these values within each column. Once established, apply conditional formatting to visually highlight any columns that do not meet this criteria. This approach will empower you to confirm that all shifts are adequately covered, enhancing your scheduling efficiency.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I want to create a chart like on the first photo with the provided data on the second photo. How do I go about doing that?

Creating a chart to visualize your monthly amounts by year can significantly enhance your data analysis. To achieve this, start by organizing your data to ensure that each month's totals are clearly defined and positioned next to each other for easy comparison. Use your spreadsheet software's charting features, selecting a suitable chart type that emphasizes these monthly totals effectively. Focus on clarity and simplicity, ensuring the chart conveys the necessary information without unnecessary details.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How do I get two values in one cell?

To effectively represent individuals with multiple occupations in your data table, you can combine the occupations into one cell using a straightforward approach. This method allows you to maintain clarity while ensuring that each occupation is represented in your pie chart. By separating the occupations with a delimiter—such as a comma or a slash—you can keep the data organized and visually distinct. This way, your chart will accurately reflect the diverse roles of each individual without creating separate entries for their combined occupations.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Transfer Data from One Workbook to Another (SPILL Issue)

Are you facing challenges transferring data between Excel workbooks? In this scenario, you have a source workbook on the left and a destination workbook on the right, where you aim to automatically transfer “Given IDs” based on their assigned codes. While you've successfully navigated one-to-many lookups, the appearance of #REF! errors when re-entering existing codes in the destination can be frustrating. Let's explore potential solutions, including the use of COUNTIF and FILTER functions, to maintain seamless data transfer while allowing for direct code entry.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Calendar formatting. Creating a multiple year with automatic fill in based off inputed information

Creating an efficient office calendar that streamlines leave requests and weekly scheduling can significantly enhance productivity. By designing a multi-year calendar that automatically fills in based on user input, you empower your team to manage their time effectively. This setup allows employees to request time off through a single tab, which then populates the calendar seamlessly. Additionally, integrating a weekly calendar that draws information from the monthly overview ensures everyone stays aligned.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to return top X number of names who said yes?

To efficiently identify the top four individuals who responded "yes" from your list of 80 names, you can leverage a formula that combines filtering and ranking by seniority. Start by filtering the names based on the checkbox in column F, indicating a "yes" response. Then, apply a formula that begins at person 78 and cycles back to the top, ensuring seniority is considered.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

This Week's /r/Excel Recap for the week of April 25 - May 01, 2026

Welcome to this week’s /r/Excel Recap for April 25 - May 01, 2026. Dive into the top discussions shaping the community, including five standout posts that showcase users seeking solutions for complex spreadsheet challenges. From mastering slicers with pivot tables to moving the formula bar, these topics highlight both unsolved queries and effective solutions like salary conversions and calculating work hours. Join the conversation and discover how fellow Excel enthusiasts are tackling their data management hurdles, empowering each other through shared knowledge and experiences.
Uber wants to turn its millions of drivers into a sensor grid for self-driving companies
TechCrunch

Uber wants to turn its millions of drivers into a sensor grid for self-driving companies

Uber is set to transform its vast network of drivers into a dynamic sensor grid, a strategy unveiled by Chief Technology Officer Praveen Neppalli Naga during an interview at TechCrunch's StrictlyVC event in San Francisco. This initiative builds on the company's earlier announcement of AV Labs, which aims to enhance the development of self-driving technology. By leveraging the insights and data from its millions of drivers, Uber envisions a more robust foundation for autonomous vehicle advancements, positioning itself at the forefront of innovation in mobility.
🐈Machine Learning
Machine Learning

Real World Physics-Informed AI Applications [D]

Physics-informed AI is emerging as a transformative force across various industries, bridging the gap between advanced computational techniques and real-world applications. Unlike conventional AI that mainly relies on neural networks, physics-informed approaches integrate domain knowledge to enhance predictions and decision-making processes. This innovative technology is already making strides in fields such as healthcare, energy, and manufacturing, where accurate modeling and simulations are crucial. Exploring these applications reveals how physics-informed AI can solve complex problems and optimize outcomes, paving the way for a data-driven future.
🐈AI News & Strategy Daily | Nate B Jones
AI News & Strategy Daily | Nate B Jones

OKRs Were Never Built for AI #aiagents #futureofwork #shorts

In today's rapidly evolving workplace, traditional OKRs (Objectives and Key Results) often fall short of harnessing the full potential of AI. These frameworks were not designed with the complexities of AI integration in mind, limiting their effectiveness in driving innovation and productivity. As we explore the future of work, it's crucial to rethink how we set and measure goals in a landscape increasingly influenced by advanced technologies.
🐈AI News & Strategy Daily | Nate B Jones
AI News & Strategy Daily | Nate B Jones

When AI Optimizes for the Wrong Objective #aifails

In the rapidly evolving landscape of AI, optimizing for the wrong objective can lead to unexpected failures and missed opportunities. This phenomenon, often termed #aifails, highlights the critical importance of aligning AI systems with user needs and real-world outcomes. When AI prioritizes metrics that don't reflect genuine value, it can compromise productivity and undermine trust. By exploring the nuances of AI optimization, we can uncover insights that drive more effective and human-centered solutions, ultimately transforming how we leverage technology in our daily workflows.
DuckLake 1.0: Data Lake Format with SQL Catalog Metadata
InfoQ

DuckLake 1.0: Data Lake Format with SQL Catalog Metadata

DuckDB Labs has launched DuckLake 1.0, an innovative data lake format that redefines how table metadata is stored by utilizing a SQL database instead of scattering it across multiple files in object storage. This release, available as a DuckDB extension, introduces key enhancements including catalog-stored small updates, improved sorting and partitioning options, and compatibility with Iceberg-style data features. DuckLake 1.0 empowers users to manage their data more efficiently, paving the way for a more streamlined and productive data management experience.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Anyone else struggle with knowing what to do with their data, not just formulas?

Many of us encounter challenges when it comes to making sense of our data, extending beyond just formulas. It's not uncommon to feel uncertain about what the data truly requires or which insights to pursue. This can lead to a frustrating cycle of trial and error. Instead of relying on manual methods, there are smarter, more efficient ways to harness your data’s potential. By embracing innovative tools, you can gain clarity and direction, transforming how you interact with your spreadsheets and uncover valuable insights.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

DAX Net and absolute differences

Navigating DAX measures in Excel can be challenging, especially when trying to analyze stock value differences across months. In your dataset, you aim to calculate both the total stock value per month and the separate increases and decreases for each plant type. While using SUMX is a step in the right direction, issues may arise with products that appear only once. To achieve accurate results, consider adjusting your DAX formulas to handle these unique cases effectively.
🐈Machine Learning
Machine Learning

Looking for feedback on OpenVidya: an open-source AI classroom layer for NCERT/CBSE [R]

I invite your feedback on OpenVidya, an open-source AI classroom layer designed specifically for NCERT and CBSE curricula. Built as a fork of OpenMAIC, OpenVidya aims to transform learning by incorporating multi-agent AI tailored to Indian education, beyond generic slide or chat experiences. Current features include structured knowledge grounding, concept dependency graphs, and diverse pedagogy modes such as Teacher Narration and Exam Dojo. I seek insights on its architecture, target user focus, evaluation methods, and potential dataset additions.
🐈Machine Learning
Machine Learning

Beyond Jupyter Notebooks: The real work behind Production ML systems [D]

In the evolving landscape of Machine Learning, the role of an ML Platform Engineer transcends traditional boundaries. While many focus on model training, the true essence of production ML lies in developing a robust system that ensures reliability and efficiency. This includes managing data pipelines, feature stores, and deployment workflows. By collaborating closely with Data Scientists and Product Managers, ML Platform Engineers craft solutions that address the complexities of real-world applications.
🐈Machine Learning
Machine Learning

[D] Self-Promotion Thread

Welcome to the Self-Promotion Thread! This space is dedicated to showcasing your personal projects, startups, product placements, collaboration needs, and blogs. Please share your offerings clearly, including payment and pricing details for your products and services. We kindly ask that you refrain from using link shorteners, link aggregator websites, or auto-subscribe links. Remember, any abuse of trust may lead to bans. We encourage you to keep the conversation going by posting your updates here until the next thread is created.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to total numbers separated by commas in multiple cells.

If you're managing a spreadsheet for patient discharges and need to total room numbers listed as comma-separated values in cells E19:E23, you're not alone. This task can be tricky, especially when formulas yield unexpected results, like defaulting to "1" instead of "0" when there are no discharges. Fortunately, with a bit of guidance, you can simplify this process. Let’s explore a reliable formula that accurately counts discharges, ensuring you get the correct total while enhancing your spreadsheet skills.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Remove Duplicates doesn't work as expected

It seems you're encountering an issue with Excel 2019 where the "Remove Duplicates" function isn't performing as expected for the Non-text and Month columns. You're right to anticipate seeing one row with "True" and one with "False," along with no duplicated months. This may be due to how Excel identifies duplicates, including hidden characters or formatting inconsistencies. Ensure that both columns are formatted consistently and check for any hidden spaces. Exploring these factors may lead to the desired outcome in your data management process.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Rounding my result that converts annual salary into an hourly rate by dividing by 2,080 hours

To achieve an even final annual salary after converting an initial salary to an hourly rate, divide the annual amount by 52 weeks. The result should be rounded down to the nearest multiple of $0.20 to ensure simplicity and consistency. For instance, if the initial salary is $135,057.17, dividing by 52 yields approximately $2,597.25. Rounding down gives $2,597.20, resulting in a final salary of $135,054.40. This approach maintains clarity while ensuring the final amount does not exceed the original salary.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How do I get slicers to work with a pivot table with multiple value tables, and also displayed in an easily legible way?

Creating a pivot table with slicers for multiple criteria can enhance your ability to filter and analyze data effectively. In your scenario with fifty staff members and various attributes, ensuring all six slicers work seamlessly while maintaining readability is key. This introduction will guide you through optimizing your pivot table setup, addressing common challenges, and exploring alternative methods if necessary. By simplifying the process, you can transform your data management and provide a more intuitive experience for your users. Let’s dive into the solutions!
The top 10 real estate funds took 40% of all 2025 commitments. Here's what that means for everyone else.
Financial Modeling

The top 10 real estate funds took 40% of all 2025 commitments. Here's what that means for everyone else.

In 2025, the top 10 real estate funds captured a significant 40% of all investment commitments, highlighting a notable trend in the real estate sector. This concentration of capital not only underscores the competitive landscape but also raises important questions for smaller funds and emerging players. Understanding the implications of this shift is essential for investors seeking to navigate a market increasingly dominated by a select few. Explore the factors driving this trend and what it means for the future of real estate investment.
200,000 MCP servers expose a command execution flaw that Anthropic calls a feature
VentureBeat

200,000 MCP servers expose a command execution flaw that Anthropic calls a feature

A recent investigation by OX Security has unveiled a significant flaw in the Model Context Protocol (MCP), which impacts an estimated 200,000 servers. This vulnerability stems from the STDIO transport, allowing malicious command execution without input sanitization. Despite Anthropic's characterization of this behavior as intentional, experts warn that it presents a critical security risk. With numerous affected products and high-severity CVEs identified, organizations must urgently assess their MCP deployments. This article outlines essential steps to evaluate exposure, patch vulnerabilities, and implement necessary safeguards.
Salesforce launches Agentforce Operations to fix the workflows breaking enterprise AI
VentureBeat

Salesforce launches Agentforce Operations to fix the workflows breaking enterprise AI

Salesforce has unveiled Agentforce Operations, a transformative workflow platform designed to address the challenges enterprise AI teams face. As organizations increasingly deploy agents, they encounter issues stemming from workflows originally tailored for human judgment. This innovative solution allows users to either upload their existing processes or utilize Salesforce's Blueprints, breaking down complex workflows into manageable tasks for agents. By imposing a deterministic structure, Agentforce Operations ensures clarity in execution, pushing enterprises to rethink processes and improve productivity while enhancing transparency and accountability.
Coatue has a plan to buy up land for data centers, possibly for Anthropic
TechCrunch

Coatue has a plan to buy up land for data centers, possibly for Anthropic

Coatue Management, a prominent player in the venture capital landscape, is embarking on an ambitious initiative to acquire land for data centers, potentially to support the operations of Anthropic. This strategic move is aimed at leveraging proximity to substantial power sources, thereby enhancing operational efficiency and sustainability. By investing in this vital infrastructure, Coatue is positioning itself at the forefront of the data management revolution, underscoring its commitment to innovative solutions that empower the future of AI technology and data processing.
Meta buys robotics startup to bolster its humanoid AI ambitions
TechCrunch

Meta buys robotics startup to bolster its humanoid AI ambitions

Meta has taken a significant step in advancing its humanoid AI capabilities by acquiring the robotics startup Assured Robot Intelligence. This strategic move aims to enhance Meta's AI models for robots, positioning the company to explore innovative solutions in the field of robotics. By integrating Assured Robot Intelligence's expertise, Meta is poised to transform how humanoid robots interact and function, reflecting its commitment to pushing the boundaries of technology and improving user experiences in an increasingly automated world.
Musely secures $360M from General Catalyst without giving up equity
TechCrunch

Musely secures $360M from General Catalyst without giving up equity

Musely, the direct-to-consumer brand specializing in skin, hair, and menopause care, has successfully secured $360 million in non-dilutive funding from General Catalyst. This strategic investment allows Musely to enhance its customer acquisition efforts while maintaining full ownership of the company. By leveraging this substantial capital, Musely aims to accelerate its growth and expand its innovative product offerings, ultimately empowering consumers to take charge of their self-care journeys. This milestone reflects Musely's commitment to transforming the personal care landscape.
Replit’s Amjad Masad on the Cursor deal, fighting Apple, and why he’d rather not sell
TechCrunch

Replit’s Amjad Masad on the Cursor deal, fighting Apple, and why he’d rather not sell

At TechCrunch's sold-out StrictlyVC event in San Francisco, Replit CEO Amjad Masad tackled pressing industry questions, including the rumored acquisition of rival Cursor by SpaceX for $60 billion. The conversation illuminated Masad's perspective on the competitive landscape and his commitment to Replit's mission. Rather than pursuing a sale, he emphasized the importance of innovation and the potential for Replit to shape the future of coding and collaboration. This discussion not only showcased his confidence but also highlighted the evolving dynamics within the tech ecosystem.
🐈Data Science
Data Science

You did one take home, yes, but are you comfortable doing another one?

After completing a challenging take-home assignment for a drug store chain, I received a surprising request for another task, this time specifically related to forecasting. While they acknowledged my initial effort, it raised questions about their clarity in hiring needs and expectations. Are they unsure of what they want, or am I being given a second chance to showcase my expertise? This situation feels ambiguous—are they genuinely interested in my insights or simply seeking free analysis?
🐈Data Science
Data Science

How do you keep up without burnout?

In today's fast-paced tech landscape, the challenge of keeping up with an ever-expanding skill set can feel overwhelming, especially with the rise of AI engineering. As professionals grapple with vast expectations—balancing knowledge in statistics, machine learning, cloud technologies, and more—it’s crucial to find strategies that promote sustainable learning. This discussion invites you to explore effective approaches to skill acquisition without succumbing to burnout, while also questioning whether industry demands have become inflated in the age of AI. How can you navigate this complexity and thrive?
🐈Data Science
Data Science

DS market is kind of insane right now

The current data science job market presents a striking reality: a recent associate-level position at my company attracted over 300 applications, with more than 30 seasoned professionals, each boasting 10+ years of experience, vying for the role. Among them was even a Harvard master's graduate. This influx of senior candidates applying for entry-level positions highlights the ongoing challenges in the job market, likely driven by layoffs.
🐈Data Science
Data Science

I bombed Google DS Research, so you dont have to

In this candid reflection, the author shares their experience with Google’s Data Science Research interview, highlighting the two critical rounds: Statistical Knowledge and Data Analytics. The statistical portion challenged their understanding of distributions, expectations, and confidence intervals, ultimately revealing that what seemed complex had a straightforward answer. The second round involved diagnosing a flawed model, where expectations of a case study shifted unexpectedly to a technical equation task. The key takeaway?
🐈Machine Learning
Machine Learning

UAI Rebuttal [D]

Navigating the world of academic submissions can be daunting, especially when facing feedback on your UAI paper. With your pre-rebuttal scores reflecting a mix of confidence, the post-rebuttal improvements show promise, particularly in key areas. While the progress from a score of 4 to 5 indicates a stronger response, the decision to pursue NeurIPS could still be worthwhile. Consider the potential for growth at both venues, and evaluate where your research might find the most receptive audience. Explore your options thoughtfully to maximize your impact.
🐈Machine Learning
Machine Learning

Tube strikes make people healthier. The maths proves it [D]

Tube strikes in London have an unexpected benefit: they encourage healthier commuting habits. A recent analysis employs causal inference to reveal how these disruptions lead to a significant increase in cycling usage. As traditional transportation options become limited, more individuals turn to bicycles, promoting physical activity and reducing reliance on public transit. This shift not only enhances personal health but also underscores the potential for urban planning to leverage such events for improved public well-being. Discover how strikes can catalyze positive change in commuting behaviors.
🐈Machine Learning
Machine Learning

I spent years building a 103B-token Usenet corpus (1980–2013) and finally documented it [P]

After years of dedicated work, I am excited to share my extensive 103.1 billion-token Usenet corpus, encompassing a complete archive from 1980 to 2013. This dataset features 408 million posts across 18,347 newsgroups, reflecting 33 years of language evolution. The processing pipeline ensured meticulous cleaning and organization, including deduplication and language detection, resulting in a corpus that is 96.6% English. This rich historical resource offers unique insights into the evolution of online discourse.
🐈Machine Learning
Machine Learning

ICML final decisions rant [D]

The recent ICML decisions have sparked frustration, with only about 6.5K of 24K submissions accepted. This cycle of high submissions and low acceptance rates raises concerns about the future of conference publishing. Many rejected papers are not necessarily "bad," yet their authors may face a cascade of further rejections at NeurIPS. Review processes often seem inadequate, with reviewers making arbitrary judgments and failing to engage with rebuttals. As researchers strive to tackle complex problems, the current system feels increasingly unproductive and disheartening.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Return Value if Match header in Column

To populate the "RETURN VALUE" column based on the job listed in the first column, you'll want to use a formula that matches the job with its corresponding header. For example, if the job is "D," the formula will compare "D" to the headers in that row and return the associated dollar value. In this instance, the value of $30 will be returned from the appropriate header column. This approach simplifies tracking and managing job-specific values effectively within your spreadsheet.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Has Excel been garbage for other people lately, too?

Many users have experienced frustrations with Excel lately, particularly those utilizing the Microsoft 365 version. Issues like unexpected focus shifts between workbooks, unresponsive cell clicks, and malfunctioning keyboard shortcuts have become increasingly common. After over a decade of enjoying a seamless experience, these recurring problems can be deeply frustrating, leading to diminished productivity and an overall sense of annoyance. It’s understandable to seek an outlet for these frustrations, especially when what was once a reliable tool now feels more like a daily obstacle.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to sum all cells in column B where column A in the same row contains a specific string of text?

In this guide, we'll explore a straightforward method to sum values in column B based on specific criteria in column A. If you're looking to add numerical responses for a name like "Bob," even when multiple names are listed in a single cell, there's an efficient solution for you. Instead of resorting to complex conditionals that might slow down your spreadsheet, we’ll use a formula that simplifies the process, ensuring you can easily calculate totals without overwhelming your system. Let's dive in!
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Automate Exporting multiple Excel charts to PPT without VBA

Are you looking to streamline your workflow by automating the export of multiple Excel charts to PowerPoint without relying on VBA? Power Automate offers a promising solution to simplify this process. By leveraging its capabilities, you can efficiently transfer your data visualizations to presentations, enhancing productivity and saving time. Explore how Power Automate can transform your approach to data management, allowing you to focus on insights rather than tedious manual tasks. Join the conversation and discover effective strategies for seamless integration.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Bar graph not showing January's data

If you're encountering an issue with your bar graph not displaying January's data when selecting the range from January 2025 to January 2026, you're not alone. This situation typically arises due to the way data ranges are defined in your settings. When you select only January 2025 to January 2026, the graph may not have the necessary data points to render correctly. However, expanding your selection to include February 2026 allows the graph to display all relevant data.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Conditional Formatting with another cell?

Conditional formatting can significantly enhance your spreadsheet by visually representing data based on specific criteria. In this scenario, you want to change the fill color of Cell A based on its value relative to 10% and the value in Cell B. To achieve this, you can use custom formulas in the conditional formatting rules. This approach allows you to create dynamic visual cues that help you quickly assess the data at a glance. Let’s explore how to set up these conditions effectively.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Filter only most recent value in each day from a query

If you're working with a query that pulls multiple daily exchange rates but only need the most recent value for each day, Power Query offers an efficient solution. By leveraging its capabilities, you can filter your data to retain only the latest exchange rate for every date. This approach eliminates the need for manual CSV downloads and cumbersome formatting adjustments. Instead, you can streamline your workflow, ensuring that your data remains consistently updated and easily integrated into your spreadsheets.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How should I structure a sheet to compare potential combinations of entries between three tables

Creating an effective sheet to compare weapon traits in your video game can streamline your decision-making process. Start by clearly designating the available traits for each weapon, perhaps through checkboxes or dropdown menus linked to your tables. This will allow you to visualize which traits correspond to each weapon. For querying combinations, implement multiple selection dropdowns for each slot to filter weapons based on selected traits.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Incremental rounding of data?

Are you looking for a more human-friendly approach to rounding data? Incremental rounding can enhance the readability of your outputs by adjusting the rounding method based on the magnitude of the numbers. For example, you might round 1.564 to 1.5, 10.564 to 11, and 100.564 to 105. The challenge lies in implementing this without resorting to cumbersome IF statements. In this discussion, we’ll explore innovative solutions that streamline your rounding process while maintaining clarity and precision in your data presentation.
🐈Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Multiple folders with multiple files power query

Hey everyone, I’m reaching out for guidance on efficiently importing a large set of files into Power Query. I have a folder containing approximately 9,000 files, each with around 20 text files. Unfortunately, I haven’t found a timely method to import all these files for searching specific strings within the text. If anyone can offer insights or recommend a more effective program for this task, I would greatly appreciate your help. Thank you for your support!