Hi All!
Bit of an unusual problem here, or for me anyway, I'm sure all you gurus will find an easy fix!
First off, i am using a copy of Office for Mac 2011 on a work macbook air. So any suggestions need to work on mac & windows.
I have a spreadsheet, where in Column C, The name of a client is added i.e. Client 1, Client 2, Client 3 etc. Then, in column O i have a formula:
This formula counts the number of appearances of that client. This is used as a helper to the following formula in Column B which is:Please Login or Register to view this content.
This gives me just the number from the end of the formula in Column O and then configured to show it in the format "0001", "0002", "0003" and so on.Please Login or Register to view this content.
What i now need, is in Column G, to have a data validation drop down box, dependant on the name of the client, which starts at 1 and finishes at the highest job number of that particular client. For example if Client 1 has 3 jobs, their drop down would show as 1,2,3. If Client 3 has 10 jobs, their drop down would be 1,2,3,4,5,6,7,8,9,10.
I hope this is possible? I can upload an example spreadsheet if needed, but don't have to hand right now, so hopefully this makes sense to get started on the problem.
Thanks in advance for your help guys!
Chris
Bookmarks