| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet That Works Like Pivot
Hi Guys!
I need your help again. For example, I have the following data: Category Description Beverage Coke Beverage Pepsi Beverage Mirinda Beverage Root Beer Main Spaghetti Main Hamburger Main Salad Main Fries What formula should I use to print this in worksheet that looks lik this? Column1------Column2 Beverage-----Coke -----------------Pepsi -----------------Mirinda -----------------Root Beer Main-----------Spaghetti -----------------Hamburger -----------------Salad -----------------Fries Thanks -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet That Works Like Pivot
arjcvg,
No formulas - you should use a pivot table.... HTH, Bernie MS Excel MVP "arjcvg " wrote in message ... Hi Guys! I need your help again. For example, I have the following data: Category Description Beverage Coke Beverage Pepsi Beverage Mirinda Beverage Root Beer Main Spaghetti Main Hamburger Main Salad Main Fries What formula should I use to print this in worksheet that looks like this? Column1------Column2 Beverage-----Coke -----------------Pepsi -----------------Mirinda -----------------Root Beer Main-----------Spaghetti -----------------Hamburger -----------------Salad -----------------Fries Thanks! --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Chart no longer works with Office:MAC 2008 | Charts and Charting in Excel | |||
| Is there a way to save header that repeats from worksheet to works | Excel Worksheet Functions | |||
| Formula works on all but one worksheet | Excel Worksheet Functions | |||
| sort macro that works after leaving worksheet | Excel Discussion (Misc queries) | |||
| Worksheet function in excel only works once | Excel Worksheet Functions | |||
![arjcvg[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
