Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to know information on two things.
i. Is there a tutorial sort of thing on the internet to learn excel programming from scratch. I would like to see a user guide on how to as well as some sample exercises to work on. ii. I have a file that comes in a format as below : Date Product Name Price Category 1/1/04 A1 100.00 High End 2/1/04 A1 105.00 High End 3/1/04 A1 135.00 High End 4/1/04 A1 175.00 High End 5/1/04 A1 205.00 High End 6/1/04 A1 215.00 High End 1/1/04 B1 100.00 High End 2/1/04 B1 105.00 High End 3/1/04 B1 135.00 High End There are other products and other categories. I would like to get something of the following format : Date Product Name Price Category Percentage change 1/1/04 A1 100.00 High End Not applicable 2/1/04 A1 105.00 High End =(New minus Old prices ) / price Can someone help with the percentage changes ? Thanks Srikanth Vee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A few things | Excel Worksheet Functions | |||
how to do these things in Excel with and without VBA? | Excel Discussion (Misc queries) | |||
######THEY DO DIFFERENT THINGS TO GET IT############# | Charts and Charting in Excel | |||
Counting Various Things | Excel Worksheet Functions | |||
2 things | Excel Programming |