park

  1. G

    Park Run Data - Scotland

    I have created a query to pull all the park run data from all the scottish park runs which works ok it uses 43ish urls in a table (a few tables as website didn't like all together) like below https://www.parkrun.org.uk/standrews/results/latestresults/ I get all the data coming through fine...
  2. A

    Countif Criteria 1 and Criteria 2?

    Hello, bpml = WorksheetFunction.CountIf(ws_data.Columns(8), "Klik Park" And ws_data.Columns(11), "Field") This isn't working ... Can someone help me accomplish what I thought this would do. I'm trying to get a count of all the values in which column 8 = "Klik Park" and column 11 = "Field"
  3. P

    Find and count all cells with same date that contain some/most of the same text string

    <tbody> A B C D E F DATE FREE TEXT ENTRY FORMULALEFT FORMULAMID FORMULARIGHT FORMULAMID 09/01/18 234 park st northwest pl1235 =LEFT(B3,10) =MID(B3,5,11) =RIGHT(B3,10) =MID(B3,6,8) 09/01/18 pl1235 park st nw 234 =LEFT(B4,10) =MID(B4,5,11) =RIGHT(B4,10) =MID(B4,6,8)...
  4. D

    parse 7 digits after (, but only if numeric

    access 2010 I need to parse the data for the 7digit numbers within a string. The digits will always be 7 in length. Some data in () are not numbers. Some do not have ending ). example data: Park smith (sam) Park miller 23 WT 456 Bisa Keepan (2345678) Ington (3456789) Untom (3245678 I...
  5. bencar

    Explain Why this Pivot Table is Layed Out this Way

    Hi guys, Trying to figure out why this pivot table is layed out the way it is. Here are my 4 questions. Below that is the exercise and its info. 1. Why is 'design' in the column area? 2. Why are 'amusement park' and 'roller coaster' in the row area? 3. Why is 'type' in the filter section? 4...
  6. D

    VBA array exercise

    Use the data in the ‘Data’ worksheet of the workbook “VBA Training Exercise 2” (attached image) and segregate it on the basis of ‘Type’. Please follow the below points: Find unique ‘Types’ of Roller coasters in the given data. Add new worksheets in the same workbook and name them on the type...
  7. G

    Combining a RIGHT and a LEFT formula?

    I would like to combine: =Right(A1,LEN(A1)-FIND("-",A1)) and =LEFT(A1,LEN(A1)-4) To Result in: WINTER PARK From:ORLANDO RV-WINTER PARK, FL I need to drag down the formula to work with multiple locations, thus the FIND "-" Many Thanks!
  8. M

    MID / SEARCH error on the words "Spark" and "Park"

    Why does my formula in B5 and B6 break with the words "SPARK" and "PARK" (regardless of upper/lower case)? As you can see, replacing SPARK with SARK works fine. I think the issue lies in the MID part of the formula because it generated a result when I just used the SEARCH and LEN parts. Excel...

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