lead

  1. M

    Index Error

    I have a large data set (87,000+ lines). There are duplicates in the data, so VLOOKUP will not work, and I've been using INDEX/MATCH. I've been running into A LOT of issues. I got the following formula to work - kinda. =IFERROR(INDEX('[Historic Lead Data_2019 09...
  2. T

    Lookup help, multiple columns

    I'm unsure what formula I need to return an adjacent value to the min value from a set of columns... My excel knowledge is very limited I have data in cells BC20 to CJ20 and down to BC136 and over to CJ136 I have numbers in every other column and text in between example: BC20 has pricing...
  3. bobgrand

    Average Lead Time Formula

    Hello all, I have an inventory list along with the lead time of each item. Can someone help me with a formula to get the 1 average lead time number for all items for each vendor. VENDOR A has 330 items - Average Lead Time for Vendor A 5.65 VENDOR B has 693 items - Average Lead Time for Vendor...
  4. P

    ALL not ignoring date filter

    Good evening from Spain! I am hoping to get some advice since I am stuck at a problem and can't seem to find a solution. I have a very simple model consisting of a fact table (emails sent: date sent, lead, category...), a calendar table and a Leads lookup table (referenced to the fact table...
  5. G

    Ranking based on text

    Dear members, My colleagues and I work together on projects each quarter. Each quarter there is one project Lead, and the rest of us (depending on our availability) are either a Support (i.e. we provide assistance) or else we're Passive (i.e. we're not really involved at all). Below is an...
  6. D

    Excel Table Cleaning Question

    Hi Everyone, I have an excel table with the same grades across a row (20/40, 30/50 etc.) Above that I have merged columns representing the data for each grade IE. Avg Lead Time. The customer is listed as a column. Can anyone come up with a cleaner way to represent the data...
  7. R

    Subtract number of working days, from a date

    Hi all, You've all been so helpful in the past, so I thought you might be able to help me out once again. I'm trying to work out lead times based on a cut off date, I need to subtract the lead time (Column B) from the cut off (Column C) to calcualte the last order date (Column D), however I...
  8. C

    Counting consecutive days based on current date...

    I'm looking for formula in "Consecutive Days Worked" column that will count consecutive days worked(1=worked 0=not worked). Challenge is employee cant work more than 13 consecutive days, so count needs to start over when it hits a 0, and be tied to current date. Thank you for your time...
  9. JenniferMurphy

    Conditional format on text field?

    I have a column of text values representing the number of weeks remaining before some deadline. <tbody> Lead Time 25 Wks 28 Wks 30 Wks 18 Wks 35 Wks 3 Wks 27 Wks 38 Wks </tbody> I would like like to highlight (fill color) the cells depending on the value. For example...
  10. W

    Invoice formulas. VLOOKUP or no?

    I am trying to build a new invoice spreadsheet for the company I work for. We are going from a day rate system to hourly. What I am trying to do is set it up with one drop down menu for our 4 level pay scale and another with a list of the dozen or so companies we work for with each of those...
  11. A

    Update query - power query

    I have a table of customers with an allocated sales lead - I have a table of transactions for customers. I've the relationship set up in power pivot and the salesman flows through no problem. The issue I have is when the allocated sales lead changes. The pivots give amounts by salesman for...
  12. Guzzlr

    MS Project

    Hello All, I need a good forum for MS Project.. Can someone lead me in the right direction? Thanks
  13. S

    VBA to copy number of rows to specific sheets based on a few cell values

    Hello. I've search this site to try and find the answer but I what I require is a bit more specific than simply copying a list based on a quantity. I'll explain more: I have a sheet and in this sheet lists tasks in column A, whether they are required or not in column B, The quantity in column...
  14. N

    VLOOKUP problem because data not always in order

    So we have a pricing spreadsheet that has a range of rows for each fiscal year (FY13 thru FY20). When we price a part, there is a lead time associated with that part; i.e. how long will it take us to receive the part from our supplier to send out to the end customer. Sometimes the lead time may...
  15. C

    Using "Fuzzy Lookup" to compare 2 columns... on Office for MAC

    There are great plug-ins for Fuzzy Lookups on Windows machines but I work in a Mac office. I am trying to: I have 2 lists: a Lead List of companies and an event Attendee List I want to compare these lists but there will be spelling inconsistencies between the 2 lists (e.g. - Coca Cola -vs- The...
  16. T

    Combine 3 different formulas

    Guys, is there a way to combine the following 3 formulas into 1? <tbody> =IF(J2=Q2," WE LEAD @ £", " BOW £") </tbody> =IF(R2=J2," LEAVE"," CHANGE TO £") =IF(J2=R2,"",R2)
  17. J

    Move an entire row to the bottom of active sheet based on cell value

    I have list of leads/current clients and there's a column that determines the status of that lead. How do I move the row of a lead where the status says Sold. Help please...
  18. B

    Like Operator

    Can anyone lead me to some info on the Like operator VBA Thank You
  19. K

    How to link multiple drop down lists that will lead to True or False outcome.

    Hi everyone, I'm trying to link 3 drop down lists together, which will lead to True/False outcome. I have tried IFS statement, but I think it's too cluttered and might not be the best option. My other option is to create variables for each category, but I'm not sure how to do it in Excel (my...
  20. E

    Filtering a table with matching data in 2 columns.

    Hey Excel Wizards, I need some help. I have some data that has names in multiple columns. These columns share the same list of names. It is a table tracking who was the lead on a job and who worked with him. Now what I want to do is be able to pull all the data associated with a name no...

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