Forum Discussion

Lukas_P11's avatar
Lukas_P11
Copper Contributor
Aug 10, 2022
Solved

Matching e-mails with specific continous number

Hello everyone, I am having trouble to find out the right function how to make customer either an aquisition or retention. (by his order) On the screen are visible informations that I have and ...
  • OliverScheurich's avatar
    Aug 10, 2022

    Lukas_P11 

    =IF(COUNTIF($D$2:D2,D2)=1,"aquisition","retention")

    Does this formula return your expected result?

     

Resources