Charley at Excel User is running a sale on the excel dashboard kits. It is too good to be true. You get the plug and play dashboard kits for half the regular price. Go here to avail this offer and read on, if you are not sure what the dashboard kit is.
For a long time now, I have been an advocate of Excel User’s dashboards. Charley is a pioneer when it comes to excel based dashboard reporting. He has popularized several techniques like using sumproduct formula, using camera tool etc. I have been such a fan boy of his work that I even interviewed him once on this blog [here].
Using excel dashboard kit, you can very easily make excel dashboards from your data. The dashboards are dynamic and linked to one source data file. You can apply multiple color schemes, format the dashboards easily and send the report to your boss all in no time.
Also, you can get an excel dashboard e-book which explains how to make dashboards.
For a limited time (that is from now to End of Dec 4th, 2009), Charley is offering 6 bonuses with the bundle. The bonuses include 3 hours of training and sample dashboards. All for 50% off original sale price.
I have been using the dashboard kit for a while now and find it very useful. I highly recommend this product to anyone in the reporting roles as the deal cant get any sweeter.
To get this limited time offer, go to ExcelUser’s Dashboards page.
Note: I get a small commission whenever you buy these dashboards. But I would have recommended them anyway because the deal is too good to be true and the product is truly outstanding.
PS: Free option to make excel dashboards – check it out for tons of tutorials, downloads and resources.
13 Responses to “Data Validation using an Unsorted column with Duplicate Entries as a Source List”
Pivot Table will involve manual intervention; hence I prefer to use the 'countif remove duplicate trick' along with 'text sorting formula trick; then using the offset with len to name the final range for validation.
if using the pivot table, set the sort to Ascending, so the list in the validation cell comes back alphabetically.
Hui: Brillant neat idea.
Vipul: I am intrigued by what you are saying. Please is it possible to show us how it can be done, because as u said Hui's method requires user intervention.
Thks to PHD and all
K
Table names dont work directly inside Data validation.
You will have to define a name and point it to the table name and then use the name inside validation
Eg MyClient : Refers to :=Table1[Client]
And then in the list validation say = MyClient
Kieranz,
Pls download the sample here http://cid-e98339d969073094.skydrive.live.com/self.aspx/.Public/data-validation-unsorted-list-example.xls
Off course there are many other ways of doing the same and integrating the formulae in multiple columns into one.
Pls refer to column FGHI in that file. Cell G4 is where my validation is.
Vipul:
Many thks, will study it latter.
Rgds
K
[...] to chandoo for the idea of getting unique list using Pivot tables. What we do is that create a pivot table [...]
@Vipul:
Thanks, that was awesome! 🙂
@Playercharlie Happy to hear that 🙂
Great contribution, Hui. Solved a problem of many years!
Thanks to you, A LOT
Hi Hui,
Greeting
hope you are doing well.
I'm interested to send you a private vba excel file which i need to show detail of pivot in new workbook instead of showing in same workbook as new sheet.
Please contact me on muhammed.ye@gmail.com
Best Regards