Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Does specific value exist in a range
Hi everyone, I'm trying to create a tool that can help me with Sudoku (I'm getting bored of charting the possible values of a given cell). To do this, I must find out whether a given value (for example 3) exists in a specified range. I can't find a function that does this for me. In my perfect world, it would work something like this: =if((A1:A5,B3:B7) in 5, true, false) All ideas appreciated. :) -- coloradoprof ------------------------------------------------------------------------ coloradoprof's Profile: http://www.officehelp.in/member.php?userid=5258 View this thread: http://www.officehelp.in/showthread.php?t=1270123 Posted from - http://www.officehelp.in |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
count specific text that occurs in a range of cells | Excel Discussion (Misc queries) | |||
count number occurring within specific date range | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
How to save a specific range of data | Excel Discussion (Misc queries) |