Regonise coloum A while adding up coloum B to give a result in C

B

B.H.JIG

A B C
1 licence No. weight status
2 gmb123r 100
3 gmb234q 150
4 gmb789h 250
5 gmb123r 150
6 gmb123r 275

What I am trying to do is when you type in the licence number and the weight
into coloums A&B, Coloum C returns weither or not the licence is "used" or
"open" and to update for every new row added, recognising that it only takes
away from the one licence total that has been entered.
Licence maximum weights gmb123r=525 so when row 6 is entered all 3 rows
would now say "used"
Also if possible if you entered a weight that took licence gmb123r over its
weight allowance coloum C would say "too much"
 
T

Toppers

put in C2 and copy down

=IF(SUMIF($A$2:A2,A2,$B$2:B2)>Maxwt,"too much","used")

Replace "Maxwt" with formula(?) e.g. VLOOKUP, to get the maximum weight for
a given licence number.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top