zzz

  1. V

    If Elseif else statement

    How to write a VBA code to get the below output. Thanks If Column A = AAA , Column C = XXX , Column E = YYY Then column F = Yes If Column A = BBB , Column C = XXX , Column E = YYY Then column F = Yes If Column A = ZZZ , Column C = XXX , Column E = YYY Then column F = Yes and if Column A is...
  2. K

    Insert lines and fill via VBA macro

    Hi there I am hoping for your help in creating a macro that will automate a repetitive piece of work I am doing I have a sheet with data in column A and B, both having headers. Column A contains a name and be B has a reference to an account. Some have references to multiple accounts and are...
  3. W

    Power Query List from "AA" to "ZZ" or "AAA" to "ZZZ"?

    I saw a great video yesterday that allows me to make a list within PQ from ExcellsFun YouTube that can make a list from A to Z. I then Tried to make a List going from either AA to ZZ or AAA to ZZZ. I created a Blank Query that simply had ={"AAA".."BBB"} however it didn't like that. Is there a...
  4. M

    Advanced Find and Replace Required

    Hello Guys, I have two scenarios to workout. Both are almost similar only small differences. I am using simple find and replace for this, but now i am having new issues. Please go through the following scenarios. Scenario 1 The macro should read the cell C3 and delete that value in the last...
  5. C

    Replace only whole word

    Hello, I want to replace only whole words in a cell Also, I do not want to use Replacement, I want something I can use with Arrays The function does a good job of finding only the whole words but is there a way to get it replace the whole word with the MatchExprValue Ex cell value =HUD...
  6. S

    Unique Records Duplicating

    Hi All I'm an OK user of Access (not VBA) and seeking some assistance. I have a query that is working out the distance between postcodes in the UK. I have for example, 16 unique postcodes in one column of data, and another 16 unique postcodes in another column. I was expecting to get 16...
  7. N

    VBA printing on one page issue

    In the following code I have 'FitToPagesWide' and tall = 1, but when run, it still shows up on two pages. What am I missing here? Much thanks for any help. Sheets("Original").Select Do Until ActiveSheet.Name = "zzz" ActiveSheet.Next.Select RowNum =...
  8. A

    Most frequently occurring word/phrase across multiple columns

    I have an excel sheet where equally spaced columns starting from AD (AD, AI, AN, AS, AX, ...) contain a string. The string can be anything from a set of 4 pre-defined strings. Requirement - Find the string that occurs most frequently in these columns. Example AD -------- AI ---------- AN...
  9. 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