Forum

May I ask what you would consider a "good visual"? It seems you are looking at market information by state over time. Adding all of these in one graph...

If I may, perhaps the attached file does what you ask for. A formula solution that mimics the Pivot Table. I've shaded the area green where you had t...

Please try again. The file did not come through. Don't forget to press "Start upload", wait until it's done. Then submit your reply.

Go through the steps on-by-one from the Source and down. At some point the error will show up. Then look at the table in the previous step to see if t...

Glad it worked for you. And correct on both assumptions.

Hi, First of all, you can't add a textual value like "Budget Overrun" in the value area of a regular pivot table. That would require Power Pivot an...

Played around with the chart a bit, but am not sure if it even comes close to what you want. To put the biggest bubble first, I reversed the order...

First make sure that the Names column in the Name sheet are texts. Then, in B2 enter this: =INDEX(Table1[Full Names],MATCH(TRUE,ISNUMBER(SEARCH([@N...

Please thy attaching the file again. This time, don't forget to press "Start Upload" before you submit your reply.

Hi Wayne, That could be like this: =C11*($D$9+ISNUMBER(FIND("PGS",B11))*1.5%) I have attached a workbook with a working example so that you c...

Please try to attach the file again. This time, press "Start upload" before you submit your reply.

The file you intended to attach didn't come through. Please try again and don't forget to press "Start upload" before you submit your reply.

Hi Derek, The file didn't attach. Please try again. This time don't forget to press "Start upload" before you submit your reply. Riny

You didn't attach a file. Please try again and press "Start upload" before submitting your reply.

You didn't attach a file. Please try again and press "Start upload" before submitting your reply.