| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to Don: display last entry to cell automatically
Me???
<vbg "T. Valko" wrote: The list separator wouldn't cause a #NAME? error. You'd get the general formula error: The formula you typed contains an error. -- Biff Microsoft Excel MVP "Dave Peterson" wrote in message ... I think it's more common for the list separator to be a semicolon (;) then a dot. Although, there are differences between decimal and thousands separators, too. Shane Devenshire wrote: Hi, Also, in some language settings "," is replaced by "." -- If this helps, please click the Yes button Cheers, Shane Devenshire "mike CBA" wrote: the formula =lookup(999999,b:b) resulted in #NAME? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display last entry into a cell automatically | Excel Worksheet Functions | |||
| automatically prefix cell entry with leading zeros | Excel Worksheet Functions | |||
| Automatically prefix cell entry | Excel Worksheet Functions | |||
| automatically add borders to a cell after entry is complete | Excel Discussion (Misc queries) | |||
| How do i have a check display with any data entry in a cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
