Thread: Subtraction from the lowest number postion wise in Column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Subtraction from the lowest number postion wise in Column
On Wed, 15 Feb 2012 20:24:57 +0000, Gandaf wrote:

If your numbers are in column A, with "original" in A1, then try:

=A1-LOOKUP(2,1/(A:A<0),A:A)


Perfect, thank you very much




--
Gandaf

Glad to help. Thanks for the feedback.
Reply With QuoteReply With Quote