usd

  1. H

    Macro find and copy text by three conditions

    Hi, I'm trying to find two values in two different columns. From one column "Ac Desc"(D) I need to copy only rows where met such values among text "2603", "3739" and do not met "UAH". And in anothercolumn "Record Stat" (H) I need only rows with value "O". Macro should copy whole row which met...
  2. S

    To extract specific numbers from a range

    Dear team, I want to extract specific number from below , the below text when copied in excel comes in 6 rows, the criteria is to extract the INR FARE 44500 (only numbers required) from second line and Ignore the "USD" line, also sometime the second line comes as first and the first comes as...
  3. J

    Sumif/Sumproduct

    Hi On Sheet 1, I have rows of data as follows: Column A: Name of client Column B: Amount (value) in original currency Column C: Currency Column D: Transaction Date Column E: Settlement Date The Name of the client may appear on multiple rows and may have different currencies. On Sheet 2, I have...
  4. M

    Sum the amounts of lines with the same criteria

    Hello Guys, I need your support how to build the code properly to fix below problem. I need to sum the amounts of lines, where "Name" and "ID number" are the same. Below you find an extract of table, normally its much bigger about 500-600 lines. <tbody> Name Code ID number Amount Ccy Date...
  5. P

    Pull specific data from API feed

    Hi, I am trying to build a formula that uses some data pulled in from a webservice api. This is the forumual =WEBSERVICE("https://api.coinmarketcap.com/v1/ticker/ethereum/") What i want to do is populate a cell with the current price in USD which is displayed as "price_usd";"343.114" I have...
  6. B

    VBA to clear contents, paste into another worksheet based on criteria

    I have data in a tab, called "SourceData" in the following order: <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> Curr Company Department Account Account Name Jan Feb Mar Apr USD 1 100 55100...
  7. J

    Power Pivot: Slicer not working when using IF with ISBLANK

    Hi I have two slicers one called Organisation and the other called Division. When I filter based on Organisation the Division list does not change and shows all divisions and does not filter just the divisions that relate to the Organisation. I have used the below measure but this does not...
    • jon999
    • Thread
    • called division filter organisation usd
    • Replies: 2
    • Forum: Power Tools

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