Search results

Sorry, but in any case I think I need to rethink my approach on this one. I was thus a little premature in reactivating this post. I'm going to park this issue for the time being. Thanks.

It's now two months later, but here is the sample file at long last! Thanks!

Hi. I need some help with the attached extract from an Excel database please: https://dl.dropboxusercontent.com/u/92056659/Database.xlsm This is part of a much larger database tracking club cricket player performances. What I specifically need is a way for the "Indiv Fielding Pivot Table"...

Thanks Faseeh (sorry, I didn't notice your first post above). Your above formula works perfectly within the source data, but doesn't translate into the pivot table. I've dragged that new helper column into the pivot table (into the Values quadrant) and set its Field Settings to the MAX option...

Okay, I'm clearly getting ahead of myself again! My difficulty is that I want the result of this proposed formula to appear in a pivot table, which immediately restricts my options in what I can request (seeing as how a pivot table doesn't accept formulae). Anyway, what I want is that if the...

Thanks NARAYANK991. The second formula works a treat. However, the conditional formatting part doesn't. Does conditional formatting offer the ability to add text (concatenate) to a number too, or can it only be used for cell format-type things such as colour and font? Thanks.

Hi. I have a column of numbers, some of which are whole numbers and others of which have one decimal place. Is there a formula that I can apply to the entire column that will differentiate between the two number types, and then work differently with each type (I am thinking formula-based...

Hi SirJB7. Column C contains only a range of sequential numbers for identification purposes, i.e. "1", "2", "3", etc. Currently it has reached all the way up to "262" in the full workbook. Does that help any? If not, hopefully I'll have my own PC back by tonight, and I can upload a...

Wasn't aware of that - it's only 16h20 over here. Sorry for keeping you up! Tomorrow morning - or even Monday - is perfectly fine by me. As I said, I won't be able to access the web again until then anyway. Have a great weekend, and thanks again! Will check back on Monday.

Won't be able to do it until next week unfortunately, as I can't upload from my work PC and my home one is in for repairs at present.

That's pretty much accurate, although the formula should not produce any blanks. The data in Column F will always be valid, and can only be one of three different options: "Criterion 1", "Criterion 2" or Criterion 3". There are many, many different names in Column H, with many, many...

Hi. Sorry, I see I got a bit confused in my column naming. There are only three Column F criteria, plus the names in Column H plus the additional new criterion in Column C (not Column F as stated in my last post). So essentially, what the formula should do is to output "text 1" in Column I...

Would I really be pushing my luck if I asked for a further adaptation of the formula??! I have realised that, handy as this formula is to me, it is still not quite going to help me to the extent that I require in subsequent filtering and pivot table analyses. Can this formula therefore...

I appreciate the effort, thanks, but am more than happy with yours! I will compare that one to mine though, and see where I went wrong. Much obliged.

Okay, I get it - I think. It's just strange to me that it did that for some names (consistently) and not for others. I suppose that if I really applied my mind to it I could work out what was different about those particular names, but it seems scant worth the effort considering that I do now...

Awesome! That worked a charm, thanks. Any idea what the problem was with my initial nested multiple IF formula?

Okay, I see that the "1" , "2" and "3" are position indicators that come from the MATCH formula used. So what I would then ideally like is to replace that output with specified text instead. Not essential, but it would be nice!

Just another quick question though - where in your formula are the output results hidden, i.e. if I wanted to change the output to something more meaningful than "yes1", where would I tweak that? Thanks.

Wow!! I have no idea what you did in that formula, but that seems to have solved the issue with those problem names! I must sit down and analyse it. I always have such mixed emotions when posting in this forum - on the one hand I'm ecstatic about all of the excellent help that I get, but on...

That produces the output "TRUE" in every row. Do the curly brackets mean that I must enter it as an array formula?

Actually, on closer inspection it's not perfect. In the vast majority of cases it has produced the correct "yes" outcome, but for certain names for some reason or other the formula has generated an incorrect "yes" number. There's no reason for it that I can see, as the Column F entry is the...

Okay. Playing around I've eventually managed to figure it out. This formula seems to have worked: =IF(COUNTIFS($H$2:H2,H2,$F$2:F2,"=Criterion One")=1,"yes 1",IF(COUNTIFS($H$2:H2,H2,$F$2:F2,"=Criterion 2")=1,"yes 2",IF(COUNTIFS($H$2:H2,H2,$F$2:F2,"=Criterion 3")=1,"yes 3","-"))) Couldn't...

I'm tying myself up in knots here! In more practical terms, what I'm trying to do is the following: I have my list of names in Column H and the additional criterion to be matched to each name in Column F. There are three different criterion options in Column F, such that the same name in...

Sorry, another issue has popped up that I didn't originally anticipate. How would I adapt that formula if I wanted to include another criterion into the outcome? For example, I want the "yes" in Column B for the first instance of a name in Column A, but only when there is also a certain entry...

Awesome! Worked a treat. Thanks so much!!