Ste_Moore01
Active Member
- Joined
- Jul 13, 2005
- Messages
- 467
Hi guys,
I'm trying to find a formula to work out what the first and last delivery note number is depending on the delivery address.
For example on the table below if the delivery address is Kellihers Electrical in Kilkenny the first delivery note is 97325 and the last is 97327.
Has anyone any suggestions on how I can do this with a formula?
I'm trying to find a formula to work out what the first and last delivery note number is depending on the delivery address.
For example on the table below if the delivery address is Kellihers Electrical in Kilkenny the first delivery note is 97325 and the last is 97327.
Book2.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Delivery Note | Delivery Address | ||||
2 | 97325 | Kellihers Electrical Units 1 & 2 Loughboy Industrial Estate KILKENNY Rep. of Ireland | ||||
3 | 97326 | Kellihers Electrical Units 1 & 2 Loughboy Industrial Estate KILKENNY Rep. of Ireland | ||||
4 | 97327 | Kellihers Electrical Units 1 & 2 Loughboy Industrial Estate KILKENNY Rep. of Ireland | ||||
5 | 97328 | Kellihers Electrical M50 Business Park Ballymount Road Upper BALLYMOUNT Dublin Rep. of Ireland | ||||
Sheet1 |
Has anyone any suggestions on how I can do this with a formula?