Insert "X"

[MrsFrankieH]

Hello,

I am using Windows 7 and Excel 2010.

Please help me with this formula. I'm trying to create a spreadsheet that when a number is produced, an "X" corresponds with the number in another box.

Thank you,

Frankie http://

 

[Aladin Akyurek]

CF98, copied across and down:

=IF(E98=CF$76,"x","")

 

[jsuarezg]

Hello, you can try with the excel HLOOKUP function. You can use the following formula:
for the cell CF98 =IF(ISERROR(HLOOKUP(CF$76,$F98:$I98,1,FALSE)),"","X")
That formula search the number of the Row 76 in the table F98:I98. The ISERROR Function is used to evaluate if the number is find it and the IF function is used to put a nothing when isn`t find it the number or a X when it is find.
The $ symbol is used for can copy the formula in the cells what you want without affect the result of the formula.

 

[pjmorris]

Morning,

I'm not sure whether either of the previous answers actually capture the full requirement. I've understood the question to be that under each colum CF to CX you want to place as many X's (upto 4) as are represented by the numerals 0 to 9 in columns F to I. My suggestion is to enter the expression below in cell CF98 and copy it down to CX101, the IF statement will prevent it showing anything when the column heading is blank, such as in column CG.

=IF(CF$76<>"",REPT("X",COUNTIF($F98:$I98,CF$76)),"")

Hope this helps.

 

[MrsFrankieH]

Hello Aladin,

How are you today? I appreciate your formula! It looks great! I can't try to use yours and others formulas. It teaches me just a little bit more about excel!!

Thank you for you help!

Frankie

 

[MrsFrankieH]

Hello Pj,

I hope you are having a wonderful day!!

Thank you for the formula and thank you for explaining it to me!! I've learned and will continue to learn these formulas, thanks to good people like yourself!!

I appreciate your help!!

Frankie

 

[MrsFrankieH]

Hello jsuarezg,

I hope your day is bright and wonderful!!

Thank you for your help with this formula. It has stymied me for days!!! I wondered what the $ was for in the formula. Thank you for explaining it to me!! Have a great day and thank you for your help!!

Frankie

 

[MrsFrankieH]

Update:

Hello Aladin,

For some reason, the formula didn't work. I copied and pasted it. The formula was left in the cell. What did i do wrong?

Thank you Aladin.

 

[MrsFrankieH]

Update:

Hello Jsuarezg,

The formula didn't work for me. I copied and pasted it and the formula was left in the cell. Also, i noticed that CF$76 was the cell above the "O". Could explain please?

Thank you!! )

 

[MrsFrankieH]

Hello pjmorris,

I'm sorry, the formula didn't work and remained in the cell. If you'd like and if you don't mind, i'd like to send the whole spreadsheet to you. Please advise.

Thank you!! )