•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula for Returning Values Based On Guideline
Our take
Are you struggling to extract specific values from your data while navigating the complexities of legacy spreadsheets? You’re not alone. If you need a formula that returns a value in one column only when another column precisely matches “ABC”—and ignores any blank rows—you’re on the right track to unlocking your spreadsheet's potential. In this guide, we’ll explore how to create a tailored formula that meets your needs, empowering you to transform your data handling with ease. Let’s dive in and simplify this process together!
Hi,
Say I have a column 1 where some rows have values like "ABC (XYZ)" and "ABC", and also other rows that are blank. I would like to return a value in column 2 each time column 1 only shows "ABC", but ignore the rows that are completely blank. Is there a formula for this? Thanks.
EDIT: It turned out what I needed was a lot more complicated than I originally thought, making my question no longer applicable. Thanks to everyone who responded.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience