LinkBack URL
About LinkBacks
Hi Team,
I have a data and trying to Count of the Vehicles for all the Drivers whose Name starts with ‘R’.
Anyhelp will be appriciated
Thanks
Anir
Hi Team,
I have a data and trying to Count of the Vehicles for all the Drivers whose Name starts with ‘R’.
Anyhelp will be appriciated
Thanks
Anir
See attached, I added column H (you can hide) and formula Count.if at the bottom of column C
If solved remember to mark Thread as solved
Hello anir_sarkar1,
Do you mean something like this?
Also see the "Please consider" note at the bottom of this post.
Last edited by Winon; 12-31-2012 at 05:58 AM. Reason: Used wrong formula
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Maybe.
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi anir
Please try below code and let know if that works for you.
Please Login or Register to view this content.
Hope this helps.
Kiran
Just to explain that my "code" is a record of a simple formula.
=COUNTIF(C2:C100,"R*")
Agree with you Fotis
Try this where J2 contains the leading letter you want to count.
Formula:
Please Login or Register to view this content.
[EDIT]
Good point Fotis, I've got SUMPRODUCT on the brain just now!
Use this in this example workbook
Formula:Please Login or Register to view this content.
Last edited by Marcol; 12-31-2012 at 06:34 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
@ Fotis,
Nice one.
I have used it without code as per the attached revised WorkBook.
@ Marcol. @ Winon.
Thanks quys.
Happy New Year for you and your Families.
Edit: @ Kiran.Sunkara
Apologize. I haven;t see your post. Thank you too!
Last edited by Fotis1991; 12-31-2012 at 07:19 AM. Reason: Edit.
Happy New Year to all!
Hoping for a enriching, challenging and good learning experience/journey in 2013.
Happy New Year to everyone and their Families.
hi friendsOriginally Posted by Winon
thanks 4 ur help
I had a death in family so couldn't get time.I'll check all your sugestions once i'll reach home and will get back to you
happy new year again
thanks
Hello anir_sarkar1,
My sincerest condolences with the loss to you and your Family.
I have revised the Workbook to this.
Also see the "Please consider" note at the bottom of this post.
My sympathies also Anir.Hello anir_sarkar1,
My sincerest condolences with the loss to you and your Family.
I have revised the Workbook to this.
Also see the "Please consider" note at the bottom of this post.
@ Winon
If you want to work with whole columns, then you might want to consider using Dynamic Names.
See the Name Manager to see how.
This will simplify your formula, and work as the Table/list grows/shrinks.
Note the C/F for Column C.
Another option might be to create a list of unique Driver Names (see the formula in Column P)
Then use that, again as a dynamic name, for the data validation in 'Raw_Data (2)'!H2
@ Marcol,
Thank you Marcol, but I do know that stuff....you might want to consider using Dynamic Names.
See the Name Manager to see how.
The C/F for Column C is absolutely FANTASTIC!
The formula in Column P assumes no empty Rows between the Data in the Column.Another option might be to create a list of unique Driver Names (see the formula in Column P)
Then use that, again as a dynamic name, for the data validation in 'Raw_Data (2)'!H2
Yes, Named Ranges can simplify formulas, but then I would prefer to use it in conjuction with VBA.
Thank you for all your input, I really appreciate it.
This is how I have now updated the WorkBook, without Named Ranges.
Thanks All For your help and efforts :-)
Actually what I was looking for is something different
Lets see.. In the given file we have 2 Drivers whose name starts with the 'R'
So the output I was looking for is for both the Drivers
Ramesh = 17
Rohit = 12
Thanks
Anir
Okay try this workbook
Enter the first letter, or first few letters, of the drivers' name in cell $I$1
[EDIT]
Corrected error in dynamic name "Driver_Name"
Last edited by Marcol; 01-13-2013 at 10:26 AM. Reason: Improved workbook to allow initial multi-letter selection
Hello anir_sarkar1,
Don't you think Marcol has done a wonderfull job?
Now, if we step up the the WorkBook from .xls to .xlsm, we could have it as per the attached sample.
Also see the "Please consider" note at the bottom of this post.
Winon,
Just wondering - why would you save your excel files as macro-enabled files when they don't contain macros? Wouldn't xlsx be the correct format.
Hi crakter,
Yeah, good comment, you are right, .xlsx would do just as well.
The point I was trying to make is to use Excel > than 2003.
Hello anir_sarkar1,
Thank you for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks