consistent

<tbody> a b c d 1 5 2 7 100 2 10 4 14 200 3 15 6 21 300 4 2 8 28 400 </tbody> If I have a table like the one above with column and row headers...NB. these are not the Excel headings, they are specific to the table and could appear anywhere on a worksheet. I...

Hey folks, still kind of new to this – and I may be a littleoverly ambitious with my enquiry. I have five .csv workbooks, entitled R1 through R4 and PF(data is in Sheet1 in each). Each workbook has a headings row and the datapopulates a consistent number of columns (A through N) but variable...

Good morning! I am trying to teach myself how to use Index Match to address a request from my VP and am running into an issue. I think I know what's causing it but want to be sure. I'm creating a summary section with multiple types of data and the columns aren't consistent. I have a...

Hi I'm looking for some advice/ help. I'd like to import data (betting odds) from a website into Excel - admittedly I have no idea where to start as I've never attempted anything like this before. Here's what I'm trying to achieve... Source of odds; Oddsportal (http://www.oddsportal.com/)...

9X60X11 I have variations of dimensions such as the string above in my cells. Their position is not consistent. The only consistent rule is that the word I want to be rid off in all my cells contains the letter x, but how?

I am working on a very large genealogy project. I need to be able to extract date, first name of person and parents name. the data will appear like this (Very consistent spaces) in A2: January 2 Joey Joseph Schmoe (Joe & Josephine). I would like 3 separate cells. B2:"January 2", C2:"Joey", D2...