Simple Macros Table Count

[arceaf]

Hi,

I'm trying to build a formula that will count the position of a cel
relative to a list. You'll find a pic attached.

When I select "34" from the drop down menu, the table automaticall
populates cell h10 with the #34. I need to know what position 34 i
relative to the list (report 34 would be the second report on the list)

How can I do this? The match function does not work.

Thank you

+-------------------------------------------------------------------
|Filename: match function with numbers.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=886
+-------------------------------------------------------------------

 

[lhkittle]

Hi,



I'm trying to build a formula that will count the position of a cell

relative to a list. You'll find a pic attached.



When I select "34" from the drop down menu, the table automatically

populates cell h10 with the #34. I need to know what position 34 is

relative to the list (report 34 would be the second report on the list)



How can I do this? The match function does not work.



Thank you!





+-------------------------------------------------------------------+

|Filename: match function with numbers.JPG |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=886|

+-------------------------------------------------------------------+

This works for me.

In J10 =MATCH(H10,B4:B10,0)
In H10 =E7
In E7 is a drop down with the values listed in B4:B10

When E7 shows 34 J10 returns 2.

Regards,
Howard

 

[Walter Briscoe]

In message <[email protected]> of
Sun, 30 Jun 2013 22:10:21 in microsoft.public.excel.worksheet.functions,
(e-mail address removed) writes

This works for me.

In J10 =MATCH(H10,B4:B10,0)
In H10 =E7
In E7 is a drop down with the values listed in B4:B10

When E7 shows 34 J10 returns 2.

Regards,
Howard

What version of Excel MAY be relevant. I use 2003.
I duplicated Howard's experience.
I suggest you might try stepping through the code.
Tools\Formula Auditing\Evaluate Formula.
For me it is 2 steps.the first calculates 34, the second 2.

 

[Claus Busch]

Hi,

Am Mon, 1 Jul 2013 03:18:12 +0100 schrieb arceaf:

When I select "34" from the drop down menu, the table automatically
populates cell h10 with the #34. I need to know what position 34 is
relative to the list (report 34 would be the second report on the list)

choose H10 as linked cell for the combo box. Then H10 shows you the
position (item number)


Regards
Claus B.

 

[Claus Busch]

Hi again,

Am Mon, 1 Jul 2013 08:13:23 +0200 schrieb Claus Busch:

choose H10 as linked cell for the combo box. Then H10 shows you the
position (item number)

the suggestion above is for form controls.
If you have a ActiveX control then try:

Private Sub ComboBox1_Change()
[H10] = ComboBox1.ListIndex + 1
End Sub


Regards
Claus B.