Thread
:
how do I deduct furthest south cell from furthest north cell?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
how do I deduct furthest south cell from furthest north cell?
use MATCH to look for a number larger than possible and subtract that
--
Don Guillett
SalesAid Software
"Ollie" wrote in message
...
example: If I put '3000' in Cell 'A1' and in colomn 'A' there are repeated
numerical amounts being added ie 'A3 50, A8 32, A13 68' what sum would I
need
to deduct the furthest south cell 'only' from the '3000' in cell A1.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett