Related:
- Find the value in a row of a matching column
- How to delete a row in a table in word - Guide
- Saints row 2 cheats - Guide
- Excel column number - Guide
- Sed delete matching line - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
1 response
Anonymous User
Jun 26, 2012 at 08:44 AM
Jun 26, 2012 at 08:44 AM
Hello,
you should try this formula :
=vlookup("Schusser",your table,2)
I don't have the English version of Excel installed on my computer, so I don't remember if the symbol used is "," or ";" like in the French version.
I let you replace your table by the correct table which contains the 6 lines and the 6 rows apparently.
the number "2" is to get the value of the second row of your table (for year 2012 apparently).
if you need more explanations, ask me! ^^
bye
you should try this formula :
=vlookup("Schusser",your table,2)
I don't have the English version of Excel installed on my computer, so I don't remember if the symbol used is "," or ";" like in the French version.
I let you replace your table by the correct table which contains the 6 lines and the 6 rows apparently.
the number "2" is to get the value of the second row of your table (for year 2012 apparently).
if you need more explanations, ask me! ^^
bye
