usd

  1. J

    VLOOKUP vs. INDEX/MATCH on variant array

    I have a multidimensional array with 'x' rows and 3 columns of data, and I'd like to perform a VLOOKUP on the array information stored in memory rather than calling the worksheet each time. I'm just not sure how to write the code to perform the VLOOKUP using INDEX/MATCH, and repeat that process...
  2. C

    Subtract Cumulative Total until it reach zero with FIFO excel creation

    Hi, i'm trying to create some subtract formula, but no idea how should i do it, the table below would show the result i desire: <tbody> A B C D E F 1 DATE STOCK ITEMS NAME COST PER STOCK (IN USD) QUANTITY OF STOCKS CUMULATIVE/ BALANCE OF STOCKS REMARK 2 1/1/2019 XYZ USD 1 1000 1000 BUY...
  3. asivaraman

    Flag/highlight data based on specific data within the cells

    Hi, I am looking for a VBA code that can flag/highlight rows based on certain criterias. There are 3 distinctive part numbers in the below table, with multiple Distributor, price breaks and pricing. Each "price break" column is ranked based on the price. In this case, we keep EDAC as the...
  4. H

    SumIfs question

    Hello, I am trying to figure out how to create a formula that will feed into a different worksheet. I have most of it figured out but I am stuck at two parts. <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> AsOfDate BankId AccountNumber AccountName BaiControl Currency...
  5. S

    vba code exact match string

    Below is the beginning of my code, the only issue I'm having is that the below list when deleting should only delete on an exact match. So for example if I have 'carrier name' as a column header and 'carrier name 2' as a column header by the list below only carrier name column should be...
  6. R

    How To Autofilter Rows Based On Cell Value In Excel?

    Hey All, I'm having a nightmare with this seemingly simple task. I have several cells as below <tbody> <tbody> E USD E GBP E EUR 5 O USD O USD O USD </tbody> </tbody> And another table of data below with a frozen pane, A10:Z2500. Using an example of E EUR this data is in...
  7. R

    DAX measure to get rate from dislocated table

    Hi, I am struggling to return a result with a Dax formula. I have a Fact table that has some data Fact Table <tbody> Date Account Curr Trans Amt GBP Equiv USD Equiv 01/04/18 12345 EUR 10,000 9,000 14,000 01/05/18 12445 USD 15,000 10,000 15,000 01/10/18 12445 GBP 1,000 1,000 1,425...
  8. C

    A simple currency conversion one I hope!

    Hi everyone, Hopefully a simple one for someone but I cannot get it to work! I’m trying to convert all currencies on a spreadsheet to USD Column B has the base price, Column C has either (GBP,USD,EUR). What I am wishing to do is in column D show a USD price only , so if column C says GBP or...
  9. A

    Macro to Sum Columns / Exclude Certain Criteria

    Hello, I am wondering if anyone may be able to assist me in creating a VBA macro. What I am looking to do with the below is sum up the "Long Total" column, but only where the "Long Curr" column shows USD. Anything else I need the long total column to be zeroed out. The last piece is I need...
  10. G

    Multiply 2 columns based on condition then sum them up

    <tbody> A B C D E F 1 Chocolate EUR 8 BRL/CAD 3.1430 2 Coffee bean BRL 5 EUR/CAD 0.6760 3 Apple USD 3 USD/CAD 0.7560 4 Macaroon EUR 10 5 Candy USD 2 6 Total CAD </tbody> I have two tables as shown above. I want to find the total in CAD according to their local...
  11. F

    VBA - Avoid repeating an IF formula for each cell and apply to whole column?

    Hi, thanks a lot in advance for the help I have a simple macro working for the below table: A B C D <tbody> Transport Amount Currency USD Flight to Narita 300 USD Shinkanzen 13,080 YEN </tbody> If...
  12. B

    Macro to add additional rows for orders paid in Multiple currencies

    I need to develop a macro that is currently beyond me. Here is the scenario. The company will sometimes book an order that will be paid in different currencies (e.g. USD, GBP, EUR, JPY, AUD, etc). We add a commission rate for each currency we're going to pay the rep on. On a line we might have...
  13. B

    Macro to add additional rows for orders paid in Multiple currencies

    I need to develop a macro that is currently beyond me. Here is the scenario. The company will sometimes book an order that will be paid in different currencies (e.g. USD, GBP, EUR, JPY, AUD, etc). We add a commission rate for each currency we're going to pay the rep on. On a line we might have...
  14. R

    looking for right formula

    Hi Everyone, i'm setting up sheet to include as much info as poss without needed to re type date from one sheet to another etc. eg if one cell has list data varification for currency EUR GBP and USD. lest say cell C3 for another column/cell (H3) i need to have formula to say if C3 is EUR or...
  15. E

    VBA / Macro - Sort by ROW - Specific Requirement

    Dear Community, I have a daily report which is currently manually sorted. I would like to do this automated with a macro if possible. The "Row Headers" look something like this: <tbody> 302(USD) 304(EUR) 305(USD) 307(USD) 308(USD) 310(GBP) 311(USD) 342(EUR) 368(EUR) .... </tbody>...
  16. P

    Copy & Paste to another sheet

    Hi Master, Need your expertise in building a VBA to copy the data from Sheet 1 and transpose paste in Sheet 2 – As per the below format: Sheet 1 (will have a pivot in the below format) - Data needs to be copied from this sheet: <tbody> A B C D ID GBP USD Grand Total 12345...
  17. P

    Copy data from one sheet to another

    Hi there, Need your expertise in building a VBA to copy the data from Sheet 1 and transpose paste in Sheet 2 – As per the below format: Sheet 1 (will have a pivot in the below format) - Data needs to be copied from this sheet: <tbody> A B C D ID GBP USD Grand Total 12345...
  18. T

    calculating my pipeline backwards

    Hi Everyone, I am trying to calculate my pipeline backwards. I hope I can explain clearly here. The premise is: If I start with 100 USD in my pipeline and I have a win ratio of 20% I will win 20 USD. This 20 USD will move to the next stage (stage A) where there is already another amount...
  19. L

    create and print files automatically

    I want to create and print files with the following logic : file 1 : keep row 1 Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpart and add row 2 11814 30000 stock sell 28300 ATW ATWOOD OCEANICS INC US0500951084 US...
  20. A

    VBA code for summing up duplicates and delete duplicates

    Hi, I'm reading and using all the codes posted in most of the threads but I still found difficulty in running smoothly in my worksheet. May I ask for your help to formulate a code that will sum up all the duplicates in Criteria Range- column I (it will not include blank spaces) and sum range...

Some videos you may like

This Week's Hot Topics

Top