Search results

wow Somendra Misra... you are definately an Excel Ninja! absolutely fantastic thanks!

Hi both, thanks for the response. Attached is a small file with 2 tabs... 1 = data, 2 = pivot. the reason I cann put the formula into the data tab is because I need to sum up to total deals for each client (unless there is a way?). The pivot table does a lovely job of summarising, but I want...

Hello, I'm wanting to insert an existing formula into a pivot to help me with changing data... but how? I'm classifying customers and it is based on the "Count" of products they have bought over the passed years. How do I apply the cell references to the calculated pivot table fields? eg...

Greetings from Planet George... apologies for being offline, I suffer a little from hayfever, and as summer has finally arrived in England, so to has the pollen! Bu I shall not complain! I've looked at Ianamck's new formaula as all I can say they you folks are truely AWESOME Ninja's. Thank...

Hello SirJB7 & Ianamck, Wonderful thanks for your responses (and SirJB7, I will definately search around the forum site for topics!) I've looked at the formula and it works, however, it is not showing the correct "week number" for the dates before 06 April (when my week number sequence...

Hi All, I'm a newbie to all this, so forgive the inexperience! I'm wanting to identify the week number of a date, but I want to start the week number count from 6th April to 5th April the following year. The week number would commence on a Monday (day = 2)... Help! Any clues?