What is the best Formula to use please?

B

Bernie_ws

New Member
Joined
Feb 6, 2020
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
I have a list in a cell that looks like Cell 1 below. I want to check if the codes in this cell are present in another sheet. This should be simple but unfortunately the order of the codes, in some instances, is different as shown in Cell 2 - so the content is the same just in a different order. Can anyone advise the best formula please?

Cell 1
ACCT 203-S1, ACCT 211-S1, COMM 201-S1, COMM 202-S1

Cell 2
COMM 202-S1, ACCT 203-S1, ACCT 211-S1, COMM 201-S1
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
There's probably a few ways to tackle this. Noting the possibility that one of this Forum's gurus may post some awesome (non-user defined function) method, the following works using a user defined function and it requires no "helper" cells (which would be another approach to this, comparing the outputs). Anyway, here goes...

In a module to your Workbook:
1581069026154.png

VBA Code: 
Function SORTCELL(strString As String, Optional strDelimiter As String = ", ") As String
    Dim strSubStrings() As String, strLeft As String, str0 As String, strRight As String
    Dim intLoop As Integer
    strSubStrings = Split(strString, strDelimiter)
    If UBound(strSubStrings) < 1 Then
        SORTCELL = strString
    Else
        str0 = strSubStrings(0)
        For intLoop = 1 To UBound(strSubStrings)
            If (strSubStrings(intLoop) < str0) Then
                strLeft = strLeft & strDelimiter & strSubStrings(intLoop)
            Else
                strRight = strRight & strDelimiter & strSubStrings(intLoop)
            End If
        Next intLoop
        strLeft = Mid(strLeft, Len(strDelimiter) + 1)
        strRight = Mid(strRight, Len(strDelimiter) + 1)
        If strLeft <> vbNullString Then _
            str0 = SORTCELL(strLeft, strDelimiter) & strDelimiter & str0
        If strRight <> vbNullString Then _
            str0 = str0 & strDelimiter & SORTCELL(strRight, strDelimiter)
        SORTCELL = str0
    End If
End Function
Showing this working in practice:
Book1
AB
1Comparing A2 to A3
2ACCT 203-S1, ACCT 211-S1, COMM 201-S1, COMM 202-S1True
3COMM 202-S1, ACCT 203-S1, ACCT 211-S1, COMM 201-S1
4whereas comparing A5 to A6
5ACCT 203-S1, ACCT 211-S1, COMM 201-S1, COMM 202-S1False
6COMM 302-S3, ACCT 203-S1, ACCT 211-S1, COMM 201-S1
Sheet1
Cell Formulas
RangeFormula
B2, B5B2=IF(SORTCELL(A2)=SORTCELL(A3),TRUE,FALSE)

NB: This relies on the data being "clean": e.g. no missing spaces like the red comma without a following space in this "ACCT 203-S1, ACCT 211-S1, COMM 201-S1,COMM 202-S1". The code could be altered to accommodate some data integrity possibilities, but it does not as-is.
 
Upvote 0
Hi,

Thanks for sending this through. I am not all that familiar with VBA so I don't know how to adjust the code. However, the range that I need to check for a duplicate is in a separate sheet and I need to check against 197 rows.

This sheet is called "PoS Analysis" see below

2016 to 2019 Pos Analysis_Macros.xlsm
C
1Pathways_S+
2ACCT 101-S2, COMM 111-S2, FINC 101-S2, MKTG 115-S2
3ACCT 202-S2, BMGT 211-S2, ECON 212-S2
4ACCT 202-S2, FINC 211-S2, LWST 201-S2
5ACCT 211-S1, FINC 204-S1, ACCT 203-S1
6ACCT 302-S1, ACCT 306-S1, ACCT 308-S1
7ACCT 620-S2, ACCT 622-S2, ACCT 625-S2, ACCT 698-S2, BMGT 618-S2
8ACCT 621-S1, ACCT 623-S1, ACCT 624-S1, ACCT 609-S1, BMGT 686-S1
9AGRI 393-S1, ANSC 312-S1, MGMT 316-S1, PLSC 320-S1, QMET 306-S1, SOSC 340-S1
10AGRI 393-S1, ANSC 312-S1, MGMT 316-S1, PLSC 320-S1, QMET 306-S1, SOSC 340-S1
11ANSC 021-S2, BIOS 021-S2, ENGN 023-S2, MGMT 025-S2,
12ANSC 105-S2, MGMT 222-S2, VAPM 310-S1, PLSC 104-S2, PLSC 321-S2
13ANSC 105-S2, PLSC 104-S2, SOSC 106-S2, ECOL 103-S2, PHSC 103-S2, VAPM 101-S2
14ANSC 105-S2, PLSC 104-S2, SOSC 106-S2, ECOL 103-S2, PHSC 103-S2, VAPM 101-S2
15ANSC 213-S1, MGMT 201-S1, PLSC 204-S1, SOSC 224-S1
16ANSC 213-S1, MGMT 201-S1, PLSC 204-S1, SOSC 224-S1
17ANSC 314-S2, MGMT 317-S2, PLSC 320-S1
18ANSC 314-S2, MGMT 317-S2, PLSC 320-S1
19ANSC 314-S2, MGMT 317-S2, PLSC 320-S1
20ANSC 314-S2, MGMT 317-S2, PLSC 321-S2
21BICH 207-S1, FOOD 201-S1, FOOD 202-S1
22BIOS 022-S2, ENGN 023-S2, MGMT 027-S2, PLSC 021-S2
23BIOS 022-S2, ENGN 023-S2, MGMT 027-S2, PLSC 021-S2
24BIOS 023-S2, LUAC 010-S2, LUAC 014-S2, SCIE 024-S2, ECOL 103-S2, MAST 106-S2, PLSC 104-S2
25BIOS 023-S2, MGMT 028-S2, SCIE 024-S2, ECOL 103-S2, MAST 106-S2, PLSC 104-S2
26BIOS 110-S1, PHSC 101-S1
27BIOS 110-S1, PHSC 101-S1, BMGT 116-S1, MGMT 106-S1, PHSC 107-S1, TOUR 101-S1
28BIOS 110-S1, PHSC 101-S1, PHSC 107-S1
29BIOS 110-S1, PHSC 101-S1, PHSC 107-S1
30BIOS 110-S1, PHSC 107-S1, SOCI 116-S1
31BIOS 304-S1, FOOD 301-S1, FOOD 304-S1
32BMGT 116-S1, COMM 112-S1, ECON 113-S1, LWST 114-S1
33BMGT 116-S1, COMM 112-S1, ECON 113-S1, LWST 114-S1
PoS Analysis


I need to check the below against the "PoS Analysis" sheet part of the range is set out below.

2016 to 2019 Pos Analysis_Macros.xlsm
B
1Pathway
2ACCT 203-S1, ACCT 211-S1, COMM 201-S1, COMM 202-S1
3ACCT 203-S1, ACCT 302-S1
4ACCT 203-S1, ACCT 306-S1, MGMT 318-S1, ECON 216-S1
5ACCT 203-S1, ACCT 308-S1, MGMT 316-S1, SOSC 224-S1
6ACCT 203-S1, ANSC 312-S1, MAST 106-S1, ANSC 327-S1
7ACCT 203-S1, FINC 204-S1
8ACCT 203-S1, FINC 204-S1, ACCT 211-S1
9ACCT 203-S1, FINC 204-S1, ACCT 211-S1, COMM 201-S1
10ACCT 203-S1, FINC 204-S1, ACCT 211-S1, COMM 202-S1
11ACCT 203-S1, FINC 204-S1, ACCT 302-S1, ACCT 306-S1, ACCT 308-S1
12ACCT 203-S1, RECN 344-S1, TOUR 304-S1, COMM 201-S1
13ACCT 302-S1, ACCT 306-S1, ACCT 308-S1
14ACCT 302-S1, ACCT 306-S1, ACCT 308-S1, ACCT 211-S1
15ACCT 302-S1, ACCT 306-S1, ACCT 308-S1, COMM 202-S1
16ACCT 302-S1, ACCT 308-S1, MGMT 316-S1, MGMT 318-S1
17ACCT 302-S1, FINC 305-S1, ACCT 306-S1
18ACCT 302-S1, FINC 305-S1, ACCT 306-S1, ACCT 308-S1, COMM 202-S1
19ACCT 302-S1, FINC 305-S1, ACCT 308-S1, FINC 310-S1
20ACCT 306-S1, ACCT 308-S1, ACCT 211-S1, COMM 201-S1
21ACCT 306-S1, ACCT 308-S1, ACCT 211-S1, COMM 202-S1
22ACCT 306-S1, COMM 113-S1
23ACCT 306-S1, MGMT 316-S1, MGMT 318-S1, ANSC 312-S1
24ACCT 308-S1, FINC 310-S1
25ACCT 605-S1, COMM 605-S1
26ACCT 605-S1, FINC 603-S1, COMM 605-S1
27ACEN 301-W, ACEN 302-W
28ACEN 301-W, ACEN 302-W, ACEN 303-W
29ACEN 301-W, ACEN 303-W
30ANSC 072-S1, ANSC 073-S1, MGMT 073A-S1
31ANSC 072-S1, ANSC 073-S1, PLSC 024-S1, MGMT 024-S1
32ANSC 072-S1, ANSC 073-S1, PLSC 024-S1, MGMT 073A-S1
33ANSC 072-S1, ANSC 073-S1, PLSC 024-S1, SOSC 021-S1
34ANSC 072-S1, MGMT 024-S1
35ANSC 072-S1, MGMT 073A-S1, ENGN 76-S1
36ANSC 072-S1, PLSC 071-S1, FORS 070-S1
37ANSC 072-S1, PLSC 071-S1, MGMT 073A-S1
38ANSC 073-S1, PLSC 024-S1, PLSC 071-S1, MGMT 073A-S1
39ANSC 073-S1, PLSC 071-S1, MGMT 073A-S1
40ANSC 213-S1, BIOS 110-S1
41ANSC 213-S1, COMM 110-S1, COMM 113-S1, GENE 201-S1
42ANSC 312-S1, ANSC 327-S1, ECOL 293-S1, ENGN 201-S1
43ANSC 312-S1, ANSC 327-S1, GENE 201-S1, AGRI 393-S1
44ANSC 312-S1, FORS 270-S1, GENE 201-S1, AGRI 393-S1
45ANSC 312-S1, WATR 202-S1, GENE 201-S1, AGRI 393-S1
46ANSC 398-S1, AGRI 393-S1
47BICH 207-S1, BIOS 304-S1, BICH 209-S1, ECOL 202-S1
48BICH 207-S1, ECOL 302-S1, PLPT 203-S1, GENE 201-S1
49BICH 207-S1, FOOD 202-S1, BIOS 110-S1
50BICH 207-S1, FOOD 304-S1, COMM 113-S1
51BICH 207-S1, FOOD 304-S1, FOOD 301-S1, FOOD 398-S1
52BICH 207-S1, FOOD 304-S1, FOOD 301-S1, TOUR 203-S1
2016_S1


Any further help would be much appreciated.

Cheers
Bernie
 
Upvote 0
Using your two (partial) sheets, here's the PoS Analysis sheet, with a "helper" column containing the output of the SORTCELL function and a VLOOKUP to see whether it is in the "helper" column in 2016_1 sheet.

Col E of PoS Analysis sheet has the yes/no result for whether there is an exact match of the sorted cells in Col D to the sorted cells in Col C of 2016_1.

Now...there's more elegant ways of doing this comparison, but since I'd already gone half way there with the user-defined function, presuming you are okay adding the "helper" columns, this will deliver what you're after.

Book1
ABCDE
1Pathways_S+SORTED (HELPER CELLS)IS IT THERE?
2ACCT 101-S2, COMM 111-S2, FINC 101-S2, MKTG 115-S2ACCT 101-S2, COMM 111-S2, FINC 101-S2, MKTG 115-S2no
3ACCT 202-S2, BMGT 211-S2, ECON 212-S2ACCT 202-S2, BMGT 211-S2, ECON 212-S2no
4ACCT 202-S2, FINC 211-S2, LWST 201-S2ACCT 202-S2, FINC 211-S2, LWST 201-S2no
5ACCT 211-S1, FINC 204-S1, ACCT 203-S1ACCT 203-S1, ACCT 211-S1, FINC 204-S1yes
6ACCT 302-S1, ACCT 306-S1, ACCT 308-S1ACCT 302-S1, ACCT 306-S1, ACCT 308-S1yes
7ACCT 620-S2, ACCT 622-S2, ACCT 625-S2, ACCT 698-S2, BMGT 618-S2ACCT 620-S2, ACCT 622-S2, ACCT 625-S2, ACCT 698-S2, BMGT 618-S2no
8ACCT 621-S1, ACCT 623-S1, ACCT 624-S1, ACCT 609-S1, BMGT 686-S1ACCT 609-S1, ACCT 621-S1, ACCT 623-S1, ACCT 624-S1, BMGT 686-S1no
9AGRI 393-S1, ANSC 312-S1, MGMT 316-S1, PLSC 320-S1, QMET 306-S1, SOSC 340-S1AGRI 393-S1, ANSC 312-S1, MGMT 316-S1, PLSC 320-S1, QMET 306-S1, SOSC 340-S1no
10AGRI 393-S1, ANSC 312-S1, MGMT 316-S1, PLSC 320-S1, QMET 306-S1, SOSC 340-S1AGRI 393-S1, ANSC 312-S1, MGMT 316-S1, PLSC 320-S1, QMET 306-S1, SOSC 340-S1no
11ANSC 021-S2, BIOS 021-S2, ENGN 023-S2, MGMT 025-S2,ANSC 021-S2, BIOS 021-S2, ENGN 023-S2, MGMT 025-S2,no
12ANSC 105-S2, MGMT 222-S2, VAPM 310-S1, PLSC 104-S2, PLSC 321-S2ANSC 105-S2, MGMT 222-S2, PLSC 104-S2, PLSC 321-S2, VAPM 310-S1no
13ANSC 105-S2, PLSC 104-S2, SOSC 106-S2, ECOL 103-S2, PHSC 103-S2, VAPM 101-S2ANSC 105-S2, ECOL 103-S2, PHSC 103-S2, PLSC 104-S2, SOSC 106-S2, VAPM 101-S2no
14ANSC 105-S2, PLSC 104-S2, SOSC 106-S2, ECOL 103-S2, PHSC 103-S2, VAPM 101-S2ANSC 105-S2, ECOL 103-S2, PHSC 103-S2, PLSC 104-S2, SOSC 106-S2, VAPM 101-S2no
15ANSC 213-S1, MGMT 201-S1, PLSC 204-S1, SOSC 224-S1ANSC 213-S1, MGMT 201-S1, PLSC 204-S1, SOSC 224-S1no
16ANSC 213-S1, MGMT 201-S1, PLSC 204-S1, SOSC 224-S1ANSC 213-S1, MGMT 201-S1, PLSC 204-S1, SOSC 224-S1no
17ANSC 314-S2, MGMT 317-S2, PLSC 320-S1ANSC 314-S2, MGMT 317-S2, PLSC 320-S1no
18ANSC 314-S2, MGMT 317-S2, PLSC 320-S1ANSC 314-S2, MGMT 317-S2, PLSC 320-S1no
19ANSC 314-S2, MGMT 317-S2, PLSC 320-S1ANSC 314-S2, MGMT 317-S2, PLSC 320-S1no
20ANSC 314-S2, MGMT 317-S2, PLSC 321-S2ANSC 314-S2, MGMT 317-S2, PLSC 321-S2no
21BICH 207-S1, FOOD 201-S1, FOOD 202-S1BICH 207-S1, FOOD 201-S1, FOOD 202-S1no
22BIOS 022-S2, ENGN 023-S2, MGMT 027-S2, PLSC 021-S2BIOS 022-S2, ENGN 023-S2, MGMT 027-S2, PLSC 021-S2no
23BIOS 022-S2, ENGN 023-S2, MGMT 027-S2, PLSC 021-S2BIOS 022-S2, ENGN 023-S2, MGMT 027-S2, PLSC 021-S2no
24BIOS 023-S2, LUAC 010-S2, LUAC 014-S2, SCIE 024-S2, ECOL 103-S2, MAST 106-S2, PLSC 104-S2BIOS 023-S2, ECOL 103-S2, LUAC 010-S2, LUAC 014-S2, MAST 106-S2, PLSC 104-S2, SCIE 024-S2no
25BIOS 023-S2, MGMT 028-S2, SCIE 024-S2, ECOL 103-S2, MAST 106-S2, PLSC 104-S2BIOS 023-S2, ECOL 103-S2, MAST 106-S2, MGMT 028-S2, PLSC 104-S2, SCIE 024-S2no
26BIOS 110-S1, PHSC 101-S1BIOS 110-S1, PHSC 101-S1no
27BIOS 110-S1, PHSC 101-S1, BMGT 116-S1, MGMT 106-S1, PHSC 107-S1, TOUR 101-S1BIOS 110-S1, BMGT 116-S1, MGMT 106-S1, PHSC 101-S1, PHSC 107-S1, TOUR 101-S1no
28BIOS 110-S1, PHSC 101-S1, PHSC 107-S1BIOS 110-S1, PHSC 101-S1, PHSC 107-S1no
29BIOS 110-S1, PHSC 101-S1, PHSC 107-S1BIOS 110-S1, PHSC 101-S1, PHSC 107-S1no
30BIOS 110-S1, PHSC 107-S1, SOCI 116-S1BIOS 110-S1, PHSC 107-S1, SOCI 116-S1no
31BIOS 304-S1, FOOD 301-S1, FOOD 304-S1BIOS 304-S1, FOOD 301-S1, FOOD 304-S1no
32BMGT 116-S1, COMM 112-S1, ECON 113-S1, LWST 114-S1BMGT 116-S1, COMM 112-S1, ECON 113-S1, LWST 114-S1no
33BMGT 116-S1, COMM 112-S1, ECON 113-S1, LWST 114-S1BMGT 116-S1, COMM 112-S1, ECON 113-S1, LWST 114-S1no
PoS Analysis
Cell Formulas
RangeFormula
D2:D33D2=sortcell(C2)
E2:E33E2=IF(ISNA(VLOOKUP(D2,'2016_S1'!C:C,1,0)),"no","yes")


Book1
ABC
1PathwaySORTED (HELPER CELLS)
2ACCT 203-S1, ACCT 211-S1, COMM 201-S1, COMM 202-S1ACCT 203-S1, ACCT 211-S1, COMM 201-S1, COMM 202-S1
3ACCT 203-S1, ACCT 302-S1ACCT 203-S1, ACCT 302-S1
4ACCT 203-S1, ACCT 306-S1, MGMT 318-S1, ECON 216-S1ACCT 203-S1, ACCT 306-S1, ECON 216-S1, MGMT 318-S1
5ACCT 203-S1, ACCT 308-S1, MGMT 316-S1, SOSC 224-S1ACCT 203-S1, ACCT 308-S1, MGMT 316-S1, SOSC 224-S1
6ACCT 203-S1, ANSC 312-S1, MAST 106-S1, ANSC 327-S1ACCT 203-S1, ANSC 312-S1, ANSC 327-S1, MAST 106-S1
7ACCT 203-S1, FINC 204-S1ACCT 203-S1, FINC 204-S1
8ACCT 203-S1, FINC 204-S1, ACCT 211-S1ACCT 203-S1, ACCT 211-S1, FINC 204-S1
9ACCT 203-S1, FINC 204-S1, ACCT 211-S1, COMM 201-S1ACCT 203-S1, ACCT 211-S1, COMM 201-S1, FINC 204-S1
10ACCT 203-S1, FINC 204-S1, ACCT 211-S1, COMM 202-S1ACCT 203-S1, ACCT 211-S1, COMM 202-S1, FINC 204-S1
11ACCT 203-S1, FINC 204-S1, ACCT 302-S1, ACCT 306-S1, ACCT 308-S1ACCT 203-S1, ACCT 302-S1, ACCT 306-S1, ACCT 308-S1, FINC 204-S1
12ACCT 203-S1, RECN 344-S1, TOUR 304-S1, COMM 201-S1ACCT 203-S1, COMM 201-S1, RECN 344-S1, TOUR 304-S1
13ACCT 302-S1, ACCT 306-S1, ACCT 308-S1ACCT 302-S1, ACCT 306-S1, ACCT 308-S1
14ACCT 302-S1, ACCT 306-S1, ACCT 308-S1, ACCT 211-S1ACCT 211-S1, ACCT 302-S1, ACCT 306-S1, ACCT 308-S1
15ACCT 302-S1, ACCT 306-S1, ACCT 308-S1, COMM 202-S1ACCT 302-S1, ACCT 306-S1, ACCT 308-S1, COMM 202-S1
16ACCT 302-S1, ACCT 308-S1, MGMT 316-S1, MGMT 318-S1ACCT 302-S1, ACCT 308-S1, MGMT 316-S1, MGMT 318-S1
17ACCT 302-S1, FINC 305-S1, ACCT 306-S1ACCT 302-S1, ACCT 306-S1, FINC 305-S1
18ACCT 302-S1, FINC 305-S1, ACCT 306-S1, ACCT 308-S1, COMM 202-S1ACCT 302-S1, ACCT 306-S1, ACCT 308-S1, COMM 202-S1, FINC 305-S1
19ACCT 302-S1, FINC 305-S1, ACCT 308-S1, FINC 310-S1ACCT 302-S1, ACCT 308-S1, FINC 305-S1, FINC 310-S1
20ACCT 306-S1, ACCT 308-S1, ACCT 211-S1, COMM 201-S1ACCT 211-S1, ACCT 306-S1, ACCT 308-S1, COMM 201-S1
21ACCT 306-S1, ACCT 308-S1, ACCT 211-S1, COMM 202-S1ACCT 211-S1, ACCT 306-S1, ACCT 308-S1, COMM 202-S1
22ACCT 306-S1, COMM 113-S1ACCT 306-S1, COMM 113-S1
23ACCT 306-S1, MGMT 316-S1, MGMT 318-S1, ANSC 312-S1ACCT 306-S1, ANSC 312-S1, MGMT 316-S1, MGMT 318-S1
24ACCT 308-S1, FINC 310-S1ACCT 308-S1, FINC 310-S1
25ACCT 605-S1, COMM 605-S1ACCT 605-S1, COMM 605-S1
26ACCT 605-S1, FINC 603-S1, COMM 605-S1ACCT 605-S1, COMM 605-S1, FINC 603-S1
27ACEN 301-W, ACEN 302-WACEN 301-W, ACEN 302-W
28ACEN 301-W, ACEN 302-W, ACEN 303-WACEN 301-W, ACEN 302-W, ACEN 303-W
29ACEN 301-W, ACEN 303-WACEN 301-W, ACEN 303-W
30ANSC 072-S1, ANSC 073-S1, MGMT 073A-S1ANSC 072-S1, ANSC 073-S1, MGMT 073A-S1
31ANSC 072-S1, ANSC 073-S1, PLSC 024-S1, MGMT 024-S1ANSC 072-S1, ANSC 073-S1, MGMT 024-S1, PLSC 024-S1
32ANSC 072-S1, ANSC 073-S1, PLSC 024-S1, MGMT 073A-S1ANSC 072-S1, ANSC 073-S1, MGMT 073A-S1, PLSC 024-S1
33ANSC 072-S1, ANSC 073-S1, PLSC 024-S1, SOSC 021-S1ANSC 072-S1, ANSC 073-S1, PLSC 024-S1, SOSC 021-S1
34ANSC 072-S1, MGMT 024-S1ANSC 072-S1, MGMT 024-S1
35ANSC 072-S1, MGMT 073A-S1, ENGN 76-S1ANSC 072-S1, ENGN 76-S1, MGMT 073A-S1
36ANSC 072-S1, PLSC 071-S1, FORS 070-S1ANSC 072-S1, FORS 070-S1, PLSC 071-S1
37ANSC 072-S1, PLSC 071-S1, MGMT 073A-S1ANSC 072-S1, MGMT 073A-S1, PLSC 071-S1
38ANSC 073-S1, PLSC 024-S1, PLSC 071-S1, MGMT 073A-S1ANSC 073-S1, MGMT 073A-S1, PLSC 024-S1, PLSC 071-S1
39ANSC 073-S1, PLSC 071-S1, MGMT 073A-S1ANSC 073-S1, MGMT 073A-S1, PLSC 071-S1
40ANSC 213-S1, BIOS 110-S1ANSC 213-S1, BIOS 110-S1
41ANSC 213-S1, COMM 110-S1, COMM 113-S1, GENE 201-S1ANSC 213-S1, COMM 110-S1, COMM 113-S1, GENE 201-S1
42ANSC 312-S1, ANSC 327-S1, ECOL 293-S1, ENGN 201-S1ANSC 312-S1, ANSC 327-S1, ECOL 293-S1, ENGN 201-S1
43ANSC 312-S1, ANSC 327-S1, GENE 201-S1, AGRI 393-S1AGRI 393-S1, ANSC 312-S1, ANSC 327-S1, GENE 201-S1
44ANSC 312-S1, FORS 270-S1, GENE 201-S1, AGRI 393-S1AGRI 393-S1, ANSC 312-S1, FORS 270-S1, GENE 201-S1
45ANSC 312-S1, WATR 202-S1, GENE 201-S1, AGRI 393-S1AGRI 393-S1, ANSC 312-S1, GENE 201-S1, WATR 202-S1
46ANSC 398-S1, AGRI 393-S1AGRI 393-S1, ANSC 398-S1
47BICH 207-S1, BIOS 304-S1, BICH 209-S1, ECOL 202-S1BICH 207-S1, BICH 209-S1, BIOS 304-S1, ECOL 202-S1
48BICH 207-S1, ECOL 302-S1, PLPT 203-S1, GENE 201-S1BICH 207-S1, ECOL 302-S1, GENE 201-S1, PLPT 203-S1
49BICH 207-S1, FOOD 202-S1, BIOS 110-S1BICH 207-S1, BIOS 110-S1, FOOD 202-S1
50BICH 207-S1, FOOD 304-S1, COMM 113-S1BICH 207-S1, COMM 113-S1, FOOD 304-S1
51BICH 207-S1, FOOD 304-S1, FOOD 301-S1, FOOD 398-S1BICH 207-S1, FOOD 301-S1, FOOD 304-S1, FOOD 398-S1
52BICH 207-S1, FOOD 304-S1, FOOD 301-S1, TOUR 203-S1BICH 207-S1, FOOD 301-S1, FOOD 304-S1, TOUR 203-S1
2016_S1
Cell Formulas
RangeFormula
C2:C52C2=sortcell(B2)
 
Upvote 0
Hi Kennypete,

Works a treat. Thanks so much for your help. It is very much appreciated.

Cheers
Bernie
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
forcing a specific format into an excel cell [not used for calculation]
Replies
9
Views
524
sjoerdbosch
S
zookeepertx
  • Solved
Moving data to other columns using multiple criteria
Replies
2
Views
352
zookeepertx
zookeepertx
M
  • Question
Creating Results Table + Hiding columns based on text in specific row
Replies
4
Views
542
MelissaBr
M
I
  • Question
Kill my file
Replies
2
Views
308
ipbr21054
I
L
  • Solved
What is the best formula to use
Replies
5
Views
62
Fluff
Fluff

Forum statistics

Threads
1,214,642
Messages
6,120,701
Members
448,980
Latest member
CarlosWin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top