Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel formula ?. Help please.
I am in a number draw based on the lottery. Each member has 10 numbers and
there are just over 400 members. I would like to try and set up a spreadsheet wherby I can enter a number in cell A1 and all cells which contain that number change to an X. Can it be done ?. Thanking you in anticipation. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel formula ?. Help please.
This is not exactly what you asked for, but:
Say you have a long list of numbers in column C and your X-out value in cell A1. Then in cell B1 put: =IF(C1=$A$1,"X",C1) and copy down This will repeat the list in column C and "X-out" the value appearing in cell A1 -- Gary's Student "Alex M." wrote: I am in a number draw based on the lottery. Each member has 10 numbers and there are just over 400 members. I would like to try and set up a spreadsheet wherby I can enter a number in cell A1 and all cells which contain that number change to an X. Can it be done ?. Thanking you in anticipation. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel formula ?. Help please.
This is a modification of the sample in VBA help index for FINDNEXT
Sub findallandmark() With ActiveSheet.Cells On Error GoTo quitit Set c = .Find(range("a1"), LookIn:=xlValues) If Not c Is Nothing Then firstAddress = c.Address Do c.Value = "X" Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address < firstAddress End If quitit: End With -- Don Guillett SalesAid Software "Alex M." wrote in message ... I am in a number draw based on the lottery. Each member has 10 numbers and there are just over 400 members. I would like to try and set up a spreadsheet wherby I can enter a number in cell A1 and all cells which contain that number change to an X. Can it be done ?. Thanking you in anticipation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |