Need help with excel

Reply #3

jehb — Thu, 30 Apr 2015 08:48:31 GMT

Thanks for the help I will give this a shot

Reply #2

Xaique — Wed, 29 Apr 2015 22:19:10 GMT

Unfortunately, it is hard to use this text editor to show you a possible solution, and it is not possible to send files.

Here is one solution:

Put your numbers on cell A2, without spaces and separated by commas:

9,21,23,31,35

Then, put on cells B1 to AJ1, numbers from 1 to 35 (you can write 1 on cell B1, 2 on cell C1 and then, selecting both cells, drag them until AJ1).

Use the next expression on cell B2 and then drag it until cell J2:

=IF(ISNUMBER(IF(MID($A$2,1,2)=CONCATENATE

Reply #1

SergeM — Wed, 29 Apr 2015 18:53:08 GMT

A String is a Text in Excel. You have to read the text functions list.

Need help with excel

jehb — Wed, 29 Apr 2015 10:30:39 GMT

Hey all im fairly new to using excel and was hoping someone could help me with a formula to count if a number is in a string.

For example: (9, 21, 23, 31, 35,) are in cell A2. I want to know if a 31 is in this group by getting a 1 if so and a 0 if not.

This is just an example i want to do this for numbers 1-35.

Thanks in advance for the help