A
A
Alina Shah2021-08-18 05:15:45
Google Sheets
Alina Shah, 2021-08-18 05:15:45

How to check for the presence of digits and concatenate them?

https://docs.google.com/spreadsheets/d/1kA10XbhcO7...

Column A - the rules for writing the numbers found.
Column C - the presence of numbers.
Column E - task : check for the presence of numbers in C and write them down with a hyphen, as shown in the rules. Now I manually wrote it down there, as it should turn out.
Column G - write the result of the task using a formula.

Those. check in C and write in G:
- there are 1 and 2, write down 1-2
- there are 2 and 4, write down 2-4
- there are 3 and 6, write down 3-6
- there are 4 and 8, write down 4-8
- there are 5, but no 10, nothing is recorded
- there are 6, but no 12, nothing is recorded
- no 7, but there are 14, nothing is recorded
- there are 8, but no 16, we do not write down anything
- there are 9, but there is no 18, we do not write down anything
- there are no 10 and there is no 20, we do not write down anything
- there are 11 but there are no 22, we do not write down anything
- we have 5 and 8, we write down 5 -8
- there are 8 and 11, we write down 8-11
- there are 8 but no 22, we do not write down anything
- there is no 13, but there are 14, we do not write down anything
- there is no 13 and there is no 16, we do not write down anything
- there is no 13 and there is no 19, do not write down anything
- there are no 14 and there is no 16, we do not write down anything
- there are 14 and 19, we write down 14-19
- there is no 16, but there is 19, we do not write down anything

I tried to work with the first rule 1-2:
=IF(I41:I61= 1; I41:I61=2 ;CONCATENATE(1;"-";2))
=IFERROR((IF(I41:I61=1; I41:I61=7 ;CONCATENATE(1;"-";7)));"")
did not get the desired result, if you continue to apply it.
It's here, if anything:
https://docs.google.com/spreadsheets/d/1kA10XbhcO7...

The task is simple, but I'm doing something wrong. Either "Syntax error in the formula", then it shows "FALSE", then it concatenates what is not in column C.
It is necessary that nothing be written down if the rule does not match.

Brothers in mind, help))) I'm sure there is a solution!
Who will help, I will quickly do, using the created algorithm, according to your date of birth, the definition of strong activations and in which direction luck will accompany in the coming year.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alina Shah, 2021-08-18
@Shah_Alina

solution found by myself
https://docs.google.com/spreadsheets/d/1kA10XbhcO7...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question