if a cell contains "xxx" function

Truckman

New Member
Joined
Nov 17, 2009
Messages
8
I want to create a formula or VBA that can convert a cell depending on a group of codes contained in another cell.

For example

In the cells of column E I have information like the codes shown below.<TABLE style="WIDTH: 240pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=320 border=0 x:str><COLGROUP><COL style="WIDTH: 240pt; mso-width-source: userset; mso-width-alt: 11702" width=320><TBODY><TR style="HEIGHT: 25.5pt" height=34><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; WIDTH: 240pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" width=320 height=34>C3300,DD2,EM8,F04,FD1,GE3,GH4,HPL,KH8,KX9,M45</TD></TR></TBODY></TABLE>
I need the cells of column B to search and if code F04 is found somewhere in column E it automatically generates that individual code in column B.

Hope someone can help out with this one, thanks
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
Truckman,

I hope this helps.

Excel Workbook
ABCDE
1Search for
2C3300C3300AAA
3C3301
4C3300C3300DD2
5F04F04
6F05EM8
7M54
8M45M45F04
9HPLHPL
10HPLLFD1
11
12GE3
13
14GH4
15
16HPL
17
18KH8
19
20KX9
21
22M45
23
24C3300
25
Sheet1




The formula in cell B2 copied down to the end of the data in column E:
=IF(ISNA(MATCH(A2,E:E,0)),"",A2)
 

Truckman

New Member
Joined
Nov 17, 2009
Messages
8
Hiker,

sorry my post was a little confusing, the information shown in column E is a cut-out of the information from one cell, all the codes are shown as one piece of continuos test rather then in individual codes in individual cells.

<TABLE style="WIDTH: 415pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=552 border=0 x:str><COLGROUP><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5778" width=158><COL style="WIDTH: 296pt; mso-width-source: userset; mso-width-alt: 14409" width=394><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 119pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #99ccff" width=158 height=17>A</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 296pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff" width=394>B</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" height=17>MB 16XX L 4x2 AU</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 296pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=394>1624 L,AF4,C5360,F20,F33,GC6,GE1,K01,MQ6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" height=17>MB 16XX L 4x2 AU</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 296pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=394>1624 L,AF4,C5360,F20,F33,GC6,GE1,K01,MQ6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" height=17>MB 16XX L 4x2 AU</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 296pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=394>1624 L,AF4,C5360,F20,F33,GC6,GE1,K01,MQ6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" height=17>MB 16XX L 4x2 AU</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 296pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=394>1624 L,AF4,C5360,F20,F33,GC6,GE1,K01,MQ6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" height=17>MB 16XX L 4x2 AU</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 296pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=394>1624 L,AF4,C5360,F20,F33,GC6,GE1,K01,MQ6</TD></TR></TBODY></TABLE>

Is it possible to create some sort of code or VBA that picks out a particular F code (Could be F04, F07 or F05). And automatically generates it in another cell.
 

Truckman

New Member
Joined
Nov 17, 2009
Messages
8

ADVERTISEMENT

Mike

thanks thats almost what i'm after, I think i'm missing one small part though as it automatically generates the code the cells that do not contain "F20", is there a way to reverse it?
 

Blade Hunter

Well-known Member
Joined
Mar 13, 2008
Messages
3,147
Mike

thanks thats almost what i'm after, I think i'm missing one small part though as it automatically generates the code the cells that do not contain "F20", is there a way to reverse it?

It works fine for me, It results in F20 is F20 exists somewhere in the cell to the left.
 

Truckman

New Member
Joined
Nov 17, 2009
Messages
8
sorry guys, I had mistyped a cell number before dragging the formula down through the other cells, this is working now. I can't use excel Jeani to paste an example in but I can just copy it, Attached is a copy of the worksheet so far.

Is there a way to extend on the formula as you can see in the worksheet sometimes the F20 code needs to be found but on other rows its an F07, F05 or F04 code i'm looking for.

How can i extend to formula to decide which one needs to be shown?

<TABLE style="WIDTH: 500pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=667 border=0 x:str><COLGROUP><COL style="WIDTH: 84pt; mso-width-source: userset; mso-width-alt: 4096" width=112><COL style="WIDTH: 416pt; mso-width-source: userset; mso-width-alt: 20297" width=555><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 id=td_post_2137244 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 84pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #99ccff" width=112 height=17>Auto Generated</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #99ccff" width=555>Option Codes</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B2)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C4500,EM8,ES5,F20,GS3,GT1,KU4,MW5,NH2</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: #ffff99" height=34 x:str="" x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B3)))'> </TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP3,B99,C4500,C63,C93,EB3,EM8,ES5,F07,GS3,K68,KU4,L30,M45,M49,MW5,NH2,QC4,QE2,R38,TR5</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: #ffff99" height=34 x:str="" x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B4)))'> </TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP3,B99,C4500,C63,C93,EB3,EM8,ES5,F07,GS3,K68,KU4,L30,M45,M49,MW5,QC4,QE2,R38,TR5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B5)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C4500,C63,C93,EM8,ES5,F20,GS3,GT1,KU4,MW5,NH2,QC4,QE2,R38,TR5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:str="" x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B6)))'> </TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C3300,C93,EM8,F07,GS3,GT1,KU4,L30,MW5,N52</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: #ffff99" height=34 x:str="" x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B7)))'> </TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP3,B99,C4500,C63,C93,EB3,EM8,ES5,F07,GS3,K68,KU4,L30,M45,M49,MW5,QC4,R38,TR5</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: #ffff99" height=34 x:str="" x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B8)))'> </TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP3,B99,C4500,C63,C93,EB3,EM8,ES5,F07,GS3,K68,KU4,L30,M45,M49,MW5,QC4,R38,TR5</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: #ffff99" height=34 x:str="" x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B9)))'> </TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP3,B99,C4500,C63,C93,EB3,EM8,ES5,F07,GS3,K68,KU4,L30,M45,M49,MW5,QC4,R38,TR5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B10)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C4500,C63,C93,EM8,ES5,F20,FZ9,GS3,GT1,KU4,L30,M67,MW5,S28</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B11)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C4500,EM8,ES5,F20,GS3,GT1,KU4,MW5,NH2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B12)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C4500,EM8,ES5,F20,GS3,GT1,KU4,MW5,NH2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B13)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C4500,EM8,ES5,F20,GS3,GT1,KU4,MW5,NH2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B14)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C4500,C63,C93,EM8,ES5,F20,GT1,KU4,MW5,NH2,QC4,QE2,R38,TR5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B15)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C4500,C63,C93,EM8,ES5,F20,GT1,KU4,MW5,NH2,QC4,QE2,R38,TR5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B16)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C4500,EM8,ES5,F20,GT1,KU4,MW5,NH2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffff99" height=17 x:fmla='=REPT("F20",ISNUMBER(FIND("F20",B17)))'>F20</TD><TD class=xl27 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 416pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=555>2633,AP1,C63,C93,EM8,F20,GD3,GS2,KH3,KU4,M45,MW5,MZ9,N56</TD></TR></TBODY></TABLE>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,822
Messages
5,598,304
Members
414,224
Latest member
Crazy_FC

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
Top