york

I have a spreadsheet with 15 worksheets containing data for 21 cities. Some cities have multiple entries on their worksheet as they are separated by either north, south, etc... or uptown, downtown, etc... New York - Bronx New York - Queens New York - Brooklyn New York - Staten Island as an...

I have about 150000 rows of data like below. I would like to look up a bold value. For instance if I have New York in cell D1, I want to bring back all of the values underneath New York so it would return <tbody> Jay Fred Mary Ted Sam </tbody> Here is what the data looks like below...

I am trying to pull data from one worksheet into another worksheet. I think using Index/Match is the way to go, but I'm not sure how (I tried Vlookup and don't think that's the right formula). Worksheet one has numbers in column A (say 1 to 10), and in Column C has the data (Town visited) I...

<tbody> Location # Month Year NYC 5 July 2019 Florida 3 August 2019 Mass 1 October 2019 </tbody> I have a workbook with the above information: I would want it to look at column B, (#) and then insert 5 rows where the #= 1, so 1,1,1,1, instead of the 5: <colgroup><col...

Hi I am new to VBA. and need a lots of help to make it work. The first Sheet (Everything) got everything, and when i put a value under department like Miami then i want to copy the entire row to my Sheet called Miami. And so on. I have googled it and watched some youtube, but i cant figure out...

Hi from partially cloudy 9 Degrees C York UK, I am struggling with conditional formatting. This is what i want to achieve.. Phrase "Hotels York" - Wk 1 Position 5 | Wk 2 Position 1 - (Promotion Green Arrow Up) Phrase "Bed & Breakfast York" - Wk 1 Position 2 | Wk 2 Position 2 - ( No movement...

Hey all, If someone could help me with this I would really appreciate it. I have a workbook (named Database) which contains 4 worksheets named Main, Leeds, Bradford, York. Ideally I would like to create a drop down list in Main which lists the other worksheets which when selected will...

I currently have a worksheet that in Cell D9 is an index match formula. I am looking to filter the data from A16:A133826 based on the result of D9. Example: D9 = New York Filters all results of New York that appear within the range of A16:A133826. I don't know where to being without...

Hello, This is my first time using this forum so please be gentle. Your time and help would be greatly appreciated. I've built a list of all zip codes in the US with their corresponding organization code, of which there are ~100. A total of ~42k rows. I now need to group the data in a...

Hi, I am after a lookup formula to bring across the freight cost to give me a total cost of deliverys? Please see below table. <colgroup><col width="64" style="width...

Hi all, first post - thanks in advance for taking the time to take a look. I've looked and looked for an answer to my issue but no luck, hoping somebody can please help. My file looks like below but with 65k rows. <tbody> Hotel Name Location Best Western Washington The hilton new york...

Hi everyone I have a table in A1:D9 in which a unit is plotted for each person against various locations. Cell G1 is a data validation/drop down in which you can select a person from the table (in the example below I have taken Person 2). The formula therefore needs to reference cell G1. I...

Hi All, Need a help in capturing data from another spreadsheet. I have two files 1. File A (1200 rows) <tbody> Name Exchange City Address1 Address2 State Country Postal Abe John CBOT New York Mark Twain CME Singapore </tbody> 2. File B ( 300 rows) <tbody> Address1 Address2...

I have a column of information and would like to find a way to translate it into rows using VBA. Every 3-7 rows in my existing column has a cell "New Record". I'd like the information below that cell to be laid out in a new row. Currently: <tbody> New Record 4756 John Doe 123 Street...

Fairly new to excel. Wanted to know if it is possible to have a formula that looks at a particular column for specific value (i.e. City Name) and for every instance of that it would display a value in another cell on that same row. For example: Each row has the following fields: Date, Name...

Hi for the sample table below in excel: <tbody> New York Japan China Chicago Product A 3 5 1 2 Product B 9 6 7 4 Product C 2 9 1 4 Product D 1 3 2 5 </tbody> <tbody> North America (New york &Chicago) Asia(China&Japan Product A Product B Product C&D </tbody> I have a...

I have data exported from a POS that is listed downways with common Invoice number. What i need is to have it listed on a single row for each invoice. Current data <tbody> District Invoiced At Sold On Invoice # Sold By Customer Product SKU Product Name Tracking # Refund Qty Gross Profit...