original

<tbody> Original Revised Days Overdue 12/2/19 31/3/19 X 31/12/19 X </tbody> Good morning all, I wonder if you could help me out with a query. I have a table with two dates, an original date and a revised date. I need the formula which looks at the revised date first and...

Hi, Can someone please help me with this: I have a table with these columns: <tbody> Product Original currency Jan-16 Feb-16 ... Dec-16 Total 2016 in original currency Total 2016 in CAD A USD 3 5 8 XX (3*1.3)+(5*1.28)+...+(8*1.294) C EUR 3.4 3.2...

Hi Folks. Is there a way to chart (see data below) the "Original SA #" as one line attached to the "Original SHSD Ready Date" and the "Current SA #" as a second line attached to the separate date series "Current SHSD Ready Date" all in one chart so it aligns as a single time series on the...

Re: Number selection Hello All, Sometime back ( June 1st 2019 ) I put in a request in the forum for help on Configuring Number Groups. https://www.mrexcel.com/forum/excel-...er-groups.html What I would like to do is to perform much the same task as the original request except for the...

Hello, I have a worksheet that I want to add an average row after each category. I can get the added row but how do write a formula to select the changing ranges for each category? The example shows the original data and what is should look like after the macro runs.Excel...

Okay this is what I am trying to do. I need to take a Hex value and have it returned in reverse Byte pairs as in the following diagram For instance the top line (480000074B26E42D) being the original hex value, then reversing it so that the outcome = 2D E4 26 48 07 00 00 48 I have tried using...

Hello, I want to create a spreadsheet where I start with a fixed value, say £100,000 which will grow at a rate of (say) 4%pa for 10 years when I will start drawing down capital at 10%pa. This part of the calculation is easy but what I then want to do is to apply the original 4% growth to the...

I have the following formula that works: =IFERROR(IF(AND(D5="Y",E5="Y"),C5*$G$2,0),"") I need to add an additional piece that says to look at a cell in B5 and if it says INACTIVE then multiple C5 with G1, otherwise I want it to do the original formula posted above. I have not successfully...

https://1drv.ms/x/s!AvjBsEPEq12ngUDMrgxRZFuYzsgm?e=ghaRAa Hi guys, I need to copy/paste cells M1:V14 to Sheet2 but have the absolute references point to the cells from the original sheet Is there a way to do this?

Is there a way to keep the formatting, i.e. margins, headers/footers, layout, etc., of the initial Pivot Table and have it carry over to all of the others once I use the 'Show Report Filter Pages'? I have the original one formatted exactly how I want it, but when I have each of the others...

A cell in my source column appears as: to complain, to grumble I have a MATCH/INDEX lookup formula that returns that cell, but I can't figure out how to retain the bolding of the original (with only "to complain" bolded)...a brief search suggested it wasn't possible; any ideas?

<tbody> B F J ID# Date Duplicate? </tbody> Iwas wondering if you could Help me out with a formula? I need Column “J” tosearch for duplicate values in column “B” and say “Yes” only if the date incolumn “F” is within 180 days (6 months) of the original value.

I want to delete NA from my spreadsheet without getting it deleted from middle of the words like original using vba. Please help

Hi to all of you, kindly require to provide me a VBA code so that to run through col "H" and should clear any numbers or symbols and adjusting the remaining text on left align. An example is below by which i present the original data and expected result. Thank you all in advance Original data...

I cannot determine how to show my main toolbar. I can see my add-ins toolbar but not the original toolbar. Help is appreciated. I tried CRTL+F1 but all I get is a help screen. Thanks,

How do I setup a rank, type formula, to exclude subtotals? I am trying to pull a top 10 list. if I do a subtotal on the original data, I lose most of my top 10 values.

Hi I've downloaded some data which comprises of business name, address and post/zip code. The data has arrived in a single column but I now need to sort so that I can effectively swivel the company data 90 degrees so each business lists across a row. Not all of the data is consistent as some...

I have a table that I need transferred into another format. All the information stays the same but it will have a different logic: rows become columns and vice versa. This is a table with a LOT of data so I can't do it manually. What is the easiest way to do this? I'm thinking a formula that...

Hi all, kindly require to provide me a VBA code so that to run through col. "A" and should replace the number from left side which "2" into "1". I present below original data and expected result. Thank you all in advance original data 1205000 1206500 1207700 Expected result 1105000 1106500...

I started a thread that had a bad name so I started a new thread with a more meaningful name. The original thread is here https://www.mrexcel.com/forum/excel-questions/1098809-i-need-some-help-please.html#post5283211