sequence recognizing

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

PS. Please do not SHOUT!

First rows/vs columns
rows - horizontal
columns - vertical

Second - previously you wrote about sequence(s) 3, 6, 9, 12 2, 4, 6, 8, 10
in the file there is 30 60 90 120 150 180 210 240 270 300 330 360

Will it be always the same sequence or it can be changed (how/where is stored).

You said about 3 numbers, while in column B appear only 2 numbers 90 (twice) and 120 (once).

Final comment - you are truncating numbers by just dropping off decimal part. Is it OK? because for instance 90.5679 recognized in column B (breen) is closer to 91 than 90.

So what is the sequence?

I'm asking, because every time you refer to different one:
3, 6, 9, 12 2, 4, 6, 8, 10 post #1
30 60 90 120 150 180 210 240 270 300 330 360 file attached to post #3
2, 4, 6, 8, 10 30, 60, 90, 120, 150 post #5

By the way - have you read our rules: https://www.excelforum.com/forum-rul...rum-rules.html
I refer to rule 3 and your post at excelforum.pl:
http://www.excelforum.pl/topics1/roz...ch-vt62492.htm

The OEIS lists over 300,000 integer sequences. You want to identify all of those?

Let's say your sequence is in first row starting from column M

Try conditional formatting with a rule based on a formula:

Formula:

Please Login or Register  to view this content.

In PL version of excel it will be:

Formula:

Please Login or Register  to view this content.

See attachment

But if you want to use this formula in a worksheet (not in conditional formatting), you have to commit it as an array formula - by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Originally Posted by astromasterastro

in THE first post I described it as "PREVIOUSLY DESCRIBED SEQUENCE OF NATURAL NUMBERS - 2, 4, 6, 8, 10 OR 3, 6, 9, 12, 15"

You mean arithmetic sequences?

That's what I was thinking until you posted the Fibonacci sequence.