comp

I am trying to figure out the best way to only extract certain data from a download from our rating system. Below is an example of how the data is downloaded from the system VEH 1 - 2000 INTERNATIONAL 4000 4900 STRAIGHT TRUCK {1HTSDAAN7YH256306} City State Territory Stated Amount Cost...

E F G H I Company A Comp B Comp C $1.00 $.30 $.24 =min(E2:G2) Comp C $.53 $.62 $.51 $.40 $0.00 $.46 The simple MIN...

I have 2 tables: Table1 - FG parts with QOH <tbody> A B 1 FG FG_QOH 2 a 1 3 b 2 4 c 3 5 d 4 6 e 5 7 f 6 </tbody> Table2 - BOM of Comp related to FG and CompQtyPer <tbody> D E F 1 FG Comp CompQtyPer 2 f x 2 3 e y 2 4 d z 2 5 b x 3 6 c y 3 7 a z 3 </tbody>...

Hi I have a problem that I'm not able to overcome. I have the data as shown below (dataset much larger, but follows the logic below). - Cells A1:C1 are merged, so are D1:F1 and so on - I want to show a graph with Months on the X-axis, and Market Share on the Y-axis, and then different lines...

Searching on this topic brings a lot of results and the ones I've dug through always seem to have something about them that's just far enough away from what I'm doing to not help out. That, and jet lag from a round the world trip yesterday is kicking my butt. Would appreciate some assistance...

Hello! I have a sheet that has many columns with many criteria per column to reference. Then I am rolling the data up to a topside page to subtotal all of the criteria required. My issues is I could not think of a quick way or nested formula way to accomplish this. Instead I am using a...

Hi All I am looking for some help with a formula. I have a simplified table below: <tbody> NAME START DATE END DATE CATEGORY George 14/04/2018 Comp Jeff 09/07/2018 08/09/2018 Comp Bob 01/02/2018 15/05/2018 Comp Cathy 01/07/2018 MM Jenny 03/07/2018 10/07/2018 Comp </tbody> And...

I am trying to calculate a live sales comp for 2017/2018. In order to do the basic comp calculation, I need to sum 2017 sales up to the last corresponding sales input line for 2018. In this example it would be 2000. If I entered sales for 6/4/2018, the new aggregate sum for 2017 would be...

I'm trying to create a second table from an original table based off of non zero values indicated in the third column of the original table. I need to do this using vba / macro, here is a visual of what I need to do. the range of the table is cells G10 to I47, this is just a snippet. I was...

Hi, I have a problem and can not figure out that if there is a solution (mathematically possible) or not. I tried to demonstrate the problem below. I have tried so many things (goal seek, solver or analytical approaches) but could not find a solution. Now I am thinking that there is no solution...

Hi Guys, If anyone knows of a good online example or has their own example they'd be willing to share, I'd really appreciate it. Here's what I'm looking to do: I routinely compare businesses for feasibility studies. Some studies have 4 comps, some studies have as many as 7-8. What would make...

Hi Excel Experts, I am trying to decipher the below mentioned formula but unable to understand the function of " Lookup(1000," !!! I know in the lookup formula it is the lookup value but the sheet i am working on is text only & in an unstructured format. It helps to categorize different...

It’s been 10 years since I’ve last used Access so I’m one of those folks hoping an experienced user can quickly build me the basic database and I can take it from there. My students have to do practical experiments. For each student, I have to record whether..... <tbody> Comp 1 Comp 2 Comp 3...

Hi all, I have a spread sheet with c.20k rows of data with 8 columns in the following format: Comp1 Cost1 Comp2 Cost2 Comp3 Cost3 Comp4 Cost4 Under the Comp columns there are multiple (c.100) codes. I'm trying to locate (for each line) the 1st 'Comp' column that does not contain U7,UN or...

Dear all, as I need to find out the top 3 Remedy in the list item, it show PAINT, FIX AND 0... but when it comes to zero, it will count a value for zero, but I would like to exclude 0 in my value data can anybody help, thanks, my calculation for Column No is...

Dear all, I have try the below calculation method to count the highest value but it failed. it can only count the top 1 instead of top 3, suppose the top one in column E should be FIX and to find the Top 3 highest value which match FIX in column F should be SINK, SHOWER, FURN, but I failed, can...