america

Hello. I have the following table: Line1: Product | Minutes1 | Minutes2 | KAPPA Line2: Oranges | Africa | | 2 | 1 | 15 Line3: Oranges | Africa | 3 | 1 | 15 Line4: Oranges | Africa | 2 | 1 | 15 Line5: Oranges | S. America | 3 | 1 | 15 Line6: Oranges | S. America | 5 | 1 | 15 Line7: Oranges | S...

Hi All, I need help merging multiple rows which match certain criteria (i.e. cells matching for date, specialty, location and person) to produce one entry, for example <colgroup><col><col><col><col><col></colgroup><tbody> Date Time Speciality Location Person 15/04/18 morning TeamCap...

Hi All, I have a large database which I am working on and one part I'm stuck on is merging rows to give one result. i.e. here is some mock data: <tbody> Date Time Speciality Location Person 15/04/18 morning TeamCap Brooklyn Captain America 15/04/18 afternoon TeamCap Brooklyn Captain...

Hi Everyone, Having recently had a nightmare with dates being formatted differently in the UK to America I realised I could fix a lot of these problems if I had a US version of excel. If this is really hard long winded or dosent work very reliably then its no good to me, but does anyone know...

I have a list of data that consists of 3 columns Col A consists of values T1-T4 Col B consists of a region name (North American, Europe, etc) Col c consists of a numeric value I need to create a formula that will rank the above based on their value within their region with all T1 values being...

Hello. I need to count the number of donors who have contributed as of 09/30/2017 in the North America region Only. How can I do it? I am using the frequency and match formulas, but I don't know how to use it with multiple criteria, such as, dates and region. I have this data, Region/...