View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sum Limit and marking
 
Posts: n/a
Default sum limit and marking

Hello,

My question is regards to marking where my data is at its limit. For
example, if I have data for usage, but I want my limit to be at 100 items and
have it mark where the limit is so I know when and where I had to put in an
order.

For example:

Usage Limit
50
50
10
30
25 X
50
25
25 X

So at A6 and A9 I had put in a new order.

Is there a formula to mark when and where this limit occurs?

Thanks