lead

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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)

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...

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

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...

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...