I am trying to build a database for my customers, where I can sort by very detailed info. I might have a customer (name - contact - address) all identical, entered 20 times, with one column (product) different in each row.
I need to be able to sort the database by product - so as far as I can...
Hi all:
I need some help here. First time poster.. I need help with my dropdown lists, returning multiple values attached to each entry. If I fill down my formulas it only returns one value; not the list attached. Please PM me if you know an easy fix. Thanks ! :confused:
Hello, this is my first post so please inform me if I am doing anything wrong or there something I can clarify.
I am working on a project and have ran into an problem with separating lines of data. So let me first show what I am doing because I wont want to take an unnecessary block of your...
in a simple example I want to convert a table like:
SKU DESC Jan-12 Feb-12 Mar-12
123 prod1 10 42 34
345 prod2 90 10 39
Into database format like below, so that I can do data analysis with pivot table.
SKU DESC MONTH QTY
123 prod1...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.