supplier

Dear Friends, I have a sheet "supplier". In sheet 2 I am inputting the following array formula: {=IFERROR(INDEX(supplier!$B$2:$B$4377,MATCH(0,IF(supplier!$A$2:$A$4377=$G$9,COUNTIF($G$10:G10,supplier!$B$2:$B$4377)),0)),"")} The formula is given from G11 to G23 by which data are snatched from...

Hi All I am having an issue with trying to get a formula to work and hope that someone tell point me in the right direction please Worksheets "Supplier Dashboard" Column "A:A" has supplier names Worksheets "Supplier Dashboard" Column "BB:BB" has number values D5 is a drop down box (Qtr1...

I have an existing function that creates a hyperlink because the syntax of that URL is baked into the function. This works perfectly fine for a single website; however, the solution becomes obsolete and inaccurate when multiple websites are thrown into the mix. In the sample below, Column A is...

Hi, I have a table (not pivot) that contains many columns but for the purpose of this I will say two. Col A and B. In A I have supplier and in B I have expense. Firstly i filter by supplier to show all items purchased by the said supplier. Secondly I want to do a top 10 filter on the expense...

CURRENT SCENARIO The functions below create a custom SKU based on a hard-coded supplier and its respective URL syntax Excel 2013 32 bitABC1ExampleSUPP URLCUSTOM SKU...

Hello, I want to get a sum of prices for column AA, but only counting 1 occurrence of each individually named Item in column U - for example if the formula worked it would return £16 in AA42 - it would ignore duplicate Supplier Item Names (Row U) There are some filtered out rows which I do not...

Hi all, I hope anybody can point me in the right direction of the challenge I'm faced with: Periodically I have to convert excel pricelists that I receive from suppliers to an excel pricelist according to a layout that can be imported in our system. Currently this requires lots of manual labor...

Hi I am attempting to create a drop-down list which populates based on the value in another cell. For example, if cell A1 has the value "Supplier A" in it, then the drop-down list in cell B1 will contain all the products supplied by Supplier A. The issue I am having is the table on a separate...

Let say we have tables A, B, and C. A left join B with key = invoice number ( A<---B). B right join C with key = supplier code ( B---->C). What does the result look like? field1: A's invoice number field2: some field from B that matches A's number and C's code? field3: C's supplier code But...

Hi I built a supplier scorecard and am looking to be able to still calculate the score accurately if there are N/A's. I am having the hardest time and have tried several methods. Please Help :( I have included a link to the file where the scorecard is located. It is the Supplier Scorecard tab...

Hi All, I have an extract in csv format that I want to import into a database to be able to use it with other data sources. In the file I have 3 columns: Company Ref, Company Name, Contact email If we have 3 contacts for a supplier then there will be 3 lines e.g. AAA001,xyz,john@xyz.com...

Hello All. I have a question. This is what I want to do; I have 3 or more suppliers and every supplier gives me price list for items. I compile them into one excel file. I could choose only one supplier and I need to buy all items from that. For example, I have item list on the first column...

Okay let me see if I can explain this...I am looking to match Supplier Name #sheet 1 to Supplier Name #3 If those two suppliers match,then look for the Known Spend, If Known Spend is equal to "Y", then look to see if the they fall within two columns with dates. Now if that all information...

<tbody> This Excel sheet is already setup for column I to go red if the BBD is pasted the due date. I would like it to send a email when it goes red from the list email addressin column N. A B C D E F G H I J K L M N O 2 IG# Date no of count total count per Rec...

<tbody> The excel sheet I have has a I2 set to go red when it is past the BBD. I would like it to send a email when it goes red. A B C D E F G H I J K L M N O 2 IG# Date no of count total count per Rec Supplier name Supplier item number Supplier 's BBD Use by date...

My excel sheet is set up to go red when the item goes pasted the BBD. I want a email remnder two week before it goes past the BBD. is this possible? I would settle for a email for when the item goes past the BBD...

Hello all, I am in need of some assistance. I have a file where I created a report layout tab for the monthly rollup per supplier. I am trying to get the date field to display the raw data per month as well. I figured out how to display per supplier. When I currently select the date field it...

Hello, I have some data in Table 1 which is a rolling transactional list from accounts, it gives me every payment from every supplier as a cumulative and I would like a formula to return the most recent payment. I’ve deduced I need a max formula to look this up from the table. However, I...

Hi, I have a folder of excel sheets containing product information which are named as each supplier of those products e.g. NIKE. I also have another excel spreadsheet which has the name of each supplier in column A and the email address of that supplier in column B. I would like to send each...

I created the following array that reads a list of supplier names in column C and writes only unique supplier names in column O. =IFERROR(INDEX($C$3:$C$200, MATCH(0,IF(ISBLANK($C$3:$C$200),1,COUNTIF($O$2:O3, $C$3:$C$200)), 0)),"") What I would like to do is develop another array that looks at...