1. K

    IF ISBLANK formula

    <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...
  2. E

    How to combine two table information?

    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...
  3. A

    Trouble with a Double Line Chart Using Two Date / Value Series

    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...
  4. C

    Re: Number selection

    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...
  5. R

    Average if on dynamic Range

    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...
  6. R

    Reverse Hex Byte Pairs

    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...
  7. S

    Calculate Growth Value When Drawing Down Funds

    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...
  8. K

    Embedded If Statements

    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...
  9. danhendo888

    Copy paste formulas to new sheet (absolute references)

    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?
  10. K

    How To Keep Pivot Table Format

    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...
  11. D

    Maintain partial bolding of original cell when doing an INDEX/MATCH lookup

    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?
  12. A

    Find Duplicate only if date is within X days of original

    <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.
  13. U

    Deleting query

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

    Clear numbers and symbols

    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...
  15. J

    Missing Main Toolbar Excel 2010

    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,
  16. P

    Rank - exclude subtotals

    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.
  17. C

    Convert a list into rows

    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...
  18. M

    Transfering Data between Excel Tables of different setup

    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...
  19. P

    Change numbers in column "A"

    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...
  20. D

    Changing linking so instead of being between tables, it is linking between ranges

    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

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back