square

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"

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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