| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for data range
I have a data row (K) that contains several numbers. For example.K2
contains the numbers. 61 62 63 64 65 66 67. K3 contains the numbers 64 65 66 67 68 ect... I'm sure there is a forumula that will allow me to say, if K3 contains 67 then L3 = 67. When in this instance L3 would = 67. If the data in K3 the numbers 69 70 71 then the return value would be "blank". Make sense? E |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using formula to calculate data source range | Charts and Charting in Excel | |||
| A formula in Data Range | Charts and Charting in Excel | |||
| Formula to sum data from a data range | Excel Discussion (Misc queries) | |||
| Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Threaded Mode
