Mtmoroni ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	22

About Me

About Me

Area of Expertise	Process Development

Analytics

64

Posts

166

Visits

7.3k

Points

Jul 23, 2018

Join Date

Oct 10, 2024

Last Active

Reactions

• Insightful 2

  2
• Vote Up 13

  13
• Awesome 1

  1

• Discussions30
• Comments34

• INDEX/Match, to not display "#NO MATCH"

  Mtmoroni

  02/02/21
  =INDEX({ Range 1}, MATCH([Column0]19, { Range 2}, 0)) How can I get this to NOT display "#NO MATCH" if there is no match?
  1 ·

• Re: Sum if in a column of a "if" formula

  Mtmoroni

  03/05/20
  And since i cant delete this, i finally stumble don teh answer: I had to remove the " " around my numeric values
  1 ·