excel formula help

Hello, I'm trying to automatize a report. I have several huge formulas that I would like to embed into the VBA editor. Can anyone help? This is the formula I want the Macro to enter: <tbody> IFERROR(IF(IF(ISNA(VLOOKUP(A:A,'Q1186 Warehouse Order Roundup'!A:S,MATCH("SHIP_STATUS",'Q1186...

I am working on a macro and need help creating a formula that will check to see if the next row is blank. If the next row is blank, it needs to stop the macro. if tne next row is not blank, I want to run the following formula (using the next cell and so on until it comes to a blank row). This...

Hello Y'all PART 1 2=32002-6013938-new I want N2=32002 O2=4211050 PART 2 AB = https://cdn.shopify.com/s/files/1/0368/2485/products/6013938.jpeg?v=1405679174 I want to USE O2 Value to Make new cell https://cdn.shopify.com/s/files/1/0368/2485/products/4211050.jpeg?v=1405679174

"=MID(J2;FIND("@";J2)+1;LEN(J2)-FIND("@";J2)-(LEN(J2)-FIND(".";J2;FIND("@";J2)))-1)" I have made this formula to extract the domain from an email, i mean it takes anything after the "@" and before the final dot. What i want to do is to add this to an Add-in like a custom function i.e...

I am using a sheet in which the G column values are auto calulatable using formula field and gives the result in % .I want to use a condition in the formula so that if result is > 100 % then it should print >100% instead of other values%.Sample sheet attached which clearly tells how it looks...

I was hoping to find a thread on this somewhere, but after a few hours of looking around without success, I decided to just post it here and hoping someone can help me out. I'm trying to display the total number of possible scenarios for my fantasy baseball auction draft. Here are the details...

I have several sheet of multiple rows and 59 columns, and I want use Count formula automatic way. Please recommend me ...

I have a spreadsheet to work out VAT recording and am trying to improve a macro I have to do reports. I need to select a section of entries and then look for the cell with OOS in it, insert 4 rows of cells only across the selected area ensuring that the original data is kept intact. The data...

Hi, I have a list of several hundred URLs that end with a product number. For example, they all end with /18442.htm. I need to pull out all the product numbers into a separate column using a formula. The product number is not necessary the only number in the URL string, but in most cases they...

Hello everybody, I'm new to this forum and I come up with a difficult (for me) problem to solve. I've got a cell with a list of names comma separated (Mr. Michael Quinn, Mr. Matthew Fresen, Mrs. Paula Plico) I need different formulas that gives me the different names as results: Cell 1 Michael...

I have a spreadsheet that has 2 tabs in it; the "data" tab contains 2 columns of data for example: <COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" span=2 width=86><TBODY> 31.95 0.80 </TBODY> The first tab is the "results" tab. I need the above numbers to...

I need help on a formula as below: {=SUM(1*('Site Management'!$E$8:$E$287=H$5)*('Site Management'!$AA$8:$AA$287<>""))} resulted as: <colgroup><col><col><col><col><col span="3"><col></colgroup><tbody> Description: Total Region-1 Region-2 Region-3 Visit in Plan 135 59 43 33...