Forum Discussion

Boulakgnobot's avatar
Boulakgnobot
Brass Contributor
Dec 08, 2023

AVERAGE and GET RID Off ZEROs

Hello everyone !   I need help with my worksheet. I have inside 3 sheets = "DATA", "RESULTS" and "COMPOSITION"   1- for "COMPOSITION" sheet: I need to calculate "AVER." (D32) with some specific c...
Formulas and Functions
rachel's avatar
rachel
Iron Contributor
Jan 20, 2024

Boulakgnobot 

 

Hi,

I managed to find "MISTAKES" in name using FILTER and FIND function.

 

But I haven't figured out an easy way to hight light SURPLUS letter in RED or PURPLE yet. probably have to do that by hand.

Boulakgnobot's avatar
Boulakgnobot
Brass Contributor
Jan 20, 2024

rachel  Thanks !

 

I don't know WHY there's nothing for (P7:R7) and (P8:R8) BUT I think that's because of :

- (B8) mistake spelling is in the 1st word's last letter "ADAMO GEISHA" for "ADAMA GEISHA"

- and (B10) mistake is the in spelling "Q" instead of "CK" ("RIQ" for "RICK")

 

The only VALID CRITERAS here is this TABLE must get :

a- ALL NAMES that don't APPEAR in "DATA CENTER"'s

b- But those names "Registration" Code (D), "Secure" Code (E) and "Xpiration" Code (F) MUST MATCH EXACTLY "DATA CENTER"'s "Registration" Code ('DATA CENTER'!$G$4:$G$275), "Secure" ('DATA CENTER'!$H$4:$H$275) and "Xpiration" Code ('DATA CENTER'!$I$4:$I$275) first

 

IMAGE below:

Resources