Re: match cells in excel with all characters same except one
in your first post you have stated:
QuoteFor c only one condition is met and again it should give false. Hope I have explained myself clearly
that should have been NOT met.
Try this:
=IF(COUNTIF($A$2:$A$9,A2)=1,FALSE,(COUNTIFS($A$2:$A$9,C2,$B$2:$B$9,"<2")>0)+(COUNTIFS($A$2:$A$9,C2,$B$2:$B$9,">5")>0)=2)
Re: match cells in excel with all characters same except one
Could ypu post your workbook?
Re: Return value in adjacent column for nth occurrence
You are welcome.
Re: match cells in excel with all characters same except one
=SUM(COUNTIFS($A$2:$A$9,D1,$B$2:$B$9,{">5","<2"}))>0
Where D1=a
This will work in Excel >03
Re: Number of calls made by a person in a month
In D1 name of the person in E1 =6
Formula
=SUMPRODUCT(--(A2:A500=D1),--(MONTH(B2:B500)=E1))
Re: Return value in adjacent column for nth occurrence
=IFERROR(INDEX($D$2:$D$25,SMALL(IF($C$2:$C$25=G$1,ROW($C$2:$C$25)-ROW($C$2)+1),ROWS($C$2:C2))),"")
Confirm Contrl+Shift+enter Drag down and accross
Re: Formula not working
If you can attached your wrkbook that would be handy.
Re: VLOOKUP Partial Text Match
forum.ozgrid.com/index.php?attachment/56069/
Not sure what are you reffering too.
VLOOKUP is not an option here.
Re: Find last digit in row < X
=CELL("address",INDEX(B2:AV2,LARGE(IF(B2:AV2<34,IF(B2:AV2<>"",COLUMN(B2:AV2)-COLUMN($B$1)+1)),1)))
Confirm Contrl+shift+Enter
Re: VLOOKUP Partial Text Match
=INDEX($B$2:$B$5,MATCH(TRUE,ISNUMBER(SEARCH($A$2:$A$5,A10)),0))
Confirm COntrol+Shift+Enter
Re: Find last digit in row < X
Could you post your worbook?
Re: Find last digit in row < X
=CELL("address",INDEX(A1:S1,LARGE(IF(A1:S1<34,COLUMN($A$1:$S$1)-COLUMN(A1)+1),1)))
Confirm COntrol+Shift+Enter
Re: Compare 2 List and extract data in 3rd
You are welcome
Re: Average data columns ignoring hidden rows and zero values
No PM necessary.
Not sure about the upload.
Maybe wrong format
Check here:
http://www.ozgrid.com/forum/showthread.php?t=73181
Re: Formula not working
Check format of your cell and change to General
If you are draggin to the left the cell will change to DF5 and EY5.
What's the values in those cells?
Re: Average data columns ignoring hidden rows and zero values
Which Excel function are you using?
If 2010 look at AGGREGATE otherwise post sampe of data/workbook.
Re: Formula not working
Do you have automatic calcualtion switch on?
Re: Multiple Criteria for Max
I have not done any tests recently but sometimes when I run in the past I got the the split of seconds in test different everytime.
I keen to seen what woudl happen and 500000 rows.
I assume there is correlation as well to your PC(memory and processor) and the type of data.
Please share any other tests you going to do.
Re: Return Value Depending On Text In Cell -Second Question
You are welcome.
Re: Compare 2 List and extract data in 3rd
=IFERROR(INDEX(B:B,SMALL(IF(NOT(ISNA(MATCH($B$1:$B$8,$A$1:$A$8,0))),ROW($1:$8),""),ROW(A1))),"")
Confirm COntrol+Shift+Enter
