find the lowest value in a row and add a number to it

G

Guest

I have a row with class grades in it and I want to be able to automatically
find the lowest grade and add the bonus points to it.

Ex: Column A - 85 Column B - 98 Column C - 75 Column D - 100 Column E
- 5

I want the formula to find Column C as the lowest number and add Column E to
it (the 5 points) so Column C will now read 80 instead of 75.

Any help? Thanks!
 
R

Roger Govier

Sorry Kim

I didn't read your question correctly.
You will need a VBA solution to achieve this, and whilst I could eventually
work it out, there are others in this group who will give you much more
efficient code to achieve your requirement.

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the lowest number in a given column 6
find lowest number and return it's adjacent cell 7
Find the number of the lowest filled row 3
Select lowest value from 3 columns 7
Return the 2 lowest numbers within a range 6
Calculate total by row number 4
Rank and Sort 4
Finding most recently entered number within a column 3

Top