Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I get no results from a Google search on this message searched as a phrase,
yet that is word-for-word what Excel is telling me. Seems simple: I have two worksheets containing tables, "Goal 1" and "Master List". In Goal 1:B9, data are entered manually. In Master List:B9, the formula is simply "='Goal 1'!B9." Yet when I click on Master List:B9, an exclamation mark appears to the left, and when I hover over it, it says "This cell is inconsistent with the column formula." Is this something unique about references to tables (I've not worked with tables before)? Thanks, ~N |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ouch! Inconsistent TEXT("hh:mm") rounding | Excel Worksheet Functions | |||
Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
VBA setting formula for a cell causes "Wrong data type" error | Excel Discussion (Misc queries) |