aud

  1. E

    Lookup data from Horizontal set of data

    I have Horizontal tables of data. <tbody> AUD EUR USD EUR INR EUR AUDA 150 100 USDA 67 90 INRA 30 80 AUDB 200 150 USDB 117 140 INRB 80 130 AUDC 250 200 USDC 167 190 INRC 130 180 </tbody> Explanation of above table: 1) AUDA, AUDB, AUDC, USDA, USDB, USDC, INRA, INRB &...
  2. A

    IF statement

    Hi guys I have a simple one for you I think. I am just not familiar enough to make it work although I think I am close but obviously not close enough. I have 3 columns, H has letters and I has $ amounts and L is blank H6......................I6.......... L6 AUD...
  3. G

    Currency conversion formula

    Hi, I am trying to convert currencies and need some help with a formula. If a cell in a particular column contains a specific word eg: AUD, then divide the figure in the corresponding cell in the next column by 1.35022. Thank you in advance.
  4. K

    Add column after each different name.

    Hi Guys, Using Windows 7 & Excel 2010. I have the following list : <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> List Currency Status Apple AUD V Apple AUD V Apple AUD V Pear AUD V Pear AUD C Durian...
  5. K

    Automatically Change to Correct Currency

    I feel like the answer is NO but I thought I should ask: If A1= list of currencies (USD, AUD, CAD, EUR, GBP) Can A2= a number with the correct currency symbol from A1 Example: A1= USD A2= $300 A1= AUD A2= AUD 600 A1=CAD A2= CAD 100 A1= EUR A2= €500 A1= GBP A2= £240
  6. B

    Using VBA to Copy/Paste data from one worksheet to another

    Hello Excel Community, I’m currently working on a university class scheduling project and am in need of some VBA coding assistance. I would like to set up a system that can read data from a “Master” list and copy/paste specific information from the master sheet to another sheet based on...

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