Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to create excel sheet of inventory list. I have a given list of items (laptop, monitor, keyboard, etc..) and a group of people.
I saw it is called data validation.
my question is how can i sum the number of monitors the organization has, and how can i sort the items of a certain person.

thanks

share|improve this question
    
This is where spreadsheets stop and databases should begin. If your expecting any kind of growth you'll need a database version sooner rather than later. There are templates like: office.microsoft.com/en-gb/templates/… to help you get started. –  cjb110 Feb 12 '13 at 8:09

1 Answer 1

up vote 1 down vote accepted

A very simple example would be a simple table with your staff on the left one on top of the other and the items on the top. For each member of staff that has a specific item put the number of items they have in the applicable cell. The use SUM() to calculate the total number of each item...

enter image description here

Here item 1 could be the number of laptops each person has, person 3 having 2. Item 2 could be the number of monitors each person has and item 3 the number of mouse's each person has.

You can replace the blank cells with a 0 without it changing the results.

share|improve this answer
    
I guess all his items are in a single column but without a sample file its hard to tell. –  nixda Feb 12 '13 at 9:27
    
His first line indicates that he has only the raw information atm ("I need to create...") so my guess was that he could just set up a spread sheet like my example above and enter the info as read from his raw material. But as you said, without more information there is no way to know. –  Kevin Anthony Oppegaard Rose Feb 13 '13 at 9:00

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.