returning

I need an excel forumula that counts unique ( no duplicates and no blanks ) in Column A and that have a "1" in Column B. I found the below forumula online, but its returning a "#VALUE" when it should be returning a number =SUM( -- (FREQUENCY(IF(Calls1!B:B = "1",Calls1!A:A),Calls1!A:A)>0)) If...

=SUBSTITUTE(aconcat(IF($AH$3:$AH$22=AN10,", "&$AG$3:$AG$22,"")),", ","",1) Hi there I am using the above formula which has worked perfectly in the past and now for some reason it os only returning #VALUE! as the result. Any ideas on what is causing this please? Many thanks Renee

I have a cell AP11 that has a IF function in it here it is "=IF(K11="","",VLOOKUP(K11,$I$2:$J$8,2,FALSE))", it returns either the value NONE, or one of many text stings such as E300R191M or E1595R19 that are in the range I2:J8 or remains blank. I need to have another cell AW11 return a 0 or...

I am using the following formula to return values from a different worksheet but its pulling in the value 2 rows down and 2 columns across from what it should be returning. =IFERROR(INDEX('Numbers input'!$C$3:$Q$300,MATCH($B7,'Numbers input'!$B:$B,0),MATCH(D$5,'Numbers input'!$3:$3,0)),0)...

All, I really hope this is the last time for this but I have a sum if function that is not returning any value. {=SUM(IF(ISNUMBER('Line 5 data copy'!$N$5:$N$750),IF(INT('Line 5 data copy'!$N$5:$N$750)=INT('Line 5 calc Sheet'!B3),--(('Line 5 data copy'!$O$5:$O$750<400)*('Line 5 data...

=IF(ISNUMBER(--LEFT(H11,"79")),"CORP-ADMIN",IF(ISNUMBER(--LEFT(H11,"10")),"CORP-ADMIN",IF(ISNUMBER(--LEFT(H11,"15")),"MA-RCC"))) The above Formula is returning "CORP-ADMIN" even if the cell value starts with "15". What's going on?

Morning guys A simple one for you experts, but not so simple for myself as a newbie to VBA. I am trying to write =IF(H2="0",H2,"0"&H2) as part of a VBA string. However, whatever I try is returning #NAME ! Any ideas on how I should write this in VBA please folks? Many thanks, Gareth

I have a spreadsheet with a list of titles such as this one in A2 <colgroup><col></colgroup><tbody> CLT Referrals May 2017 I have a formula working on that cell: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color...

Hi everyone! I have what I am assuming is a noob question. I have several =MIN formulas I want to stop from returning 0's when the reference cells are blank. At the same time I would like to maybe build the formulas to work a bit more efficiently. See the attached image below. This is the part...

Hi all, I'm trying to tidy up and speed up a spreadsheet by having pre-populated formula already to use in specific cells. The code below works perfectly when F9 has a value, however I want the cell to appear blank if F9 doesn't contain a value - currently it will spit out "30658" I've...

Hi Guys, The formula below is only returning A and B and Not C =IF(RANK(M2,$M$2:$M$3765,)/COUNT($M$2:$M$3765)<=1/3,"A",IF(RANK(M2,$M$2:$M$3765,)/COUNT($M$2:$M$3765)<=2/3,"B",IF(RANK(M2,$M$2:$M$3765,)/COUNT($M$2:$M$3765)>=3/3,"C"))) Any ideas ? Many thanks