cars

Hi, I have had a look through but couldn't find the answer to my problem. I have a table that has the time a car drives along a road in each direction, I have got this into one column, so that you can analyse the gap between cars. I have attached an image...

Hi I’m a really stuck, I have a category list in EXCEL. I have a 35 categories, each with sub categories and each sub categories has further sub categories, a total of 6 levels. The amount of data I have to input manually is in about 15164 lines, over 6 columns. Level 1 = 35 Level 2 =...

Starting a new project. Curious as to the best way to construct the tables. One table will have the contact info in it. The second table will have the vehicle information owed by the people in the first table. A single person can own several vehicles. Person A owns 1 car Person B owns 2...

Hi there - I'm trying to create a pie chart that will only have two sections: the sum of the top 5 values, and the sum of all of the other values in the column. For example: Let's say I have a list of 15 cars - one part of the pie chart will be the sum of the 5 most expensive cars. The other...

I found some "cascading" combo boxes, but nothing that I could modify to meet my needs. Also there is lots of discussions on "INDEX/MATCH vs VLOOKUP". Its sounds like INDEX/MATCH is what I should be using. I have two worksheets (pretty simply stuff) worksheet1 is a "customers" list (cust...

I have out grown my current excel method and I have started to think a little more long term in the next phase. I now manage a number of customer's car collections, each with at least 6 or more cars. I currently keep a separate spreadsheet for each customer. When I make an improvement to a...

Dear I am using this formula but not calculating =SUM(COUNTIFS('Risk & Issue Log'!G:G,"Used Cars",'Risk & Issue Log'!M:M,{"15","16","17"},'Risk & Issue Log'!AA:AA,{"Open","In Progress"})) Could anyone help me over this Many thanks

Actually I am working on a model of charging load of electric vehicle. I am attaching a link to an excel workbook for your better understanding. Column B contains random time values, these time values can vary in number and depend on total number of cars. So e.g. total number of cars are 40...

Hi Guys, I have the following sheet (the actual one includes 1000 line in it), How can i use a sort formula to actually sort in a descending way for each category (i.e: Cars, Bikes...) Thanks. <tbody> Item Sales Cars 42 BMW 12 Mercedes 3 Renault 9 Citroen 18 Bikes 24 BMW 7...

https://imgur.com/5GlXgm2 Assuming I have my list of cars in column A. I choose a certain type of cars in column C, would it then be possible to generate a list of the remaining cars in column E, which I did not choose? I found something like this...

<!--StartFragment--> Needing a month-to-date conversion tracking formula (based oncampaign_name[B], date [A], and summation of clicks [C]), assume column A is spanning all days and months through the end of year. Simple enough, I know,..but for whatever reason I'm struggling with setting up the...

Cars can have the start point from everywhere in Region A, it is not set up in which point should a car start. That is up to the formula to decide what is the best point where to start. The last points that cars reach in the Czech Republic are areas with postal codes 3 and 4 as it is shown in a...

Hello, I have a Word file which includes some paragraphs and a few tables (3-columns, unknown rows). I need to revise those tables based on a table in excel. for example all tables have 3 columns of car's name, car's year, and car's price. but I have a reference table in excel that says some...

I have data values for given dates and I want to create a formula that will pull the value from column B based on the date in Column A. However, I would like to have the inconsistently formatted data in Column A be organized by month. Is this possible? the formula I am using for "avg cars per...

Hi all I need a formula that will count how many 16 SL and 20 SE cars were sold in 2016. just 1 figure adding the 2 cars together. Thanks in advance <tbody> <tbody> Typr of Car date sold 20 LX 01-Nov-15 16 SL 01-Dec-15 18 SE 01-Jan-16 20 SE 01-Feb-16 18 LX 01-Mar-16 20 LX...