Excel Formula

[Mista989]

When a number is chosen across a board ie: 1001 in 5 columns from sheet A, I am looking for the  formula so as that the same numbers in sheet B disappear and only leave unchosen numbers in sheet B. is there such a formula?

[#2]

@Mista989 You cannot do it with formulas however there is workaround

* One is press Ctrl + H and replace the number with blank i.e. "Find What" = "1001" and replace with blank

Regards

Kapil

[#3]

this is what I have tried, instead if deleting / hiding the original number, it comes out as a 0

=IF('1'!J6<7780,'1'!J6,"")

[#4]

@Mista989 yeah if you have if formula then it will work. I thought you have values available in all cells.

You can use number formatting to make 0 blanks

Select the entire column and the right click > Format cells > Number Formatting > Custom > Select 0 from the list > under Type select 0 > Remove 0 and type #. This will make all 0 blanks

Thanks

Kapil