Posts by Murtuza





Hi
I require to count unique entries in excel albeit on satisfying two criterias. My data is organised like this:
Col A Col B
A Jun
A July
A Aug
B Jun
B Jul
B Jul
C Jun
C Aug
Now I want a unique count of entries in column A that fall BOTH in June AND July. So in the above case value A comes in June and July therefore the count for A should be 1. Similarly B also falls in Jun and July so the count should be 1 for B as well. However C comes in June but not in July and hence the count for C should be 0. So the final answer should be 2 achieved as (1+1+0). I would like to extend this formulae to include more criterias. Request someone to kindly help. 
Re: searching for partially matching cells in the same column
Hi its been 4 days and no one has replied .I would request somone yo please help me out as I need this for a lot of work that I am currently doing.

Hi
I woild request someone to please help ne out once again in excel . What I am trying to achieve in excel by way of a formulae is to try and match cells in the same column which are partially same for a particular category mentioned in the corresponding cells.So lets assume I have 2 columns , col A and col B. Col A has categories such as 1, 2, 3and each categpry has 8 10 entries. Now I need to check the cells in col B for each of these categories for partial or exact match.So col B may have entries like this; cell B1 may contain terms like apple +banana+mango and B3 may contain entries like apple+grapes+oranges. Both these cells may pertain to the same category say category 1. In that case excel should give me true.Even if any one word matches it should give me true.Regards
Murtuza 
Re: match cells in excel with all characters same except one
Hi Robert this is fantastic thankyou so very much

Re: Return the value from the adjacent row for the nth occ
Works perfectly thaks

Hi Robert Thanks once again for your courteous reply to my question posted in the thread Return the value from the adjacent column for the nth occurence.My qestion basically was how would I modify the formulae if the value to be looked up was listed in a column unlike in a row as ithe case stated in the example .Specially if the column to be looked up was in another sheet or anothr workbook.In most of the cases I would use vlookup but doing that would always return the first occurences for values repeating themselves. Please find attached a orkbook which will help you understand my Question better.I am using names of cricketers and cricket teams as I connect less with soccer!!!!Please refer sheet 1 and sheet 2 of the workbookw
Reference to the thread link  Return the value from the adjacent row for the nth occ

Re: Return value in adjacent column for nth occurrence
Hey this is very similar to what I was looking for. But how would I change the formulae if the values to be matched which in this case ere row G,H I were instead listed in one single column. Such as G1 ,G2 ,G3

Re: match cells in excel with all characters same except one
Hi Robert I have attached a file showing where exactly the formulae is not giving appropriate result . Plz help

Re: match cells in excel with all characters same except one
Hi Rober thank you for your reply. However the formulae gives me true even for c(pls look the thread above). Also when the value is not repeating itself it still gives me true if the value in the corresponding cell is less than 2 or greater than 5 . I hope I am clear . Please sort this out for me it will be a big help.

Hi
I am trying to work a formulae in excel which will do the following for me. I have data in two columns ,col A and col B. So col A could read like thisA B
a 1
a 2
a 7
b 4
b 5
c 1
c 3
In need excel to check the col A for any values repeating themselves, so in this case "a" repeats itself thrice. It should then check the corresponding cells in col B and check if any of the values are less than 2 and any of the values is greater than 5. If it is then it should return true. So in the first case values corresponding to "a" are 1 , 2 and 7 .Since 1 and 7 satisfy the conditions it should give me true. But for b the values are 4 and 5 . Both the conditions are not satisfied and it should throw false. For c only one condition is met and again it should give false. Hope I have explained myself clearly