Re: $$Excel-Macros$$ Excel formula for Calculatin​g distinct events by ID

2011-07-17 Thread dcolardelle
Have a look at the attached workbook. Daniel - Mail Original - De: "RockyFontane" À: "MS EXCEL AND VBA MACROS" Envoyé: Samedi 16 Juillet 2011 18h06:05 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne Objet: $$Excel-Macros$$ Excel formula for C

$$Excel-Macros$$ Excel formula for Calculatin​g distinct events by ID

2011-07-16 Thread RockyFontane
I have a table where I maintain a log of every contact event I make with my customers. In a Pivot table, I'm trying to return and calculate the first contact event made by unique ID. When I pivot by ID and dump in "Log Contact", it sums up all the contacts. If I use the Max function, then it doe