How to add a column header to the dynamic table?

Setting a column based on 2 columns

• QUESTION: Hi Ken, I want Column C to be set to either column A or B, this is the criteria - If colA contains/find the string "Internet" anywehere in it, then set Column C to colA, else, if colb in not Null, then column C=Colb, else Colc=ColA. Both columns represents a key.. colA, the old key, colB the new key, so when colb is populated, and colA doesn't contain "internet", then column C with be set to B. I hope this is clear. Thanks,Monte ANSWER: Monte This may not be exactly what you are looking for, but, something similar to the logic in the following formula should get you where you want to go =IF(NOT(ISERROR(FIND("internet",A1))),A1,B1) Good luck. ---------- FOLLOW-UP ---------- QUESTION: Ken, I have a pivot table in which the rows might be interchanged, but I have two data columns, 1 shows the #of Leads, 2 shows the #of Sales, i want to calculate a 3rd column which is #of sales/# of leads and have it be dynamic so if I interchange rows it recomputes..I had no luck when trying to use formulas and when I hard code it in the cell, it is not dynamic, meaning I switch out a row or filter and it stays the same. Please help! ANSWER: Monte Is the 3rd column (sales/leads) part of the pivot table source data or is it just to the right of the pivot table, but not actually part of the pivot table? If it is the later option, you will find it to be problematic. If it is part of the source data it seems like it should work okay. Alternatively, it seems like a good candidate for a calculated pivot table field; where it doesn't have to be part of the data, but, can be created as part of the pt. what version ofare you using? ---------- FOLLOW-UP ---------- QUESTION: I wound up getting the calculation to work amazing, in part based on your input!.. Two question, 1. Is there anything special you need to do to add a header onto a Pivot Table? 2.Also when filtering on a date range, sometimes it allows me to choose a to and from range - I like that, in other cases, I need to check a box for each date I want included... I prefer to do the former, how do I access the range option on those cases?

• Answer:

  Monte The header and footer on a sheet with a pivot table should work exactly the same as a regular sheet. I believe you will have the option of to/from range selection if all the row variables are interpreted byas dates. Take a look at them to see if there is possibly a row or more that are not interpreted as dates; once you fix those, you should have the to/from option. Good luck.