Using $ to hold column when dragging using a datasource

**djfatboyfats** · 04-14-2016, 05:50 AM

Good morning,

When I create a formula and want to hold the range I just put $ signs around the range to hold it however I'm unable to do this if I'm using a data range, how do you hold the data range column for dragging?

Example I want to hold the column

Table_Query_from_csolve[FullName]

from the code below but I'm unable to do so which means when I drag the formula across it gives me the next column in the data source table instead of Fullname which is what I need.

=IF($Z$2>=1,SUMPRODUCT((Table_Query_from_csolve[FullName]=Production!A23)*(Table_Query_from_csolve[MonthNum]=$B$5)*(Table_Query_from_csolve[Count])),"")

Thanks in advance

DJ

**TMS** · 04-14-2016, 06:09 AM

Assuming that you're talking about a Structured Table, you'd need to do something like:

Formula:

... Table_Query_from_csolve[[MonthNum]:[MonthNum]]=$B$5 ...

**TMS** · 04-14-2016, 07:10 AM

Marked Solved?

Excuse me. Is that it? You ask a question, it gets answered, you mark it solved and wave goodbye? No feedback, no comment, no thank you, no KMA?

Registered around 10 years, with 400 posts, you should know better.

Using $ to hold column when dragging using a datasource

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Using $ to hold column when dragging using a datasource

Re: Using $ to hold column when dragging using a datasource

Re: Using $ to hold column when dragging using a datasource

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dragging 2 column formula across

[SOLVED] how to use a macro to print column A cells that hold a value more than (0)

Change the Column When Dragging

Pivot - (Sum Column 1) % Of (sum Column 2) Results in N/A -MSSQL Datasource.

Dragging values from a column to a row

To hold or not hold CTRL down

Can INDIRECT hold only the column value constant?

Bookmarks

Bookmarks

Posting Permissions