inside

  1. T

    Pie Chart

    Dear Excel expert, Please advise how to move the legend inside the chart Picture is available in here https://ibb.co/kgmw8R
  2. H

    Replace certain commas in a string

    Hi, Can someone please tell me how to replace certain commas in a string with a semi-colon? I do not want to replace any of the other commas. Example: = MIN(MIN(R67595,R250000), R67574)+ SUM(R27215,R27218) Should be: = MIN(MIN(R67595,R250000), R67574)+ SUM(R27215:R27218) The commas I want...
  3. 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...
  4. L

    VBA Assign Vlookup Result To Variable

    Hey, I’ve searched around for this, what I’m trying to do is store a vlookup result inside my variable. At first I switched my sheet to R1C1 and put the VLOOKUP inside an EVALUATE which worked fine. However when I switched back from R1C1 on the sheet it gave me a type mismatch. So I tried to...
  5. O

    Write a paragraph inside a cell.

    Hello: Im trying to put like a paragraph inside a cell and do not know how to do so: Ex: Section 23.d (page 234) Recording Keeping “You should keep records for ever…” Section 23.f (page 235) Shame on you section How can i put all of these, with the same spaces and alignment inside a...
  6. K

    Chart element show different between 2 bars of a chart

    Hi, I saw this visualization in an Excel file. Trying to plot the element inside the red circle. Do you know how can I plot that? Thanks
  7. O

    Click inside userform textbox to enter date

    Is it possible to click inside a userform textbox and populate using todays date? Thanks.
  8. J

    Fit picture exactly inside cell

    Hi, I'm using a Mac. I have a cell one column wide by 11 rows long (merged). How can I fit a picture exactly inside the cell so there is no gap between the picture and the cell border when printed? I have tried using the ALT and CMD keys to drag the picture in place but the document still...
  9. D

    Using Small+If array structure with multiple criteria

    Hello all, I need help to find a way to use the Small+If structure with multiple criteria inside the If (without creating multiple If). Currently my model works just fine if I have only one argument inside my If. For instance: In here, the range E2:E6 is returning the values that match the...
  10. A

    Embed/reference formula text inside another formula

    Hi, I'm trying to embed formulaB8 into formulaB9, resulting in valueA11. <tbody> formulaB8 : SUM(A2:A4) formulaB9 : =SUM(formulaB8,2) valueA11 : 8 </tbody> I'm trying to do this without actually pasting the formulaB8 text into formulaB9. Since I have one large formula that is re-used...
  11. B

    Combining two cells which contain lists

    Hey everyone, I have a large spreadsheet with many pairs of cells like this: Names Emails <tbody> Chris Ritter;Ina Lucas;Tammy Willerth;''''''Eric Willerth'''''';Maya;Regina Bell;Bonita Schaufele;'Marilyn Llewellyn' <tbody> ceritter@telus.net...
  12. C

    Using the values inside a cell as part of a formula/function

    Hello all, I am looking to use the values inside a cell, as part of the function in another cell. Is this possible?? The rows in the above picture have been omitted however they start from 1,2,3 .... So I have the cell references inside of a cell i.e. the value of range("Q2") = E2 ... etc...

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