france

  1. R

    Conversion of column list to comma delimited string

    Is there a macro I can use that would convert this... <tbody> USA Germany Chile France Turkey Indonesia </tbody> to this.... USA,Germany,Chile,France,Turkey,Indonesia The column will have always data in Column A and rows could vary in terms of data input.
  2. J

    Convert Data in Sub-Total Format to Pivot Friendly

    A program I use outputs data in a non-pivot friendly format. It has already grouped the data with different levels. I am trying to convert this data into data that is pivot table friendly. I currently have data like this where Location is always filled out and will have at least one (but...
  3. W

    Creating an order

    I'm looking to create a formula that 'rank' an occurrence in the file, I guess similar to the count function but rather than the number of times it appears, I want where it appears in that range of occurrences. <tbody> Column A Desired Result <tbody> Belgium </tbody> 1 <tbody>...
  4. D

    Count Visible rows, no matter if are blank ot not blank in a table

    Sa I have a Table (eg: A1:B50) Imaging my Column A:B'cells are most of the time empty If I filter by Column(A, to show blanks and = to France, I count 15 rows If I filter by France I only count 10 But any formula to get 15 ?? I do not care about France, I would like to Count How many rows I...
  5. S

    Keeping Appended Data In Sync After Data Connection Refresh

    I have a table with two columns in Excel: <tbody> A B 1 United Kingdom London 2 United States of America Washington DC 3 France Paris 4 Spain Madrid 5 Japan Tokyo </tbody> Column A is populated by an external data connection from a CSV file. Column B is data that I then manually...
  6. G

    Multiply if

    Hi all, I have tried to check for solutions but in vain. Hopefully someone can help :) I have a 2 different sheet ("sheetA", "sheetB"). SheetA <tbody> ITALY 100 FRANCE 200 UK 300 ITALY 20 FRANCE 30 UK 60 </tbody> SheetB <tbody> IRELAND 2 UK 5 ITALY 4 FRANCE 8 NORWAY 3...
  7. A

    Remove duplicates and match two columns

    Hi ppl, I need to convert the Table 1 to Table 2 as shown below. Is it possible? Table 1: <tbody> Country Product France A France B France C Germany B Germany C USA A USA A </tbody> Table 2: <tbody> Country Product France A, B, C Germany B, C USA A, A...
  8. M

    formula

    Hi I have 500 rows of data, in column B is a Task and column C has a location or is empty The information held in column C is located in column B. Ideally I would like to check each cell in column C and compare to all cells in Column B, if their is a match I would like Column D to hold a value...
  9. B

    Return count of unique records in one field, based on sum of another field

    To illustrate the question I have created some dummy data below: <tbody> Country Product Sales Volume France Shoes 10 France Shoes 20 France Shoes 30 France Boots 5 France Boots 5 France Hat 10 France Hat 5 </tbody> I want to create a measure that will return the number of...
  10. A

    Copy rows from one sheet to another based on a list

    Hi I am trying to create a macro which would copy the entire row of data from one sheet based on the a list of values in another sheet, additionally it should remove any rows which might have the value of not required. The sheet 1 will have the below values :- <tbody> abb bcd...
  11. D

    Count number of unique countries per company

    Hi, I have a table of unique emails with corresponding company and country. I want to have a column which counts the number of unique countries a company is active in. Column D is where I want the count to be in. Can someone help me with a formula for this? <tbody> Email Company Country...
  12. G

    Showing sub items for only certain items in a Power BI table

    Hi all, I have data for countries and I want to group the European ones and to show a subtotal. So my table rows would be something like. Europe UK France Germany Italy US Japan China I easily created a Europe group through right clicking in the field list. However, when I put...
  13. P

    Copy subtotal cell to rows below

    Hi, I have some data which looks like below: <tbody> Name Country Code Germany Germany DE John Germany Nancy Germany Fred Germany Brian Germany France Danny France FR John France Nancy France Fred France Derrick France </tbody> I want to try and find a way of...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top