i need to order the cell in f column

[mgm90210M]

a

b

c

d

e

f

g

2

3

guy/www/doc <tbody> </tbody>

guy/www/doc

4

http://www.mrexcel.com/ <tbody> </tbody>

word

5

http://www.mrexcel.com//

6

https://mail.google.com/ <tbody> </tbody>

http://www.mrexcel.com/

7

buy <tbody> </tbody>

8

http://www.mrexcel.com// <tbody> </tbody>

9

seri

https://mail.google.com/

<tbody>
</tbody>

please

i need to order the cell in f column
in c column

all the cell in f column
that include at lest one character of: /
and put Tham in c column

but the function should ignore empty cell in f column
or word in the cell in f column
without /

 

[mgm90210M]

please

can any one help me

it is very imported

 

[NiceCyte]

Put this code into C2: =IF(ISERROR(FIND("/",F2)),"",F2)

Then copy it down as far as you need to go.

Then, just highlight column C and sort, or highlight the all columns ABCDEF and sort.

Hope that helps.

 

[jasonb75]

Enter this in C2, adjust ranges as needed.

=IFERROR(INDEX($F$1:$F$50,SMALL(IF(ISNUMBER(FIND("/",$F$1:$F$50)),ROW($F$1:$F$50)),ROWS($C$2:$C2))),"")

Array confirm with Shift Ctrl + Enter then fill down.

 

[mgm90210M]

Enter this in C2, adjust ranges as needed.

=IFERROR(INDEX($F$1:$F$50,SMALL(IF(ISNUMBER(FIND("/",$F$1:$F$50)),ROW($F$1:$F$50)),ROWS($C$2:$C2))),"")

Array confirm with Shift Ctrl + Enter then fill down.

please i have a mac excel
can you tell me how to do this in mac excel

i didn't find out in the internet

please

 

[jasonb75]

How to do what on the mac? How to confirm the array is easy to find if you look.