buyer

Hello I have a spreadsheet like below used by a sales distributor: In this sheet, 1st Column shows items the distributor sells. The next columns denotes the retail or supermarket group who buys items from the distributor. This sheet is maintained on daily basis, and if any supermarket or the...

Project: I'm using Excel to create a receipt/invoice for buyers at a local high school auction. I have three pages in my excel workbook. First page: Buyer information (this will include their bid number), second page: products, third page: receipt/invoice. I'm using VLookup to grab the...

Hello, I'm trying to figure out how to write an If Statement to get the following results: If A = "" AND B = "" THEN "NEITHER" OR IF A<>"" AND B <> "" THEN "BOTH" OR IF A <> "" AND B = "" THEN "BUYER INFO" OR IF A = "" AND B <> "" THEN "SELLER INFO" Thanks!

Hi All I hope this makes sense to some of you! Because after my fruitless attempts it makes less sense to me now that when I started out! I have this data (this is a fictional representation of the names!) in an excel worksheet tab called "Confirmation Forms" - <tbody> A B C D E F G 1...

Hi I am building a report to show my team of buyers which Purchase orders are overdue under each persons name. The pivot table is pulling from a table of "unprocessed" PO lines. Consolidating the data first by buyer and then PO number. I need to filter due date "= or < current date" and then...

Hi guys, I'm given a data set on property type as a school assignment and i'm having great difficulty in creating graphs out of numerically-assigned categorical variables. For example, my variable on gender of property buyer has 0 = male, 1 = female 2 = joint purchase. Is there a way for me to...

Posted in Excel board but no response so assuming this is a better place to post so apologies if rules are broken.... I need to perform 2 queries as follows Query 1 A table contains the following fields Buyer Production I need to return all records where a Production value contains a text...

I have a table that contains the following fields Buyer Contact Date Contact Channel Contact Details I want to return records via VBA code where the Contact Date is < 30 days ago and to only return the latest record (max Contact Date) for the Buyer. I am struggling with the query string and...

I have two sheets (named sheet1 and sheet2), column B is labelled $ and Column K is labelled Buyer. I would like to take the buyer names from column K of both sheets to sheet3 column A and the $ amounts from column B of both sheets to column B of sheet3, then if the names in column A are an...

I am making a workbook for an auction. I was hoping maybe someone could answer my question. 1. I was needing a formula that would add up all the prices for a specif buyer based on his number. His number is in one cell and his price is in another.

HI, I have one workbook with 8 spreadsheets on it. 7 sheets refers to the days of the week and the 8th one is for the calculations. On each sheet I have: Column A with names of 5 buyers represented by numbers from 1 to 5; Column B with 10 products represented by numbers from 1 to 10 ; Column C...