peter

  1. neilp

    images on a userform

    Hi, Wondering if this was possible. If i have 5 images on a userform, is it possible for them to be changed according to a dropdown. eg if each image was saved in the same folder according to a set naming schedule ie Peter1.jpg, Peter2.jpg, Peter3.jpg, Jane1.jpg, Jane2.jpg, is there a way that...
  2. freelensia

    Join texts together when count > 1 in pivot table

    Hi, I have the following table Name Degree John BA Peter BA Peter MBA When I do a pivot table for Name & Count of Names, I get Name Count of Name John 1 Peter 2 Is it possible in this case to join texts under degree if more than 1 exist? So that... Name Count of Name Degrees...
  3. E

    Dynamic count depending on matching / non-matching criteria

    Hi, we have to collate reports from different departments. And I've been asked if we can help sort out (an evergrowing!) snag. There is a list of info <tbody> Customer Name Orders PETER SMITH ABC123 david jones 5962-99-3 peter smith XYZ789 222246 Green Bottles David Jones David...
  4. T

    Solver or Goal Seek?

    I am working on a problem that I just can't solve. It may be that I can solve with good old IFs but I want to see if Goal Seek or Solver would work better. Basically, I have 2 tables. One table has John, Peter and Mark repairing bicycles. Bicycle A totals up to 34, B total is 120, C total is...
  5. P

    Rows to Column based on unique identifier and time stamp

    Hi All, Please help me urgently to solve the issue I am facing. I have attached a sample data below. I want to have all values of Product 1, Product 2 and Product 3 in column deleting rows or may be in another sheet. The "Employee Number" are unque number in this case. Another condition is...
  6. X

    VBA to look and replace text in same row, different column

    I'm relatively new to VBA and I'm trying to write a code that will look at the receiving person column for Peter and will replace the Target Person and Target Fruit columns to match what's in the Sending Person and Sending Fruit. I used this thread here to figure out the code, but that thread...
  7. Sean15

    Index and Match - Excel says function has too many arguments

    col A col B col C USA John Peter 12 Mexico JOHN Peter 20 FRA John C Peter 25 John Peter return value should be USA INDEX($A$3:$A$5, MATCH(True, Exact(B8, $B$3:$B$5, 0)) This formula is...
  8. C

    Finding words in a database

    Hey! Quick question: So if cells A2:E20 contain singular words, and these words could appear anywhere and multiple times in the database (A23:CC5000) what formula should I use to return a whole row from the databse if it contains a word from A2:E20? For example of C6 has "Peter" and the...
  9. M

    How to extract names with variable lenths from text strings using Excel?

    I need to extract names from a text string but they are variable in length. See example below: PETER PAN PO LLL555555D AUB-1111111 2/27/10 1079.65 1012348 SUPERHERO MAN GGG444444C AUB-0000000 8/02/10 108.00 704546 SUPERHERO WOMAN PO GSS011111F AUB-1111111 3/13/10 11.26 1028549 The names I am...
  10. P

    Tun-time error 457

    Fellow sufferers I am getting the Runtime-error '457'. The Value of the array is Empty in the watch, how is that possible? Please see code and error message. BW Peter B Hansen https://drive.google.com/open?id=1m9PO4iRRIIM7mIZdSyGmk6ydQdRSskBf
  11. P

    Assign macro

    I have one combo box and a buttom I have this table in excel date name goods name Qty 21-1-2018 David Pen 12 22-1-2018 Peter pencil 14 10-2-2018 David paper...
  12. E

    Detect if another program currently has access to application

    Hi all, Scenario: a vb.net Program is currently reading some informations from a workbook open in the Application. This may take some seconds. Is it now possible to detect in vba that this currently happens. Thanks Peter
  13. A

    Macro needed

    Hi, Would you please be so kind and assist me with a macro to extract specific data within a spreadsheet. The specs are. I have a list of students 30+ who rights exams every week and I want to extract the top 3 marks and names each week. Should there be more than 3 student with the same...
  14. X

    Help: Table with multiple values to List

    Hi everyone, Im trying to figure out a way to make a Table into a list. Example: <tbody> Peter Anders Mikael John Criteria1 1 1 Criteria2 1 1 Criteria3 1 1 1 Criteria4 1 1 </tbody> What I know want to do is the following if the cell has "1" with a formula if possible...
  15. A

    Sumproduct with Matched Criteria an Extracted Text

    This is a Qn pertaining to <tbody> <colgroup><col style="width:48pt" width="64" span="8"> </colgroup><tbody> A B C D E F G 1 2001 2001 2002 2002 2002CY-Q1 2 Sales Profit Sales Profit Sales...
  16. P

    Looping through Object

    Fellow sufferers I am doing something´like this: inhabitants_in.Add "Norway", CreateObject("Scripting.Dictionary") inhabitants_in("Norway").Add "Oslo", 200000 How can I best, later, do something like, to find all the countries in the root: For each country in inhabitants_in...
  17. B

    how to make this pivot table field?

    I have a number of employees that had multiple check-in times. So for example Peter may have checked in 3 times on Jan 1, 2 times Jan 2, 7 times Jan 3 etc. These dates are in the Date column. I want to create a pivot table which shows an employee and the number of checkins per day. So I'd want...
  18. B

    challenge for me

    i have 4 columns containing data a is employee number example 123132 b is employee name example joe blogs c is a number so example 123132 Joe Bloggs 1.00 213233 Peter Jones 1.00 213167 Sea Young 1.00 heres the challenge if the column c says 3.00 i want this to create in total 2...
  19. S

    Trying to align/merge two data sets/tables

    Ive been working on trying to do this for 4 days and I still can't do it. gone through every tutorial everywhere. Trying to do this List 1 <tbody> Column A Column B John ID258 Peter ID236 </tbody> List 2 <tbody> Column A ColumnB John Carrots Peter Apples </tbody> To this...

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