Answer the question
In order to leave comments, you need to log in
How to make a blank cell have a dash?
Using the formula ARRAYFORMULA from a set of numbers (long code) 30091968369303, units are carried into different cells into one cell, all two into another, etc.
Those numbers that are not present in the long code would like to see a dash (-).
It looks more visual.
Table at the link:
https://docs.google.com/spreadsheets/d/1vqKnsN_8qQ...
I would be grateful if there is a solution :)
Answer the question
In order to leave comments, you need to log in
Just add a condition to the formula
=ARRAYFORMULA(
IF(
REGEXREPLACE(Цифровое_представление; "[^"&Сетка_чисел&"]";"")="";"-";
REGEXREPLACE(Цифровое_представление; "[^"&Сетка_чисел&"]";"")
)
)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question