| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
occurance, pivot
Hi,
I have a data as per below Customer Invoice Charge Type Adidas 851245 Basic Adidas 851245 documentation Adidas 851245 transportation Adidas 851244 Basic Adidas 851244 documentation Adidas 851244 transportation Nike 851243 Basic Nike 851243 documentation Nike 851243 transportation Nike 851242 Basic Nike 851242 documentation Nike 851242 transportation When i did pivot table i get below result, Customer (count of) Invoice Adidas 6 Nike 6 Please is there any way to get a pivot analysis as per below, Customer Invoice Adidas 2 Nike 2 -- Sincerely Yours Haviv |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find next occurance | Excel Discussion (Misc queries) | |||
| Occurance Counting | Excel Worksheet Functions | |||
| Occurance Number Within a String | Excel Discussion (Misc queries) | |||
| Need Formula for Last Occurance | Excel Worksheet Functions | |||
| frequency for each occurance | Excel Worksheet Functions | |||
Threaded Mode
