england

Hi Mr Excel Community, I would like to unstack this data using Power Query in order to have a clean list to pivot. Desired situation > To have a table with the following headers: Market, Items, Years, Month, Values. Change vs prior Year will be filtered out of the data sample. I know that I...

Hi In column "L" I have a list of cities/countries: Toronto, Ont., Canada Montreal, Que., Canada Toronto, Ont., Canada Manchester, England, United Kingdom New York City, New York, United States Frankfurt, Germany Abuja, Nigeria Frankfurt, Germany Manchester, England, United Kingdom Doha, Qatar...

Hi, I can get so far with my formula but not sure how to finish it off. Please help. I have 4 tables, Table 2 / 3 and 4 have data - the first table has the initial criteria and the formula next to it to bring back the result. <colgroup><col><col><col span="3"><col><col><col...

I have a sheet with the following: A: State B: Leads (every row has an create date) C: Product (A, B, or C) D: Purchased (0=No, 1=Yes) On another sheet I'm trying to create a chart with <tbody> Product Region Leads Customers 1 New England X Y 1 West 2 East 2 West </tbody>...

Sorry for off topic. I asked before how to do text to column in vba for a text showing below. I got a reply which worked perfectly but I could not find the post anymore. Any help would be greatly appreciated. They are all in column A <tbody> /37562094231 William Cambridge1 London England...

I want program for below condition 1. filter to column "D" for blank . 2. Replace all blank cell in column "D" with Not OK. 3. Clear Filter . 4. filter to column "D" for Not OK. 5. filter to column "A" for Pending. 6. Replace all these pending As Pending - Not OK Example is Row Data <style...

Hello, if I was using the following formula to search for cells containing the word "land" how would I add to my formula to exclude "England" but return "Scotland, Ireland" etc please...

Hello Everyone, May I request for your assistance to create a formula for Column C (Delivery Status) to match Column E. <tbody> Country Fruits Delivery Status Delivery Status Country Fruit England Apple Yes Yes England Mango US Orange No Yes US Apple No Japan Orange...

HI I'm looking for some help with a rank issue I'm having. I need a formula that will rank based on a criteria (Area) and uses 2 tie breaks. So for example if the are 2 scores of that match in Central England then %1 would determine the highest rank, if the score and %1 match the %2 would...

Hi all, i'm working on a works project but cant get my head around a problem. in the Training, sick, working and holiday cells, where I want to count the number of staff I use the below formula, which al works well. However, when I filter the regions into Scotland or another region, the countIF...

Hi,　 I have difference info from Sheet1 & Sheet2 and I need to combine them into Sheet3. <tbody> sheet1 sheet2 Item Reading Item Name A 10 A China A 70 A Hong Kong A 51 A Taiwan A 45 A Australia B 12 B Korea B 11 B USA B 48 B Japan C 142 C Iceland C 21 C...

Hi all I have a vba routine which i use to import some external data and drive some reports. As part of the process, i need to add some validation to the data that is being imported to check that each of the following appear n times (e.g. 7): They would appear in column B, and my data range...