Forum Discussion
Lukas_P11
Aug 10, 2022Copper Contributor
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 ...
- Aug 10, 2022
=IF(COUNTIF($D$2:D2,D2)=1,"aquisition","retention")Does this formula return your expected result?
OliverScheurich
Aug 10, 2022Gold Contributor
=IF(COUNTIF($D$2:D2,D2)=1,"aquisition","retention")Does this formula return your expected result?
- Lukas_P11Aug 10, 2022Copper ContributorWhen you think you have found out the simpliest solution there is always another 😄 I did not even think about this one. Thank you very much!