Formula Find Latest Version

[darkfreedoom]

The image is just example of what i need.
I would like to know is there any formula that can return value as shown in the RED cells?

for example, WORD, in the table we can see that the latest version is "3".
in column "G", instead of enter the value "3" manually, i would like to create a formula to return the value "3".

any expert can help me?

OS: Window XP SP3
Excel: 2007

 

[Aladin Akyurek]

those yellow cells in Row1

Try again.

A4 --> X --> Rev.B

What is that X which leads to the conclusion?

 

[darkfreedoom]

For A4, you conclude to Rev. B. What supports that conclusion, put otherwise, on what is that based?

Try again.

A4 --> X --> Rev.B

What is that X which leads to the conclusion?

can you make it "Date Received" (column B)

 

[Aladin Akyurek]

can you make it "Date Received" (column B)

Control+shift+enter, not just enter, and copy down:

=LOOKUP(9.99999999999999E+307,
    IF(MOD(COLUMN(B4:K4)-COLUMN(B4),5)=0,
      IF(ISNUMBER(B4:K4),B4:K4,"#")),$B$1:$K$1)

 

[darkfreedoom]

Control+shift+enter, not just enter, and copy down:

=LOOKUP(9.99999999999999E+307,
    IF(MOD(COLUMN(B4:K4)-COLUMN(B4),5)=0,
      IF(ISNUMBER(B4:K4),B4:K4,"#")),$B$1:$K$1)

a trillion of thanks aladin ray:
the problem solve amazingly

 

[Aladin Akyurek]

a trillion of thanks aladin ray:
the problem solve amazingly

You are welcome. Thanks for providing feedback.