square

  1. D

    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"
  2. Expiry

    Simple VLOOKUP format question

    I have been out of the loop of using Excel for a while and I've been asked to look at some vlookup formulas. VLOOKUP([@Name],Table2,2,0),"" What is going on with the [@Name] bit? Name is the column name in the table that this formula is in. I understand that bit. If I over type Name in the...
  3. D

    Extract multiple strings from 1 cell

    Hi, I have a list of topic codes in a cell and I need to extract just the codes. The only thing that gets me close is splitting the cell based on a delimiter but there are two issues with that 1) I then need to delete the columns which contain the unwanted text and 2) sometimes I may have 4...
  4. Mandark39

    How to merge two squares into one square ?

    I am very new to excel . Please help :mad:
  5. J

    Sort groups of cells into numerical order

    Hi, I would appreciate any help on how to write some code to sort groups of cells I have into numerical order. The cells are grouped like this: <tbody> A B 1 15 16 2 green 3 triangle 4 5 11 12 6 blue 7 square 8 9 20 21 10 yellow 11 diamond 12 13 7 8...
  6. T

    How to see a checkbox, or check the file to see if one is actually there?

    I was sent a file and the creator has a few lists included in the sheet. The instructions state that I cannot make any changes to the form itself except my input, and I need to click on the square to make my selection. Unfortunately, I do not see a square or anything that looks like a control...
  7. D

    VBA problem with decimals and concatenation

    I have a range of numbers in cells that have General formatting. When a number in a cell is less than 43560, for example 40000, then I want to add the words "square feet", so it displays as "40000 square feet". I accomplish this with the following: If Val(ActiveCell) < 43560 Then ActiveCell =...
  8. J

    Countif

    This is the formula I am using: =IF(SUMPRODUCT(COUNTIF(C4:C8,{"Left Square Arm Combo";"Right Square Arm Combo";"2 Square Arm Combo";"2 Arm Left Radius Combo";"2 Arm Right Radius Combo";"10.5 Armed Right Radius";"10.5 Armed Left Radius";"9.5 Armed Right Radius";"9.5 Armed Left...
  9. C

    Maintain format when importing to web

    Hi All, I have an issue, where my intended format goes away, or is rather (trimmed) upon importing into my website. As example, I have the following format for a product size: ( 18"L x 18"W x 4"D ) Square pillow w/Down Insert When I import, it looks like this: (18"L x 18"W x 4"D) Square...
  10. R

    Need help finding Average cost per square metre

    Need help finding "Average cost per square metre". Can't think of how to do this. Any help is very appreciated. Also, the cells labeled "Hallway Total" and "Deck Total", are all their parts added up. <fieldset class="postcontent" style="margin: 5px 0px; padding: 5px 10px; border-width: 0px...
  11. P

    PDF aspect ratio from SmartArt

    My Picture Org Chart created from Smart Art always starts as a square even though I set width to 1000 and height to 500. Then when I ExportAsFixedFormat to PDF it's still a square and too small. Does anyone know how to have the chart created with a landscape size and to have the PDF created also...
  12. C

    I Need Help

    Thank you in advance I need to rite code such that when the button is pressed the next integer is appended to the end of thetable and its square (n^2) and root (SQR(n)) are calculated and displayed in the table. here is what it should look like...
  13. O

    Sum Based on the Last Entries of Each Series

    Hello!! Here's a raw data sample: <tbody> Date Program Phase 1/1/18 Circle PRM 1/2/18 Circle P2 1/3/18 Circle P3 1/1/18 Square PRM 1/2/18 Square P1MT 1/3/18 Square P2 1/1/18 Triangle P3 </tbody> I'd like Excel to find the last entry for a given Program (Column B) then...
  14. J

    Creating 0.45 Power Chart

    I can't provide specifics because I don't even understand what I'm trying to create really. Does anyone know how to create a .45 Power Chart? I'm trying to plot a gradation on a .45 chart. I have converted the square opening of the sieves from inches to microns. I have a different column that...
  15. I

    How to Remove Square Character?

    Hello, The special character I'm referencing won't appear in my post when I paste the Excel data as HTML. It essentially looks like a larger version of the square special character in the symbol library. When I click on the cell, the formula bar displays the square with a question mark in it...
  16. A

    Function (not SUB) to check if the selected range is square

    Hi, I am trying to develop a function to verify if the selected range is square, without passing any argument, but I am not being capable of counting the number of rows and columns. Function xlM_IsSquare() addrss = Application.Caller.Address m = addrss.Rows.Count...
  17. C

    Landing a number in a scatter plot

    Hi There, I'm hoping to find out how to populate a number from a list (1,2,3,4...) inside a marker of a scatter plot. For example, the marker might show as a red square on the graph, and inside that square, I'd like to be able to identify the data point with a number. Please help! Thank you...
  18. U

    Formula to Concat cells in Row, Skip blanks and add HTML code (text)

    Hey all, I have been trying to create a formula to concat 7 cells in a row, skip blanks, and add some HTML tags to it. I know the formaula wont work below but I have put it back to basic and need help to get it to the next step. Details below...
  19. P

    Showing mixed results in a square

    Hi there, I have four squares on a sheet each entitled 1-purchase Price 2-current price 3-purchase price stop loss 4 - current price stop loss. In a fifth square I want to automatically put the current stop loss. Square 3 is the key. If square 2 is below 3 then I would want to highlight that...
  20. B

    Multi-Criteria Search Box for dynamic listbox

    I am using 2 textboxes, 1 listbox, 1 button. I simply want to show a list that contain what is entered in the textboxes. textbox1 = color textbox2 = shape <tbody> TEXTBOX 1 TEXTBOX 2 A B C 1 BLUE-CIRCLE BLUE CIRCLE 2 GREEN-TRIANGLE GREEN TRIANGLE 3 RED-TRIANGLE RED TRIANGLE 4...

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
Back
Top