@Sinu
Welcome to Chandoo.org, Glad You Are Here
Please check this link
http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/
and
http://www.contextures.com/xlDataVal14.html
Hope It solves your problem, if any problem please come back
Thanks
@Asheesh
Welcome to Chandoo.org Forum, Glad You Are here
please refer the Below links may be it will give some idea
http://www.pcreview.co.uk/forums/powerpoint-chart-preview-vba-userform-t3463215.html
and
http://www.vbaexpress.com/kb/getarticle.php?kb_id=756
Thanks
Please don't cross post here it is like a spam
http://chandoo.org/forum/threads/if-statement-for-dates.18088/
Already Luke M replied and he request something from your so try to replay there and sure you will get the result for your querry
Ninja's kindly lock this for thread for further...
Kumar@raja
Please Try this formula with Array - Ctrl + Shift + Enter
=SUMPRODUCT(MAX((Amount)*(Date="05-06-2014")))
Amount is column B and Date is Column A
Hope it solve your problem
Thanks
@paramnayak
i am not sure what you think, if the cell is blank then the "-" symbol to be appear if cell is not blank then what?
the result may be like this
=If(A4="","-","")
Then you will get the "-" if the a4 is blank
Thanks
SP
@jitesh54
Welcome to chandoo.org forum, glad you are here
as per my guess is correct, you can use the Conditional format for highlight the duplicate data in particular Columns
Please Follow the steps
1. Select the data
2. Select the Conditional Format in Home Tab under Style
3. Select...
@rdmqpr
why not you try the advance filter option, please download the file and check if any problem please inform
i have created a new tab named with Shop Data there i have mention as per your requirement
Thanks
SP
@Puttaswamy
Welcome to Chandoo.org Forum, Glad you are here
Another method you can use the Offset Function
Say your data in A1:A100 and you want to reflect the same value in another columns then
just type in B1 = OFFSET(A1,0,0) now copy the formula and paste in your required columns from Ex...
@Anamika
Please have a look
http://answers.microsoft.com/en-us/office/forum/office_2007-excel/allow-multiple-users-to-access-and-fill-in-the/aba97e43-f2b0-47d6-84d6-10a948c4311a
ND...
@Izu
Welcome to the forum, glad you are here
Please download the file again and Press the Alt + F11 there you will find a UserForm1 press the F5 button then
change the text from the Combo List and see what happen. if any issue please come back again with full details actually what do you...
@Subageethan
Sorry for my late replay just i was out way from this Forum for long time so i didn't check any posts here, i think your problem may solve if not then please re-post with new question
@KapooK
Can you elaborate us what do you mean may be some body help with your problem or me...
@Somendra Misra
The Drop Down list is showing only for Text in the particular Columns and not for Dates and Amount too
Thanks for your feedback
Regards
SP