brad

  1. J

    List column headers where value is true

    I have a list generated from another program of all of the locations one person worked at. It looks like this. The order of the locations is listed randomly: <tbody> Gary Linda Marissa Brad Xavier Lincoln Wausau Annapolis Laredo Bethesda Laredo Bethesda Waco Annapolis St Louis Wausau...
  2. D

    Formula or Macro for comparing duplicates and creating a sum

    <tbody> Name Number Amount Total Brad Jones 1234567 35 Brad Jones 1234567 19 Brad Jones 1234567 10 Joe Bob 9999999 55 Steve Smith 1111111 60 Steve Smith 1111111 40 </tbody> Hi, I am looking for help to make a formula or macro for this spreadsheet. I am not great at excel...
  3. H

    Dynamic Lookups

    <tbody> Name Area 1 Area 2 Area 3 Area 4 Area 5 Area 6 Area 7 Area 8 John Y N Y Y N N N N Brad Y N N Y Y N N N Nate N N N Y Y N N N Luke N Y N N N N N N Mark Y N N N N N N N </tbody> Hello, I am looking to drag down dynamic...
  4. P

    CountIF Multiple Criteria

    <tbody> A B C D E F Name Store # Number of Visits Name Count of Visits Joe 1542 3 Joe 3 Joe 1872 4 Brad 2 Joe 1932 3 Sarah 3 Brad 5323 2 Brad 2142 3 Sarah 6745 0 Sarah 0896 2 Sarah 3242 3 Sarah 5735...
  5. R

    Lengthy SUMIFS Formula Assistance

    Hi all, I'm working on a tracking spreadsheet for # of contracts written by salespeople, and I'm having difficulty with the formula to add up the number of contracts per salesperson based on a given date range (partial credit for split sales). It seems like it has to be something simple I'm...
  6. L

    Find in a Range and return a value

    I have a spreadsheet that has something similar to thefollowing:<o:p></o:p> <tbody> <o:p></o:p> Find this number in range A1:B4<o:p></o:p> Bring back Officer who issued Ticket (ticket assigned to)<o:p></o:p> A<o:p></o:p> B<o:p></o:p> C<o:p></o:p> D<o:p></o:p>...
  7. D

    Formula to find multiple results from 1 table source

    Hi, I have the following table; <tbody> A B 1 Alex 60 2 Brad 60 3 Chris 50 4 Dave 60 5 Elli 70 </tbody> I then rank 1 to 5 from highest to smallest. Using =LARGE(B:B,1), =LARGE(B:B,2) and so on down to =LARGE(B:B,5) According to the value of each ranked item in column...
  8. B

    If this, then that

    Hi, I would like to auto-fill a cell based on conditions. For Example: We have "Sheet1" with text 'Brad' in B3, and 'Secretary' in F3. (Brad is the secretary). So when I enter 'Brad' in any row in "Sheet2" (eg. C4), then I want the same row, in column D (eg. D4), to auto fill with 'Secretary'...

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