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:
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 _
Now what does IgnorePrintAreas:= False mean please?
where can I find what all of these mean?
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...
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)...
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.
I have a below data in columns
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...