• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hello .. Introduce yourself

Hi, my name is Abraham and I'm an excel-o-holic. I've been able to survive and thrive using this magical macro enabled messenger from God... or at least from MS. I live in So-Cal and can't imagine living anywhere else. Yes, it gets expensive, but being only 30 mins away from either a beach or mountain justifies the hard work required to live here. I hope to EXCEL my knowledge by joining this community filled with great folks alike!
 
Hello! I have just recently discovered Chandoo.org and am so incredibly grateful for it!! My last full training in Excel was in 1999 and so many things have changed. This site is helping me "update" on the fly - Excel has definitely grown! I look forward to being Awesome in Excel!
 
Hello Friends,

I need help, I am preparing one excel where I want to set One cell of each row for entering PAN Card Details. Condition is that cell should allow only PAN Original PAN numbers that is first 5alfabetsthen 4 numeric and last alfabet.

Can any one help me in this. It is very urgent for me.
 
Anil Takalikar said:
Hello Friends,

I need help, I am preparing one excel where I want to set One cell of each row for entering PAN Card Details. Condition is that cell should allow only PAN Original PAN numbers that is first 5alfabetsthen 4 numeric and last alfabet.

Can any one help me in this. It is very urgent for me.
Click to expand...

Anil,

This is a thread just for introducing yourself. You would do better to create a new thread and post your question there. Forum Rules: http://chandoo.org/forum/forums/new-users-please-start-here.14/
Post a thread: http://chandoo.org/forum/forums/ask-an-excel-question/create-thread
 
Greetings! I have been using Excel for 15 years and am constantly learning new things. I am looking forward to exploring this site further.
 
Hi, after your site came up a couple of times during searches for excel answers, I thought I'd join. Normally I'm a paranoid tin foil on the head "they're always watching" kinda guy who avoids giving out my email address as much as possible. Then, worn out, I concluded that there was no point fighting it any longer, and if I wanted to find out what the probes really were for I should take the tin foil off and welcome the universe in.
 
Hi I am Zak,

I work a lot with excel spread sheet and I always some how find myself in a lot of challenges with the data that I am using. I would like to be an excel geek, even though not my strenght hence the reason why I am here. I would also add that I will support and try and add value to this forum as much as I can.
 
Hi everyone,

Paul here, financial analyst and Excel geek.
I used to pride myself as knowledgeable in Excel - due to my academic background and work mainly - before coming to this Chandoo blog & forums, I have learnt so much here I finally decide to join the club, to learn some more and maybe provide some help to others myself.
 
Hi, i am just a beginner. I need to learn how to achive the following in excel work sheet.
When we put a unique number (id number) into a cell and "enter", immediately a message should come if the number has been already entered or not. Means a alert should come if the value is duplicate. How to make it possible? pls guide. (if this is not the right way to ask a question in this fourm then too guide me how to do that)
 
vincy said:
Hi, i am just a beginner. I need to learn how to achive the following in excel work sheet.
When we put a unique number (id number) into a cell and "enter", immediately a message should come if the number has been already entered or not. Means a alert should come if the value is duplicate. How to make it possible? pls guide. (if this is not the right way to ask a question in this fourm then too guide me how to do that)
Click to expand...

Hi Vincy, and welcome to the forum. As a new member, I'd suggest reading some of the guides here:
http://chandoo.org/forum/forums/new-users-please-start-here.14/
and then if you have a question, you can post it here:
http://chandoo.org/forum/forums/ask-an-excel-question/create-thread

For your specific question, you can accomplish this using Data Validation. Let's assume your cell is A2. Select the cell, and goto Data - Data Validation. Select "Custom" rule, and input this formula:
=COUNTIF(A:A,A2)<2
If you want a specific message to appear, before hitting "ok", go over to the error alert tab, and write out your message. Then, ok out, and you're all set!
 
Hello all,

I've been getting tips from Chandoo for a couple of years or so and think the website is fantastic.

I used to use Excel a lot and learnt some basic to intermediate VBA skills, then moved to a company using SAP Business Objects and kind of lost some of my VBA knowledge. Now I'm back in a 90% Excel based role (Finance Analyst) and seriously need to brush up on my VBA skills again so I'll be looking for some help from the ninjas!

Chandoo and the ninjas have been awesomising my work, now it's time for the next level!

Alexis
 
Luke M said:
Hi Vincy, and welcome to the forum. As a new member, I'd suggest reading some of the guides here:
http://chandoo.org/forum/forums/new-users-please-start-here.14/
and then if you have a question, you can post it here:
http://chandoo.org/forum/forums/ask-an-excel-question/create-thread

For your specific question, you can accomplish this using Data Validation. Let's assume your cell is A2. Select the cell, and goto Data - Data Validation. Select "Custom" rule, and input this formula:
=COUNTIF(A:A,A2)<2
If you want a specific message to appear, before hitting "ok", go over to the error alert tab, and write out your message. Then, ok out, and you're all set!
Click to expand...
Thank you Luke sir for your reply
Let me try. I hope i can select a whole coloum and put that formula so that when ever i put the "id number" in any cell of that colum it should prevent a duplicate.
 
vincy said:
Thank you Luke sir for your reply
Let me try. I hope i can select a whole coloum and put that formula so that when ever i put the "id number" in any cell of that colum it should prevent a duplicate.
Click to expand...
Sir i tried.I use excel2007.
I selected whole coloum A
I clicked on "data validation" and selected "custom" and put =COUNTIF(A:A,A2)<2 into the formula space.
I started putting the id numbers. our id numbers are a 10 digit number.
Unfortunately when i put one id number in one cell (a1), then went to next cell below(a2) put the same (duplicate)id number which i had put in a1 and went to a3 . I was expecting that excel will not allow that.
This is what i wanted. Pls tell me how to put only 10 digit between values also along with preventing duplicate.
 
When you selected the whole column, I'm guessing that cell A1 was active, not A2. You will need to adjust the formula to account for that. Selecting whole column, with A1 being the active cell, formula is:
=COUNTIF(A:A,A1)<2

If this doesn't solve the issue, I strongly suggest creating a thread as I suggested above. Not everyone checks this thread for problems/solutions.
 
Hi, All...
I am Gopal Veeranala working as a Head Master in a Government High School,
I have been using Excel for last couple of years for daily work at office, and learning VBA as I am working with Visual Basic since 2005 as hobby.

I just want to share what I know, and want to learn new things from experts in this forum,

thank you in advance.

Gv
 
Luke M said:
When you selected the whole column, I'm guessing that cell A1 was active, not A2. You will need to adjust the formula to account for that. Selecting whole column, with A1 being the active cell, formula is:
=COUNTIF(A:A,A1)<2

If this doesn't solve the issue, I strongly suggest creating a thread as I suggested above. Not everyone checks this thread for problems/solutions.
Click to expand...
Wow Luke sir, it is working. It prevents any repeat of previously entered nubers in the whole coloum A.
Really thanks. Can you teach me how to ristrict that number to an only 10 digit number. Because the id number i want to enter is consiting of 10 digits only. So it will prevent error if by mistake i enter more or less than 10 digits.
 
@vincy
Hi!
This forum is intended to hold member introductions only, so proceed as Luke M indicated and start a new topic under the proper forum: Ask an Excel Question.
Regards!
PS: Do not respond here, thanks.
 
Hi all...

I am Abhijeet Joshi, I work for an Asset Management Firm at India Pune...
I have been using excel from about 2-3 years from now...and still trying to survive with it...;)
It's been a pleasure to learn and discuss fabulous formulas and VBA here...;)
 
Hello,
My name is Bengt Eriksson. I work for the Swedish Parliament. Originally - back in the good old VMS-days - I was with the Computer department, but for quite some time now I have been working for the Information Department.
I do a lot of programming in VBA, primarily with Excel but also some with Word, and especially the coexistence between the two.
 
Hi,
My names's Malcolm and I am a fraud investigation data analyst from Scotland. I've joined this forum for ideas and suggestions to some interesting excel based solutions I require which would help me identify potential fraud in a more time efficient way. I would also like to help others with their excel queries.
 
Hello - My name is Kurhajetz. I took an Excel class at business school, then I didn't use much of its capability at work for several years. I did, however, begin to use it as a way of tracking multiple types of data for the various sports leagues and fantasy sports leagues in which I participate. Creating engines for data in fantasy leagues has been an especially fun project for me to work on, and has really pushed me to add a lot of new Excel tricks to my toolbox. A lot of times that I've run into thorny challenges, I've found clear and workable solutions here on Chandoo, so I thought I would finally get a login and add questions and suggest some solutions here on the forums. Thanks for all the guidance you've already provided me, and I look forward to interacting with you all going forward! Best regards, - Kurhajetz!
 
Hi,

my name is manasi halde, basically from Mumbai, India however now settled in Dubai, UAE for good. I had never thought i will need to use excel so much being an HR professional. i want to learn MACROS.
 
Hi there,

My name is Pam and I work in a small company in sales and marketing in Vermont. What we really need is shortcuts and data. We spend a lot of time doing very manual types of jobs to provide customers with information.
I love Excel, but am probably a rudimentary user by the standards here - but I am a willing and eager student!
 
You must log in or register to reply here.
Back
Top