MrExcel MVP, Moderator
- May 28, 2005
- Office Version
Possibly two options.Any way of not repeating the stage once it has been used in previous cell. I pick up these stages on another spreadsheet for calculating payments and I only have one payment per stage so only need each stage occurring once. What is the best way to achieve this?
1. For the layout of my previous post, change the C6 formula to this before copying across and down.
2. Change how you pick this up on the other sheet to only pick up the first instance. If you are interested to see if that is feasible/easy give us an idea (screen shot) of what is on the other sheet and what formula(s) you are currently using there.