ExcelBanter - Custom lists - not following defined order

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Custom lists - not following defined order (https://www.excelbanter.com/excel-worksheet-functions/14230-custom-lists-not-following-defined-order.html)

Custom lists - not following defined order

I have made the following custom list.

GR2-E7
GR4-E7
REST
G-E7
GR2-E7
G-E7
G-E7
REST
G-E7
GR2-E7
GR4-E7
REST
G-E7

When using the fill method by dragging from the first cell (i.e.
GR2-E7) excel reaches the second GR2-E7 it should goto G-E7, G-E7, etc.

However, it then follows with GR4-E7.

Note: I am dragging from left to right.

Any ideas as I have loads of rows to fill, and I dont want the users to
do this manually.

Thanks in advance.

See answer to your identical question of 2 hours ago.

In article .com,
"Darren" wrote:

I have made the following custom list.

GR2-E7
GR4-E7
REST
G-E7
GR2-E7
G-E7
G-E7
REST
G-E7
GR2-E7
GR4-E7
REST
G-E7

When using the fill method by dragging from the first cell (i.e.
GR2-E7) excel reaches the second GR2-E7 it should goto G-E7, G-E7, etc.

However, it then follows with GR4-E7.

Note: I am dragging from left to right.

Any ideas as I have loads of rows to fill, and I dont want the users to
do this manually.