Hello... How do I explain...
Here's my data.... two columns
TS00005000 P
TS00005000 S
TS00005001 P
TS00005001 S
TS00005001 S
TS00005002 P
TS00005002 S
I am looking for a formula that will look at both pieces of data on each row and bring in the following....
TS00005000 P 1 OF 4
TS00005000 S 2 OF 4
TS00005001 P 1 OF 4
TS00005001 S 2 OF 4
TS00005001 S 3 OF 4
TS00005002 P 1 OF 4
TS00005002 S 2 OF 4
Any ideas? Appreciate it greatly! Thanks.
Bookmarks