# brackets

1. ### Perfect brackets for online tournament [VBA] [Very advanced]

Hi, everybody In a couple of weeks I will run an online tournament. In this tournament there will be between 11-60 players. Every player will play 5 matches (1 match every round). A match consist of 1 game between 5-10 participants. I want to find the perfect matches, which is rougly defined as...
2. ### Excel Problem regarding Formula

Hi I am trying to write the below in a formula but I am having some problems, I tried to a formula but is not working. You write amount (and on which category the amount fall it will work the sum) If amount is between 0.00 to 9100.00 = 0% - 0.00 If amount is between 9101.00 to 14500.00 = 15% -...
3. ### Delete Entire column based on word search

I'm not very good at VBA and am struggling to work out a way to search across the top row column headers and delete the entire column if the following words do not exist in the relevant text description of that column. The columns headers will have different text, but just in case it helps I...
4. ### VBA: loop in cells and delete bracket content

Hello everybody. I'm looping in a range: For Each cell In Sheets(2).Range("F2:F" & lr3) '.... Next cell For each cell in this range, I need, if existent brackets with exactly 2 characters as a content, delete the brackets and its content. For example: LONDON (LD) has to be turned into...
5. ### Extracting data from within multiple square brackets

Hi How would I extract the contents of the square brackets from the following? [A1] fjdlkfjsdlkjfalkdjfldksj [A5] ndjklafdkjda [A8] fjdlkfjsdlkjfalkdjfldksj [A2] ndjklafdkjda Ideally, I'd like the adjacent cell to contain, "A1, A5, A8, A2"
6. ### Removing everything outside brackets in a cell

Hi!! I have a bunch of cells which contain data similar to "0.120 (3.048)". I want to delete everything out side the brackets. Is there an easy way to do this? Thanks in advance
7. ### Removing brackets

Can someone help me with this function, I am trying to remove the RoundDown feature from the formula but it is not liking the brackets that I am removing. How should it look? The formula is...
8. ### Formula Not Returning Expected Value

Can someone tell me why this formula is returning "FALSE" opposed to "YES" or "NO" ? I have a feeling the brackets are incorrect =IF(AND((\$F\$2>=A4),(\$C\$2<=B4)),OR(IF(AND((\$F\$2>=A5),(\$C\$2<=B5)),"YES","NO")))
9. ### VBA Extract and sum numeric values from bracket

Hello, I had a code for this but I can find it anymore. Basically, I have a sheet with a column of alphanumeric values. At the end of each string I have a decimal value between brackets, but also some text. I would like to extract the numeric value only, sum all the extracted values with the...
10. ### MID Function to find a string within brackets

Hello I am using the following: =MID(B5,SEARCH("[",B5)+1,SEARCH("]",B5)-SEARCH("[",B5)-1)+0 Where cell B5 has the following contents: =IF(B6="","rdhgxfjhsftjhjh(Text to extract)hujkfjkdjsdt","") and cell B6 is blank. I am receiving a #Value error, and am unsure why. My cells are formatted...
11. ### Macro that gets rid of brackets in formula as in the example.

Hello, First time here, as I can't find the answer I'm looking for browsing the internet. Is there a way of writing a macro in excel that does this ? How do I get from this: (A/B/C)+(D/E) To this: A+D or A+E or B+D or B+E or C+D or C+E This is just an example, the macro I want to write is...
12. ### This formula to check if a text string contains a number in it - is it an 'array' formula?

Found this post that has a formula that appears to do what I want > check to see if a text string has a number in it (any digit 0 thru 9): =COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A1))>0 But I see there's squiggly brackets, indicating an 'array', right? I've avoided array formulas in my file b/c I'm...
13. ### Curly Brackets but not an array?

Hi I've been given a spreadsheet to work through and there's a formula that I've never seen before. It's =IF(SUM(COUNTIF(E3,{"*M*","*T*","*W*","*F*"})),"O","") The curly brackets are there whether Ctrl Shift and Enter is used or not. The only time I've seen curly brackets are for arrays...
14. ### need a macro to remove brackets and single quotes and sort

I have words in a cell cell and would like to have the brackets and single quotes removed and put in alpha order. I have this in a single cell: ['red', 'blue', 'green', 'yellow']. I want this in a single cell: blue green red yellow
15. ### Split comma delimited data but ignoring commas between brackets

Hi I have a set of data in the following format: <tbody> code other members modified ABC Babalwa Lobishe (Economic Development, Tourism and Agriculture), Fikile Desi (Constituency Coordinator), Thembinkosi Mafana (Safety and Security), Nomamerika Magopeni (Sport, Recreation, Arts and...
16. ### Caps in brackets

Hi,, In column A I have very many phrases. Each phrase may or may not have one or more words in brackets. How can I make all the words in brackets written in capital letters? Thank you.
17. ### Is it possible to use variable in brackets when using .FormulaR1C1 ?

Hello, I´m new to VBA and I wonder if you can put a variable inside the brackets when using .FormulaR1C1. Here is an example of what I´m trying to do: Sub b() Dim fl As Integer Dim fc As Integer Dim nb_parts As Integer Dim nb_measurments As Integer fl = 8 fc = 8...
18. ### Adding a sumif function into a formula

Hi, I have written this formula, but it doesn't work! I am trying to add 1 to the result of the first formula (in brackets), if there is a '&' symbol in AZ10. I think what is confusing it is that I mean for it to look for a & within text, for example, 'Mr & Mrs Smith'. For this reason, I...
19. ### How Do I Know I Have an Array Formula?

How do i know I have an array formula? For example, how do I know when to add brackets around this array formula? {B2:I2*B3:BI} And also with this? {=SUM((A1:A10="jim")*(B1:B10="ben")*(C1:C10="alice")*(D1:D10))}
20. ### VBA Remove anything in cell with brackets

Hello, Is it possible to remove any text in a cell in brackets and the brackets please? Many thanks.

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

### This Week's Hot Topics

• link pictures from Sharepoint to Excel macro
Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
• lookup match return closest to x date
Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
• Average hours per week
I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
• Identify equipment used -No of consecutive days
Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
• Filling in data from source
Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

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

### Which adblocker are you using?

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

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