Hi,
I need some help please to be able to quickly sort a table on "Date / Time" and (firstly) another column (F1). Then I need to have the top 3 items of F1 (for each unique Date / Time) marked as A, B and C in Column T3F1.
(See attached file).
It would be extremely useful if the unique "Date/Time/F1" set of data could be conditionally coloured with Red to Green scale. I've just updated the attached file to show some of the colouring applied.
After the Date/Time/F1 sort, I then need to sort table on Date/Time/F2. Then I need to have the top 3 items of F2 (for each Date Time) marked as 1/2/3 in Column T3F2.
Again, it would be extremely useful if the unique "Date/Time/F2" set of data could be conditionally coloured with Red to Green scale.
I need to repeat this for F3 and F4 also.
This takes too long to do manually and I've looked at trying Index/Match in formulas but can't get my head around it.
I tried recording macros but can't seem to get anything working since the ranges are dynamic owing to the filters.
I'm sure it just needs a VBA that loops on each filter but my VBA skills are minimal.
Any help would be gratefully received.
PS. The ABC entries need to have a condition applied - eg .... IF([@F2]>E3*1.333,"A*","A").
PPS. It would also be useful to have the Top 3 items colour coded (RAG) within the VBA. However, this is not critical as I know how to apply colour scales easily.