appreciated

Hi, I have a list of values that I need converted. They look like this: <tbody> 14.75K 29K 44.5K 26.5K 28.5K 1.5K 22K </tbody> and I am trying to get them changed to <tbody> 14750 29000 44500 26500 28500 1500 22000 </tbody> Any and all help Appreciated! Thanks, Todd

Good day, I have been struggling to calculate the below. What I would like to calculate is if T is blank or 0 and A is equal 1. I need to know the sum. I have been trying with Sumif, sumproduct and countif without success. in the below example the answer should be 3. Any help will greatly be...

Good afternoon! I pulled several thousand formulas into a spreadsheet and brought them in with the ' front of the =. Now that I have modified the formulas and am ready to calculate them all I need to get rid of the '. I've tried a dozen or more methods of doing this and have failed every time...

I have been trying to get this to work and to no avail.... =IFERROR(VLOOKUP(H5,'C:\folder*\Folder*\Folder*\Folder*\[Auctions Offered Template.xlsx]Auction Offered'!$D$3:$G$33,2,FALSE),"") The Folder* is just a placeholder for my file path. I get a result 0. However that is not the answer...

Morning, This seems like it would be fairly easy to do but as you can see by my username, i'm excel illiterate. So I have two columns B2 (10/01/2019) and C2 (01/22/2019) and I need to figure out what formula to use in order to make these reflect 30, 60, and 90 days. B2 has various dates but C2...

Please can someone help...I want to be able to filter on a table and delete if the result is 'Yes' and then remove filters using VBA Ay help, will be greatly appreciated Thanks Rehmat

Hello kind people not sure if anyone is able to help me at all been trying to sort this for hours but don't think I'm quite up to the level needed any help would be greatly appreciated. So I have data in a spreadsheet; - Owner Name - Business Name - Contact Number 1 - Contact Number 2 - Email...

Hello I am struggling to get this vlookup vba to work, The Submission tab is a table , not range downloaded from adatabase. I am trying to pull data from column AT, which has the followingformula in it =SUM(AQ2+AR2+AS2) When I run this code it returns no results Dim lastrowcolumnb As Long...

Good Morning I have a number of Text Boxes All with the same name "Time1". I need to edit each of these boxes using VBA to remove the first character which is a Minus. Your help will be much appreciated. Regards Kev

Hi I am trying to write a query for the below link https://imgur.com/a/J55Z2xc Any help would be greatly appreciated Thanks

What is it a about this formula on why t wont work? What ()"s missing? Any help will be appreciated. =IF($G$20=$S$22,(B32-(B32*0.3%+1.5,(IF(AND($G$20=$S$23),(B32-((B32*0.15%+0.3)

I have the following formula in Col G =IF(LEFT(B2,2)="UC","COS",IF(AND(B2="F22200",F2=""),"COS",IFERROR(VLOOKUP(F2,'unique Suppliers & Codes'!A:B,2,FALSE),""))) I would like the formula amended so that if Col F contains a date format dd/mm/yyyy for eg 03/04/2018 then it must return COS in...

Hi Everyone! I'm attempting to calculate the below formula in VBA. However, it returns a type mistmatch error. Any help would be greatly appreciated =) dblMyVal = Evaluate("SUMPRODUCT(($H$2:$H$1000)*($A$2:$A$1000=A" & rw & ")*($B$2:$B$1000=B" & rw & ")*($D$2:$D$1000=D" & rw &...

Hi Everyone! I'm attempting to calculate the below formula in VBA. However, it returns a type mistmatch error. Any help would be greatly appreciated =) dblMyVal = Evaluate("SUMPRODUCT(($H$2:$H$1000)*($A$2:$A$1000=A" & rw & ")*($B$2:$B$1000=B" & rw & ")*($D$2:$D$1000=D" & rw &...

Hello Community, I have a given dataset. My duty is to use Pivot table to generate a table indentical to the one in the picture in the right of the file. I have tried but messed things up badly. Please follow this link for the dataset...

Say cell E2 needs a formula that will produce a "yes" or a "no". if C2 and D2 are empty E2 should also be empty. If C2 and D2 have a no in either cell E2 should say "NO" if both have a yes or a "NO CHANGE" in both cells E2 should say "yes". I'm not sure why I can't make this work. Any...

Hi I'm trying to use a filter on a number of cells and want the value to update, I originally had =SUMIF(BJ8:BJ202,"Yes",O8:O202) I have this formula but it returns zero value, any idea what is wrong? =SUMPRODUCT(SUBTOTAL(9,OFFSET(BJ8,ROW(BJ8:BJ202)-ROW(BJ8),0)),(O8:O202="Yes")+0) Any help...

Hi there, It has been a very long time since I have been on here :( I have a problem which I do not know where to start. I have a cell (a5) where I can change the part number, and I am trying to lookup to a photo that will be in any one of multiple folders and return the image to cell a20...

Hi, I have the below formula and can’t figure out why it returnsa #N/a instead of the “Policy Not Found” The "Policy found" and “” are working fine the only problem iswith the false value coming up as #N/a instead of "Policy Not Found" Any help is greatly appreciated...

Hi I would like to enter this formula in a cell =Sum(P2-1)*I2 But if cell p2 = 0 then just return what’s in cell d2 Any help appreciated thanks! ?