how to use switch
hi,

i have two excel files, one contains currency rates and the other file contains the total price in different currency.

i will have to split the code and price from the total price column in excel 1 and based on the currency code, i have to multiply the total price (excel 1) and the currency ra…
hi,

we can achieve it using dictionary and regex as the following, for example.

[[img20210826-3]](https://aws1.discourse-cdn.com/uipath/original/3x/1/5/15ac27e697226a8b24138095a41afab6793c1ea7.png "img20210826-3")
[sample20210826-3.zip](/uploads/short-url/ih67hzfqzphmctipka8hxgoocrl.zip) (3.1 kb)

hope this helps you.

regards,
nothing missing - just different:

1.  transfers are still linked.  enter one side of the transfer and in the category drop-down, select transfer > [other account].  changing either of the two entries modifies the other.

2.  multiple registers at the same time.  you can have every register open at once in its own window.  only one register at a time shows in the main window.  just double-click the account in the left panel to open a floating register window.

3.  move transactions between accounts.  with both registers displayed, drag the transaction from one to the other.  if it is a downloaded transaction, you'll get a warning.  you cannot, however, move transactions between investment accounts. there’s a link on the checkout page about ryanair’s exchange rate, bottom left underneath where you enter the card number. if you click this link, there is a checkbox that you can untick which reverts the currency back to the original one you were quoted in Hi Djhenry,
  

  
When you right-click a sheets tab, you can select all sheets. When you have done that, you can insert a row and enter all the information and all sheets wil contain that information.
  

  
Best regards,
  
Trowa we generate 4 types of outputs form 8949 in order for the user to decide how he wants to file choose the option “i file with a tax tool” when downloading your tax report.

you should get 5 files:

[[image]](https://aws1.discourse-cdn.com/business20/uploads/accointing/original/2x/9/97fcba74d95d67a7eef8cdf94b2f0a7aad5e072d.png "image") i would do it like this:

https://www.advanced-excel.com/columns-to-rows.html welcome to mrexcel!

it actually works for me (see below). this appears to be a kind of rounding error. the way excel stores numbers causes some issues when you have decimals. it is a bit rare when comparing a cell to itself, but it can happen. you can try to use sumproduct instead, see column h.

efgh1valuescountifranksumproduct248737.76222336113.11333454287.76111f2:f4f2=countif($e$2:$e$4,">"&e2)+1g2:g4g2=rank.eq(e2,$e$2:$e$4)h2:h4h2=sumproduct(--(round($e$2:$e$4,2)>round(e2,2)))+1 Here is a link to assist you.


<https://technet.microsoft.com/en-us/library/ms178078(v=sql.105).aspx>


If you had done a web search with the question you entered here, you would have found multiple sites that give you the instructions use sections. the first page should be section 1. you can assign the master page elements to that section only. then all other pages will be in section 2, with a different master page with different elements. each section can pick up page numbering from the last or start at a new number. hi [@jitse\_b](/u/jitse_b)

welcome to the community !

yes you can, there are various ways to do so.

the simplest:

you may want to create a table with 3 columns,

key\_column, type text, value “k000” (or whatever you want, it doesn’t matter if you stick to only one comparison)

“material1”, type ref, source tabl… rates on get4x can be managed through the rates section on the dashboard, by going to rates > your rates, or digital storefront > rates.