Here I need to identify the overall count by Ignoring the duplicate values in both rows.

Example:

I need to compare whether the AAAA value is displayed in the top row or the same row here (other cells). In this instance, ignoring the duplicates count results in an overall total of 7.

I tried this function :

`=Countif(F10,"<>"&L8) +Countif(H10,"<>"&L8).., --> `

While I need to compare both rows, this statement only compares for a single condition. referring to Row 8 and Value Row 10 for each cell.

Apr 6, 2023 in Others 477 views

## 1 answer to this question.

If the 9th row is empty:

```=COUNTA(UNIQUE(TOCOL(F8:R10)))-1
```

If not:

```=COUNTA(UNIQUE(TOCOL(VSTACK(F8:R8,F10:R10))))-1
```

Result:

• 63,720 points

## How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK(\$C:\$C,\$C2,4),0)) To divide into whichever many ...READ MORE

## Counting distinct values in excel - frequency function

You can use COUNTIF to count the ...READ MORE

## How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

## Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE