Hot answers tagged

1

No need for the [#Headers] argument or the = in the condition - =SUMIFS(Oranges[Quantity],Oranges[Produced In],"California",Oranges[Exported To],"British Columbia") I know it gets sort of confusing when working with [Tables].


1

Check for and delete any references to your database from the ODBC Data Sources Administrator control panel. I'm not sure if your source will be in the 32-bit or 64-bit settings. Depending on your database source you may only be able to delete it from the 32-bit or 64-bit control panels. To launch the 32-bit control panel right-click your start button, ...


1

Unfortunately there is no easy way for that. Best workaround I came up until now is to copy unique columns to a new sheet (I hope you have them) and enter comments there. Then use VLOOKUP to populate comments in the original sheet.



Only top voted, non community-wiki answers of a minimum length are eligible