# Text Formula

#### Wolfman1963

##### New Member
I would like to knowthe formula to make three cells stay blank if there is an X in a cell after them in a row and for that cell with the X to go blank if any of the three cells before it contain an X? for example if A4 contains an X then A1, A2, and A3 are blank, however if there is an X in any one of A1, A2, or A3 then A4 is blank.

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### Gerald Higgins

##### Well-known Member
Hi W, welcome to the board.

You're going to struggle with this, because this will create a circular reference.
Basically this boils down to something like this -
If A1=1, make A2=2
If A2=1, make A1=2.
How do you decide which has priority ?

Replies
4
Views
268
Replies
4
Views
387
Replies
2
Views
165
Replies
5
Views
311
Replies
2
Views
241

1,190,959
Messages
5,983,863
Members
439,867
Latest member

### 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.

### Which adblocker are you using?

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

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