gbr

  1. N

    Convert Bank Statement to Excel

    How can I split this into columns This is the columns I would like please Date of transaction Date entered Description Amount £ 13 JUNE 14 JUNE PAYPAL *AQUACADABRA 35314369001 39.90 13 JUNE 14 JUNE IDEN PARK SERVICE TONBRIDGE 4.19 15 JUNE 17 JUNE WWW.PARKMOBILE.COM INTERNET 3.40 17 JUNE 18...
  2. A

    MODE for Text including Count IF...HELP!

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody> Year Q1 April Busiest Team A Most Common Nat B Most Common Nat exc GBR Most Common Nat (Alpha Team) Most Common Nat exc GBR (Alpha Team)...
  3. A

    Mode IF & Count IF excluding specific Value

    I am creating a sheet that counts the number of applications received from specific Nationalities excluding GBR (British). I am currently using the below formula to return the nationality exc. GBR MODE for the year, however i'm really struggling to alter this to only count data where a specific...
  4. B

    Identifying all rows where conflicting entries exist

    Hi, I'm looking for a way of identifying all entries for a Patient ID where the Patient ID's have conflicting "Country of Birth" entries recorded. Entries for each Patient ID may all say either ZZZ or GBR, but they cannot say both. The problem with identifying them being that: Rows may...

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