Thanks dave for the fast reply but when i use the first formula ots showin all alpha (Coloumn I sheet 3)
In the second formula the delta and charlie is displayed twice in the adjacent coloums (Sheet 2, E) eventhough their value is very different and also i am not able to populate the amount in the next coloumn "F" . :-)
Bookmarks