one column have text than other should have numeric

[vipulhumein]

if in any cell of column A i wrote text "FOC" then active cell of column B should have only numeric value and if in any cell of column A i wrote any numeric value then active cell of column B should have "FOC" ...


how this can be happen please help

 

[Sajan]

Hello vipulhumein,

Could you describe what you mean by "active cell"? Is that the cell that a user has currently selected? If the user moves the mouse to another cell, does the active cell change?

Also, please describe what you mean by "should have only numeric value". Are you wanting to convert values that are already in the cell? For example, if a cell has "ABC123", do you want it to display 123, or 0 (since ABC123 is not numeric)?


It may be easier to follow what you are asking if you could post some sample data, along with your desired output for that sample data.


Cheers,

Sajan.

 

[nazmul_muneer]

Dear vipulhumein

Please upload a sample file and quote your required output.


Regards


Muneer

 

[SirJB7]

Hi, vipulhumein!


For cell B1 set data validation as follows and copy down as required:

a) Data Validation, Custom

b) In Formula enter: =O(Y(ESNUMERO(B1);CONTAR.SI(A:A;"FOC")>0);Y(B1="FOC";CONTAR(A:A)>0)) ----->in english: =OR(AND(ISNUMBER(B1),COUNTIF(A:A,"FOC")>0),AND(B1="FOC",COUNT(A:A)>0))


Regards!