Hi Fellow MrExcelian Experts.

I have A problem I will try to be clear:

Its simplying my final data analysis to replace the Tedious VISUAL IDENTIFICATION of Number Series

My final data analysis table sorted in Order of Colns B & AG (Critical colns of Interest) is close to this one Example.

My data table start from Column A to AG: Coln A is Date, Coln B Subject Names, Coln C is Blank, Colns D to AG are values & MORE IMPORTANTLY COLNs G & B.

The difficulty I have is matching any combination of varied numbers rounded to 2d.p. in COLUMN AG IN SEQUENCE Eg. assuming in coln AG for one Subject Name is as follows vertically; (1.27, 4.15, 6.13, 3.12, 1.05, 2.15, 2.11, 3.15), I need to pick out in ascending order no.s (2.15, 3.15, 4.15). My problem is: Is there a formula or VBA code to apply concurrently to Coln B & AG to help "Smoke out" the series from Eg. above

Any appropriately different approach is welcome.

Regards with Thanks

Patrick

EDIT:

Missing vital info: The table is a result of consolidating 2 sheets. Each sheet filled with 2 different colours.

Data after sorting by Coln B & AG in each sheet is identifiable by 2 distinct colours eg. Blue for one. & Yellow for the other hence each Coln B (Subject Name).

ONE CRITICAL CONDITION IS:

ONLY 2 numbers FOLLOWING EACH OTHER MUST COME FROM ONE COLOUR. Eg from Blue 2.15, 3.15 & from Yellow 4.15 & Vice versa is perfect.

Its clear now

I have A problem I will try to be clear:

Its simplying my final data analysis to replace the Tedious VISUAL IDENTIFICATION of Number Series

My final data analysis table sorted in Order of Colns B & AG (Critical colns of Interest) is close to this one Example.

My data table start from Column A to AG: Coln A is Date, Coln B Subject Names, Coln C is Blank, Colns D to AG are values & MORE IMPORTANTLY COLNs G & B.

The difficulty I have is matching any combination of varied numbers rounded to 2d.p. in COLUMN AG IN SEQUENCE Eg. assuming in coln AG for one Subject Name is as follows vertically; (1.27, 4.15, 6.13, 3.12, 1.05, 2.15, 2.11, 3.15), I need to pick out in ascending order no.s (2.15, 3.15, 4.15). My problem is: Is there a formula or VBA code to apply concurrently to Coln B & AG to help "Smoke out" the series from Eg. above

Any appropriately different approach is welcome.

Regards with Thanks

Patrick

EDIT:

Missing vital info: The table is a result of consolidating 2 sheets. Each sheet filled with 2 different colours.

Data after sorting by Coln B & AG in each sheet is identifiable by 2 distinct colours eg. Blue for one. & Yellow for the other hence each Coln B (Subject Name).

ONE CRITICAL CONDITION IS:

ONLY 2 numbers FOLLOWING EACH OTHER MUST COME FROM ONE COLOUR. Eg from Blue 2.15, 3.15 & from Yellow 4.15 & Vice versa is perfect.

Its clear now

Last edited by a moderator: