braces

  1. BradleyS

    Sum duration values only if -3

    The table below shows an ID reference and each -3 (shown in red in my example only) is an accumulative count of the duration and needs to be added to the value above it. So if the ID is NOT - 3 it will be just be the adjacent duration value. However, if the ID is -3 it now has to be added to...
  2. danhendo888

    Search for multiple values w/ one criteria but show unique values only

    <colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E </thead><tbody> 1 Invoice Number Date of Payment 2 1 1-Jul 3 1 1-Jul 4 1 4-Jul 5 1 4-Jul 6 7 8 Invoice Number Date of Payment 9 1 1/07/19...
  3. F

    A formula inside Curly braces inside Vlookup does not work, but seems good in theory

    Thank you for reading. I started wanting to set up a report to in excel to go find data for a month period (single cell), quarter to date period (multiple cells) and year to date period (multiple cells). Using curly braces in the VLOOKUP helped = sumproduct(vlookup(a1,'sheet1'!a1:z200...
  4. C

    #name?

    Don't why there is #NAME ? error using the Morefunc (MCONCAT)? <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color...
  5. T

    VBA Insert Shape next to each merged cell

    Hello, I want to utilize a macro to place left braces next to each merged cell. I already have a macro that goes down a column and merges groups of cells (going from A,B,C,etc): Sub MergeCells() Dim LastRow As Long, Ar As Range LastRow = Cells.Find("*", , xlValues, , xlRows...
  6. Fishboy

    VBA - Using array of values

    Hi all, OK, so I have come a long way since I joined back in February. I started out asking about how different formulas worked to achieve my goals but have since started down the VBA road and am even helping others out along the way. Progress. Something I have been trying to do with my own...

Watch MrExcel Video

This Week's Hot Topics

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
Top