Get instant live expert help on I need help with using excel as a database
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I am having a problem with an excel database and calling data from an array using VLOOKUP.
Solved by D. D. in 25 mins
Help creating inventory and database using formula
Solved by O. J. in 25 mins
I do not have an Excel spreadsheet database for my customers. The information is however listed in individual Excel spreasheets for each customer individually. Is there any way to extract this information and drop it into one Excel spreadsheet that I can use as a database? Thanks, Bridget
Solved by D. B. in 30 mins
I would like to have a calculation-template with a database and the actual calculation in Excel. I have made an example of 20 lines database in Excel.
- In the database I can fill in the product, a remark, a unit, a price, a manufacturer and a reference.
- In the calculation, by using 3 multiple drop-down lists (a category-list, a sub-category-list and a product-list) I can easily look up hundreds off products, when I click on these the remark, unit and price automatically fils in.
- I can add lines in the database and the drop-down lists update automatically
- In the database, there is a button to show the list by manufacturer
Solved by F. D. in 22 mins
How do I delete duplicates in an SQL database using an SQL query?
Solved by K. H. in 28 mins