Appointment Schedule

[EXCELNEIL]

Require help on getting some formulas entered to my appointment file. how can i attached the file for someone to help me putting formulas in.

 

[EXCELNEIL]

Can you display more information as it doesn't seem clear, as I gave you a solution.

You can copy part of the table and paste into your thread.

Its a table with many times. I need to count the total of each item and appear separately in a sheet automaticaly with the name of that particular item and the total quanty in next column. Can you help me to find a formula for that.

 

[EXCELNEIL]

Item wise calculation

Its a table with many times. I need to count the total of each item and appear separately in a sheet automaticaly with the name of that particular item and the total quanty in next column. Can you help me to find a formula for that.

A table with many items to be counted and display automatically with the particular item and total quantity. Pls help <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Trevor G]

Try using a Pivot Table

 

[EXCELNEIL]

Try using a Pivot Table

I have no idea of using pivot table. can you please guide me with an example.

 

[Trevor G]

Look at YouTube plent of examples

http://www.youtube.com/watch?v=7zHLnUCtfUk

 

[EXCELNEIL]

Vlookup

I have an excel file with 4 sheets with unique names. I need to use the vlookup formula but it dosent work properly.

Can I Send my file to any of you to check and help?

 

[Trevor G]

Send me a private message with an email address in it.