Search results

Hi. Can anyone assist please? I have a column full of names (call it Column A), many of which are duplicated many times over. Can anyone come up with a formula that I can place in the column alongside (Column B), which will a) search Column A for any duplicate entries that match the name in...

In the immortal words of Rhett Butler: "Frankly my dear, I don't give a damn!" I always thought that the wolf got a bum rap in Little Red Riding Hood anyway!

Luke M, that approach is so simple and elegant, yet so effective! It solves my issue perfectly!! One day when I'm big, I also want to learn how to look beyond the trees and see the whole forest, so to speak!

Thanks Narayan. I'll give your formula a try, but maybe for now I should just apply the KISS approach and just remove the fields altogether. I will lose some functionality, but nothing that I can't live without. By the way, are you still chasing up leads on my other Cape Town Cricket Club...

Hi. Shrivallabha was kind enough to help me in my previous post "Need a COUNT formula with multiple AND and OR criteria" with solving my issue to develop a formula that counts the number of records in a table that simultaneously complies with multiple compulsory and optional criteria. To...

Thanks bobhc. That's probably wise. Will do.

Can I please tack on an extra issue here? As I have my Marketers in a data validation-obtained dropdown list in cells D2 and E2 explained above, is there a formula-based way to tweak this so that if I want to see the data for all Marketers, rather than for one or two specifically selected from...

Thanks guys. You are all awesome. This is definitely the best site I've come across for obtaining Excel assistance (and certainly the quickest too!)

Thanks Shrivallabha. That seems to work a treat!! I've never seen two minus signs/dashes together like that in a formula before, but it certainly seems to do the trick whatever it means! Much obliged, indeed.

Thanks guys. That half-works, in as far as the first running of the formula produces correct results. However, then subsequently changing the marketers doesn't change the formula result thereafter. Perhaps I should've added that for my Marketers, I have a dropdown data verification list on...

Hi. I need a formula that will count the number of records in a table that simultaneously complies with two different compulsory as well as either one of two optional criteria. In other words, it must count the number of records in which the Product ="Endowment" AND the Branch ="Cape Town"...

Totally awesome, Hui!! Works like an absolute dream! Gee, I love this forum!!

Hi all. I can't upload a sample file, so hopefully the following explanation will suffice for a solution to be forthcoming from someone here. I have a spreadsheet where row 33 contains month-by-month totals for 2011 (cells B33: M33 for Jan to Feb), while cells B34:M34 do the same in row 34...

Hi Narayan. There still appear to be issues with the HS1 and HS2 career stats for the batting, and the BBI, BBM and 10wM stats with the bowling, as these are team-dependent for players who have appeared both for and against Cape Town. See the dropbox link for the updated Sample 5 workbook...

Hi. Will send an email to your address that you can reply to. Thanks.

Hi guys. Just checking in after having left this on the backburner for a while. Any progress with the wishlist yet? Thanks!

Thanks Narayan - don't tempt me to be more ambitious in my wishes (especially as they impact directly on your time), as the sample file that I uploaded is only part of the full workwook that I am using (I removed some of the other tabs that involve team and individual partnerships, etc.) To...

Hi Narayan. Long story short, this is what I would ideally like (all centering around the Career Stats worksheet): 1.) The bowler name displayed in J1 is currently derived from the Report Filter dropdown list on the BB Figures worksheet. I would like to remove this field altogether, so that...

Here is the link now: https://www.dropbox.com/s/9zvkh199x4z5srf/Sample%204.xlsm A slight correction to what I said earlier as well: the pivot table Report Filter on the BB Figures Pivot worksheet is not used to get the selected player's full bowling career stats, but only his "BB M" and...

I have complete faith in you guys! Keep an eye out for the dropbox link to the file, maybe around 19h00 or so (UTC+02:00). Thanks!

Narayan, I am basically looking for an elegant and highly effective solution that brings a smile to my face whenever I use it and a thrill of excitement to see it work perfectly! If that requires VBA in addition to formulas, then I am fully 100% onboard with that approach. Just bear in mind...

No problem. Unfortunately I cannot upload the revised sample workbook from the office, so I'll do it tonight when I get home. Thanks guys.

Hi Narayan. Thanks for your response. I actually felt very inspired yesterday by your and Kaushik's efforts in helping me with the career summary formulas, and ended up redesigning and radically extending the information that it contains. I must therefore upload the new version for you guys...

Trust me when I say this, Kaushik, the pleasure (and the benefits) were all mine!! Are you signing off on this post now? I hope not!

Thanks Kaushik - I think our last posts crossed in cyberspace! I have yet to learn the whole macro thing with Excel, and so will look at your example with great interest. Hopefully I can learn a lot from them! I did find that Narayan's formulas worked beautifully as well though, so I'm not...