im having trouble working out how to do this

I have two fields of data

Priority / Shift

Shfts are either AM, PM or EVE

Priority will be a number and not Duplicated more then once for each
shift. Therefore there could be 1 and AM as well as a 1 and PM

i would like to add an additional priority column like so

New@@Priority@@Shift
2"""""""""""1""""""""""""PM
1"""""""""""1""""""""""""AM
3""""""""""""1""""""""""""EVE
4""""""""""""2""""""""""""EVE
5""""""""""""3""""""""""""EVE

The new column is prioritised by the lowest priority starting with the
AM's then PM's then EVE's



If ive not explained this clearly enough and you think you could help
please say and ill try and explain it better.


Please help,


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=546509

Could you not do this by sorting the data firstly by shift and then by
'old priority' and then adding a sequence starting at one to get your
new priorities?

You would need to change the names of your shifts to get them to sort
in your desired sequence e.g. 1-AM, 2-PM, 3-EVE.

If the original sequence is important to you you could add an
additional sequence number column before sorting and use this to
deconvolute the data as a last step.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=546509