thomas

  1. M

    How do I get a label in a scatter plot instead of "Series 1 Point"?

    I've got a scatter plot and when I hover over a point, it says something like: Series 1 Point "1.03" (1.03, 4.12) Series 1 Point "2.7" (2.7, 3.06) I'd prefer for it to say: Thomas (1.03, 4.12) Leslie (2.7, 3.06) I can get the labels onto the chart, the problem is when hovering the mouse...
  2. albertc30

    Countif but filter the number of customers...

    Hi all. I am trying to filter the number of say invoices pending and the formula bellow does this. =COUNTIF(E:E,"NO") However, the goal here is to show only the number of customers with outstanding unpaid invoices. These would be marked on say collumn E as NO. So, say column D has customers...
  3. H

    Extracting Initials and surname from cell

    I have a column which contains first names and surnames in the cells. I want to extract the initials and the full surname from each cell. e.g. cell A1 will have Peter John Thomas which I want to convert to P J Thomas, cell A2 has Mary Jane Louise Wilson which I want to convert to M J L Wilson...
  4. A

    Data Validation List

    I have a list consisting of names in column A. I would like to type the name in a cell and would like to see the names that match that criteria. for example: the list has the following names: SAM JOHN THOMAS JOHN JOHN THOMAS NEIL WILSON JOHN AMY AMY JOHN AMY GARET IF I WERE TO TYPE IN THE...
  5. S

    <VBA> Looping and Copying

    Hello All, I've been trying to figure out how to write a VBA macro to loop through the cells of a column, matching cell(s) with a criteria, copy a cell from that row to a different sheet, and then print a specified selection. This table is located on Sheet "Data". I need to loop through Column...
  6. S

    Looping, Copy Cell, Paste Cell, Printing

    Hello All, I've been trying to figure out how to write a VBA macro to loop through the cells of a column, matching cell(s) with a criteria, copy a cell from that row to a different sheet, and then print a specified selection. This table is located on Sheet "Data". I need to loop through...

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