Quote:
Originally Posted by Spencer101
Hi,
I'm sure there are in-cell formula ways of doing this but it's far to early in the day for my brain to come up with one.
However, in the attached I've provided a simple way of solving this problem by using a couple of simple helper columns.
I've added notes within the file that should help explain.
Let me know if this helps or not and feel free to ask if you need any of it explaining further.
S.
|
Thanks a lot for the solution and the fact you provided me with a working excel sheet. Forgot to mention I use Excel 2010. I very much appreciate the effort. It gets the job done and I can even understand what your are doing.I personally like to keep my (work)sheets 'clean' (no hidden cells if not really needed because I will distribute the file) so should you happen to find an 'in cell' formula when your brain is up to it it would be again very much appreciated.
Of course if someone else has found a solution for this little puzzle I would be glad to hear from. You can take Spencers sheet as a starting point because all data for testing is already in it.