appreciated

My update query keeps failing, please see below...Any help will be greatly appreciated...Thanks UPDATE TSMDistributionTableTemp SET TSMDistributionTableTemp.DistributionType = "*" & [DistributionType] WHERE (((Right([DisbursementType],1))="*"));

Hi all, I am looking for a formula to highlight rows C:K if column H is blank? I have the following which partially works, not the whole range =H13<>"" Any help appreciated

<tbody> 1 2 2 2 1 1 2 1 1 2 125000 150000 175000 200000 </tbody> I need a formula in A5,A6,A7 that will say if A1 =B3 AND A2 = B4 then give me B5, if they both don't match move over to column C and see if both those match, if so give me C5 and continuing on...

Good day. I am running Excel out of Office 365 on Windows10. I have two workbooks that are basically the same. One is for 2018 and the other is a copy getting ready for 2019. After doing some editing, the older version is now closing without asking me if I want to save it or not. The other...

Hi, Does anyone know a cleaner way to incorporate a quarterly recurring cost in a monthly cash flow setting? What I do currently is =IF(OR(C3=3,C3=6,C3=9,C3=12 and so forth) but there must be a more sensible method. Any help much appreciated. Thanks:)

Hi all, I have this formula to reference a cell if it matches certain criteria - =if(A8=sheet1!AR$2,L8,””) What I also want to do is reference the cell if does NOT equal “sheet1!AR$2” Any help would be much appreciated :))

Hello, I am trying to use Sumproduct to calculate the difference between two dates per row, using the following: Column A = From Date Column B = To Date I have tried both of the following which do not work: Sumproduct(B:B-A:A) Sumproduct((--B:B)-(--(A:A))) Any help would be appreciated

Hi all, I have a list of websites in Excel, in column A1:A1100. I would like a macro to find the email addresses on these websites, copy them, and paste them into B1:B1100. Is it possible? Your help would be highly appreciated.

I'm trying to write a multiple if(or statement with three data points. IF(OR(AA11046="AAA",OR(AA11046="AAB",OR(AC11046="YES"))),"YES","NO") Brings back "no" no matter what. I'm trying to say if the points are aaa and aab and yes then give me yes. all others should be no. Any help is...

Hello, I am wondering how will my formula below will output me " " (double space) if the resulting value of this formula is equal to 0 Formula: =IFERROR(INDEX(A:A,MATCH(C1,B:B,0)),"") Any help will be appreciated. Thanks in advance.

I love excel and use it every day, however today I am stumped I want to add IFERROR to this formula =F3/SUM(B3:C3) I have tried =IFERROR(IF(=F3/SUM(B3:C3)),0) and it is not working Any help or guidance is appreciated. Thank you

Hi I have a team whose work is split alphabetically, each person has their own alpha split and associated workbook. I need to be able to restrict their input to only names within their split anything else should produce an error. eg 1 person has an alpha split for M - Mi. I have tried a few...

I am trying to combine this formula =IFERROR(1/1*(IF(D32=1,'Hours Of Service'!E4,IF(D32=2,'Hours Of Service'!N4,"")*1)),"") With this Formula =INDEX(E11:E18454,MATCH(TRUE,(D10:D18454>='Pre Trip Bid Summary'!I24),0))*60 This is one of the several ways I have tried. I have gotten two...

Hi, With range (C2:C10) I want to restrict input For example: If C2 is populated Can input in C3 Can't input in C4:C10 Any help appreciated

Greetings, I having issues with a formula the finds a name in a range. =IF(F10:F600="Bob",SUMPRODUCT((A10:A600="NOT SENT")*B10:B600),"") I keep getting #value error. Any help would be appreciated Thanks

Hi, I was wondering if it is possible to have a formula to do the following in conditional formatting. If A1 value is "JP" or "GB" and E1 has a value of either <244 or >265 the cell turns red. Any help would be much appreciated. Thanks Dan

I hope that this is not too dopey a question. I have a column containing a variation of UK postcodes where there can be 1 or 2 letters and 2 numbers grouped together like DE74 or E7 followed by a space and a further digit like DE74 2 and E7 9 but I am having trouble searching specifically for E7...

hello- I've been trying to write a piece of code to save-as a workbook. Here are the criteria- and I can fill in the "xxx's" if someone lays them out for me. Help is much appreciated. Needs to save-as on a C:\Users\Bridge\Desktop\Noons\Noons-Arrivals\(Myfile) The name needs to come from...

Here is the formula I'm trying to use: =IF((LEN(S4:S6)=0,""),(LEN(S4:S6)>0,AVERAGE(S4:S6))) Unfortunately, I am getting error message " There is a problem with this formula". Do you see anything that I need to change? Your advise will be greatly appreciated