ron

  1. S

    Simple Formula in Excel?

    Hi, I need to pull a column from a dynamic data source based off one unique id(Math). Can someone help with a formula? I need to pull all names associated with the unique id onto another sheet. In a listed column. Example below: Data Source: <tbody> Name Class Ron Math Amy Science...
  2. V

    Automatic conversion of the currency

    Hello! I have a table to be filled in with the prices of some products from different offers. Some products are acquired in the Euro currency and the others in the RON currency. My question is if is any possibility (macros, formulas) so that when I insert the value expressed in one currency...
  3. M

    Creating PDF On Mac: Multiple Sheet Orientation

    I am attempting to create a PDF including several sheets from a Mac. (I am a PC user, but am doing this for a client who is Macs.) I referenced Ron de Bruin excellent post on the subject (https://www.rondebruin.nl/mac/mac005.htm), but there is one thing that is not working. The workbook that...
  4. K

    Limiting Validation Selections with VLOOKUP Data

    So trying to build a spreadsheet for my daughter for a game she got for Christmas. Each card has a value 1-3. I can build the data validation and I have the VLOOKUP correct, but I'm trying to figure out how to make it to where she can only select the number of things that the card value is...
  5. M

    Meaning of some words ?

    In part of my print macro, I have this ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1, Collate _ :=True, IgnorePrintAreas:=False Now what does IgnorePrintAreas:= False mean please? where can I find what all of these mean? Ron
  6. J

    this ones to complex for me

    Sheet 1 holds all the information. Sheet 2 is going to be a kind of chart that I want to be auto created. on Sheet 1, Column A is the names, Column B is the Column # on sheet 2, Column C is the starting row # on sheet 2, Column D is the amount of times I want the name to be repeated...
  7. E

    Delete row if a specific value exist (VBA)

    hello i'm using code based on Ron de Bruin's site I want to delete row/s if a specific value exist on either 2 columns Basically, I want to delete value 1 or 2 on column "A" and "955.46*" on column "D" i'm getting run time error '424' what I'm doing wrong?? (line "If Not IsError(.Value)...
  8. R

    Require formula

    Hello, I have data in rows I need a max formula for the last 12 consecutive months.Formula should calculate value more than zero and the calculation should start from right. Formula result should show For RON its 24 & Jude its 9. <tbody> J F M A M J J A S O N D J F M A M J J A S O N D J F...
  9. R

    Require Macro

    Hello, I need a simple macro code for the below In Column "L" I have "TRUE" & "FALSE" . I need a macro where it should insert a new row below every "TRUE" value. Thanks, Ron...
  10. R

    Formula help

    Hello, I have a below data in columns <tbody> ron 4 shawn 3 max 8 jack 2 rex 1 swan 12 </tbody> The next column I need a output showing the maximum. example - in the 1st row the maximum number is 8 but I need the ouput as max, same with the 2nd row, maximum is 12 and I need...

Watch MrExcel Video

This Week's Hot Topics

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
Top