#### darkfreedoom

##### New Member

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

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

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
G3, just enter and copy down:

=LOOKUP(9.99999999999999E+307,B3:F3,\$B\$2:\$F\$2)

Try
Code:
``=COUNTIF(B3:F3,">=0")``

G3, just enter and copy down:

=LOOKUP(9.99999999999999E+307,B3:F3,\$B\$2:\$F\$2)

thx, it works.
But may I know what
9.99999999999999E+307
stand for?

Try
Code:
``=COUNTIF(B3:F3,">=0")``

thx, it works if i have every version of it.
But it won't work if i skip a previous version.

say, i have version 2, and 3 but dun have version 1.

thx anyway. i learn a new formula from you.

My apologies.....I wondered why Aladin had such a difficult formula for a simple count..
You'll notice that the version No is also the number of entries in your table, which confused me.....obviously not so with Aladin.

it seems like my example does not fit my work
here i post a part of my work here. Hope expert will help.

same problem,
I would like to know is there any formula that can return value as shown in the RED cells?

Note: The 3 yellow cells are merge.

here's the example excel file.

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

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

those yellow cells in Row1

Last edited:

Replies
7
Views
292
Replies
10
Views
526
Replies
3
Views
178
Replies
1
Views
269
Replies
0
Views
299

1,203,068
Messages
6,053,346
Members
444,654
Latest member
Rich Cohen

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back