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