Excel - Create item list from table values

0 votes

I have a table of tools that are currently on our construction sites with how many of each tool is on each site which looks something like this:

Item Table

I'm trying to create a formula that will list the tools that are on the site and skip those that aren't with the quantity listed next to the tool. I tried creating a drop down list of the top row that will determine which column the formula looks down - seemed simple enough on paper but I'm struggling to put it into practice.

Any advice is appreciated. Thanks

Apr 6 in Database by Edureka
• 13,640 points
30 views

1 answer to this question.

0 votes

What is Data Validation, and how does it work?
The data validation tool in Microsoft Excel allows you to limit what can be entered in your worksheet. You can, for example:

restrict entries, such as a date range or entire integers, by creating a drop down list of objects in a cell Make specific rules for what can be entered exclusively.

list of options for drop down

What Is a Drop Down List and How Do I Make One?
You can build a dropdown list of options in a cell using Data Validation. There are three simple steps to follow:

1. Make a table of contents OR a list

2. Give the List a Name

3. Make the drop-down menu

Data validation is not without flaws. It can be avoided by pasting data into the cell or using the Ribbon's Home tab's Clear > Clear All option.

list of options for drop down

list of options for drop down

list of options for drop down

answered Apr 11 by gaurav
• 13,460 points

Related Questions In Database

0 votes
1 answer

What is the best way to fetch data from table?

Hey Shraddha, I understand your doubts about fetching ...READ MORE

answered May 25, 2019 in Database by sampriti
• 1,120 points
966 views
0 votes
1 answer

How will I get all the rows from my table where name starts with 's' and ending with 'I'?

Hi Santanu, I understand your problem, You can try ...READ MORE

answered May 28, 2019 in Database by sampriti
• 1,120 points
512 views
0 votes
1 answer

Query to list number of records in each table in a database

Use the below code to list number of ...READ MORE

answered Oct 11, 2019 in Database by Omaiz
• 560 points
648 views
0 votes
0 answers

how to create a SQL table?

Feb 1 in Database by Neha
• 8,560 points
22 views
0 votes
1 answer
0 votes
1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

answered Mar 15 in Database by gaurav
• 13,460 points
88 views
0 votes
1 answer

Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

answered Mar 15 in Database by gaurav
• 13,460 points
43 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23 in Database by gaurav
• 13,460 points
46 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP