Function Problems

How to Check if Values Exist in Excel Columns B, C, and D

Tauseeq Magsi Oct 1, 2026 869 views

Question details

The user needs to determine whether data exists in columns B, C, and D for corresponding unique IDs located in column A, while factoring in row totals in column E.

How to Check Whether Values Exist in Excel Columns B, C, and D

Product: Spreadsheet Software
Device & OS: not provided
Scenario: Verifying data completeness or identifying missing information across multiple associated data fields for a list of identifiers.
Observed behavior: The user wants a systematic method to flag or identify rows where associated data cells are populated versus when they are left blank.

Before you start

Ensure your dataset is organized with unique IDs in column A, and verify whether column E already calculates a sum, as a sum of zero might indicate empty numeric cells.

Solution 1Recommended

Use COUNTIF to Check if Any Value Exists

This is the most flexible method to check if at least one of the target columns (B, C, or D) contains data for a specific ID row.

The COUNTIF function can quickly scan a range and count how many cells meet a specific condition. By checking for cells that are not empty, we can return a TRUE or FALSE result.

Select the output cell

Click on a blank cell in the same row as your first ID, for example, cell F2.

Enter the COUNTIF formula

Type the formula =COUNTIF(B2:D2,"<>")>0 into the formula bar. The "<>" criteria tells Excel to count cells that are not blank.

Apply to all rows

Press Enter to see the result. If it returns TRUE, at least one value exists. Click and drag the fill handle (the small square at the bottom-right of the cell) down to apply this formula to all IDs in your list.

Use COUNTIF to Check if Any Value Exists

Formula Customization: If you only want to flag rows where specific text exists, change the criteria. For example, use =COUNTIF(B2:D2,"Yes")>0.

Solution 2

Use COUNTA to Check if All Columns Have Values

Use this solution if your requirement is to ensure that data is completely filled out across all three columns (B, C, and D) for each ID.

Solution 3

Check Values Based on Column E Totals

If column E contains the sum of columns B, C, and D, you can use the total to determine if numeric values exist.

Advanced Spreadsheet Tools

Easily Analyze and Verify Data with WPS Spreadsheet

WPS Office provides powerful, fully compatible built-in functions like COUNTIF and COUNTA to easily verify data completeness across multiple columns. It's the perfect tool for data validation and spreadsheet management.

1. Open your dataset: Launch WPS Spreadsheet and open your workbook containing the IDs and columns to be checked.
2. Enter the validation formula: Click an empty cell and input =COUNTIF(B2:D2,"<>")>0 to check for existing values.
3. Fill the series: Press Enter, then use the fill handle to drag the formula down your entire list for instant results.

100% compatible with Microsoft Excel formulas, functions, and file formats (XLSX).Lightweight and fast performance, even when processing large datasets with complex formulas.Intuitive interface making formula troubleshooting and data tracking a breeze.Completely free to use for daily spreadsheet tasks and data analysis.

microsoft office alternative - wps office

Frequently Asked Questions

How do I highlight rows where values exist instead of creating a new formula column?

You can use Conditional Formatting. Select your data range, go to Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter =$E2>0 or =COUNTIF($B2:$D2,"<>")>0, choose a highlight color, and click OK.

Why does my formula return TRUE when the cells look completely empty?

Cells might contain hidden spaces, invisible characters, or formulas that return an empty string (""). You can use the TRIM function or select the seemingly blank cells and press the Delete key to clear the contents completely.

Can I check if specific text exists across multiple columns?

Yes. You can modify the COUNTIF function to search for specific text. For example, use =COUNTIF(B2:D2, "Completed")>0 to see if the exact word "Completed" appears in any of the three columns.

How do I return a custom message instead of TRUE or FALSE?

You can wrap your check inside an IF statement. For example, =IF(COUNTIF(B2:D2,"<>")>0, "Data Exists", "Missing Data"). This will output your custom text based on the result.

Excel & Data Problems