Badly Need Help
Closed
Senaka
-
Nov 12, 2009 at 10:57 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 16, 2009 at 03:24 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 16, 2009 at 03:24 PM
1 response
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Nov 15, 2009 at 02:28 PM
Nov 15, 2009 at 02:28 PM
sorry, confused as to what you want to do
please explain better
please explain better
Nov 16, 2009 at 11:06 AM
I Need To Know ...
In sheet No 1 we have the following Data
CARS TOYOTA BLACK USD 10.00
CARS NISSAN BLUE USD 20.00
VANS NISSAN WHITE USD 10.00
CARS TOYOTA BLACK EUR 15.00
in Sheet 2
TOYOTA TOYOTA NISSAN NISSAN
BLACK BLACK WHITE BLUE
USD EUR USD USD
CARS
VANS
I NEED TO GET THE TOTOALS OF EACH HOW CAN I
Nov 16, 2009 at 03:24 PM
one option would be as follows
if you select all the dat on sheet 2
then create a pivot table, it will create a table so that you can get totals etc.
if you need further assistance please state which version of excel you are using.