Nick07
01-15-2009, 02:10 PM
Hello :hi:,
I am trying to solve a problem in VBA that is well beyond my knowledge so I am posting here in the hope that somebody may be able to help.
I have a column in Excel, say Column A, that contains either a one, two or three digit value or, on very rare occasions, no value at all. I would like to be able to sum the two smallest values in this cell and have the results appear in Column B. In the event that there is only one digit in the relevant cell then Column B should just hold that value. If column A is empty then Column B should be empty too. For example:
Column A Column B (required value)
171 ------ 2
11 ------- 2
293 ------ 5
452 ------ 6
111 ------ 2
112 ------ 2
62 ------- 8
2 -------- 2
718 ------ 8
264 ------ 6
334 ------ 6
-------
529 ------ 7
718 ------ 8
21 ------- 3
Any help would be greatly appreciated.
All the best,
Nick
I am trying to solve a problem in VBA that is well beyond my knowledge so I am posting here in the hope that somebody may be able to help.
I have a column in Excel, say Column A, that contains either a one, two or three digit value or, on very rare occasions, no value at all. I would like to be able to sum the two smallest values in this cell and have the results appear in Column B. In the event that there is only one digit in the relevant cell then Column B should just hold that value. If column A is empty then Column B should be empty too. For example:
Column A Column B (required value)
171 ------ 2
11 ------- 2
293 ------ 5
452 ------ 6
111 ------ 2
112 ------ 2
62 ------- 8
2 -------- 2
718 ------ 8
264 ------ 6
334 ------ 6
-------
529 ------ 7
718 ------ 8
21 ------- 3
Any help would be greatly appreciated.
All the best,
Nick