latest version from a list

[bogd1n]

helo people


i want to make a table who coloring the lastest version on a number in my case drawing

i have a big export data from sap and i need help

i attach the fille input and output

[Pete_UK]

Select the cells that you want this to apply to (from E13 down to E24 in your example file), then click on Conditional Formatting | New Rule | Use a formula... , then copy/paste this formula into the dialogue box which pops up:

=COUNTIF(E$13:E13,LEFT(E13,FIND("_",E13)-1)&"*")=COUNTIF(E:E,LEFT(E13,FIND("_",E13)-1)&"*")

Click on the Format button | Fill tab, and choose your colour, then OK your way out. Excel will automatically adjust the cell references to suit the selected cells, so you can do this in one operation.

Hope this helps.

Pete

[bogd1n]

i updated with a little modification last_version_drw_v2

please help

tks

[AliGW]

So, no 'thank you', just an extra requirement? Hmm ... you do realise the help you get here comes for free, do you?

[bogd1n]

So, no 'thank you', just an extra requirement? Hmm ... you do realise the help you get here comes for free, do you?

ok sorry

thank you for support

but i realize the input dates changed :D

[JeteMc]

To highlight the appropriate cells in columns B:C use the following formula for conditional formatting: =$B2<>$B3
To compile a list for Output 2:
1. Use the following to get the numerical values: =IFERROR(INDEX(B$2:B$62,MATCH(0,INDEX(COUNTIF(K$1:K1,B$2:B$62),,),)),"")
2. Use the following (helper) to get the row: =SUM(COUNTIFS(B$2:B$62,K2),M1)
3. Use the following to display the alpha values: =IF(K2="","",INDEX(C$2:C$62,M2))
Let us know if you have any questions.