dealer

  1. D

    Random selection from range where the selection is constrained of whether or not another cell on the same row ISTEXT

    Dear folks, hope that all is well. I have a frustrating problem with a random selection from a range given that another cell on the same row is text/not blank. Below table might help to explain the circumstances. What I would like to do is to select a row completely random, constrained on the...
  2. Skybluekid

    Calculate worked hours based upon criteria

    Hi All, I have a sheet where it records a time when one of our trucks goes into a dealer. It also records the time the trucks leaves the dealer. I would like to workout how long the vehicle has been stood in the dealer. That is easy to do, but in order to be accurate, I would like the...
  3. D

    If Cell B = text in col C, input value from col A

    Hello everyone, I wanted to know if there was a formula or macro that I could use which would look up a string of text in column B:B and if found in column D:D return the value which correlates to its row, but the value i want is in column A. Its hard to explain but i am attaching an image...
  4. B

    Help creating a formula that solves for highest and lowest X while maintaining values of A and B

    Hello all, So this is probably a lot easier to solve than i am making it but i need a formula (or VBA) that will solve for the "Dealer Price" (in blue)...
  5. T

    VBA Create a table

    Hi Guys, I have recorded a macro to create a table which works fine but i'm wondering if there is a way to change the range so it looks to the last row in column P rather than the selected range. Hope this makes sense. Thanks Sub CREATE() Sheets("Bethan").Select Range(Selection...
  6. S

    VBA- how to dynamically extract a list of values from a column range given a condition

    <tbody> A B C D E F FUND CODE FUND CODE DEALER CODE DEALER CODE DEALER CODE AAA ABA 123 345 678 BBB BAB 987 654 321 CCC C123 111 222 333 </tbody> Above table is in "Fundata List" Tab: <tbody> Hi, I would like to write a macro that will extract all the dealer codes from a tab...
  7. Y

    Need a formula

    Good day, I have a spread sheet that consists of two sheets, sheet one has my sales agent in colum A and dealer codes from B-L, sheet two has die dealer code in colum A, dealer name in colum B and in Colum C I need to find the correct sales agent from sheet one for the specific dealer Please help
  8. H

    Sum of data of a row with criteria of 2 other rows. Excel 2003

    I have a sheet that looks something like this: A B C D 1 Brand Dealer Type Amount 2 Lesli HD Cake 2 3 Rubro PL Cake 1 4 Zena PL SS 3 5 Zena HD Cake 2 6 Rubro PL SS 12 Totall...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top