Hello,
Id like to automate the assigning of a number in Column C for each person added to the spreadsheet. Annually there are ~900 people added. The number generated is based on the following.
Column D variables are: 5, 6, 7 or 8
Column E variables are: F or M
The first number for each combination are:
5F=1000
5M=2000
6F=3000
6M=4000
7F=5000
7M=6000
8F=7000
8M=8000
The first Cell is C2
On the attached txt file I went through the possible combinations for the first two rows. I can get the numbers to increase with a looping 5F=5F+1 for example but that's about as far as I get to automating the number calculation unfortunately!
Any help on how to achieve this would be greatly appreciated.
Thank you.
Bookmarks