Related:
- Dynamic seletion of rows
- Samsung dynamic picture mode - Guide
- Repeat rows in excel - Guide
- How to delete rows in word - Guide
- Vba insert multiple rows - 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
2 responses
Tweedledum
Posts
181
Registration date
Monday 19 January 2009
Status
Member
Last seen
2 April 2009
125
6 Mar 2009 à 03:45
6 Mar 2009 à 03:45
If the marks are in percentage for it would be the VLOOKUP function, you could put the 60% into another cell and reference it with a less then sign. I think that woudl work pretty well, percentages might have to be on the left of the students name instead of the right i though