sold

Hello everyone, I already tried different combinations of Large(row)) or Max functions, but I just can't get it work. I am happy with whatever I get; the whole solution doesn't have to fit in a formula in one single cell. If I have to create a helper table, I am fine with that. What I have is...

Hi. This is my first time in this forum. I have a table in this link https://filehost.net/234a1151ff7695d3 and i cant figure a formula that works The criteria are inside file, but i need a formula that counts products sold in each day, by year, between a min and max value. this is the easy...

Hi there, hope someone can help... The names of the worksheets are irrelevant, however I'm keen to know what the following means in plain English. Specifically around the comma? =AND($J$14>'Project Sold Effort'!$AI$40,$J$14<='£ Calculations (Ref Only)'!$I$4) Thanks

Hi I have an OH report that calculates the current OH. I would like to figure out what the OH was each of the last 52 weeks. I need to take OH + SALES + UNITS SENT - UNITS RECEIVED to figure out the balances of each of the prior 52 weeks. Do I have to create 52 measures? Is there a better...

How do I set a countif but dont want to count duplicate names? Example a sales team of 5 sold x number of iteams but then Adams name may come up several times due to mutiple things sold. I just want the countif to count name once? example below Sorry having some issues in upload I'll give you...

Hi, I would like to ask if there is any way to retrieve information such as "sold by" which seller, and how much is the selling price...

I have one sheet that shows Sales Personnel in the columns and months down the rows. I have a total number of a specific item sold in a separate sheet. Is there a way to set the conditional formatting for the entire row, based on the entries for each field without having to do them...

Hey everyone, I am currently working in excel and trying to create a database or a log of different values. This is a sample run to bring to my bosses before we approve really implementing something like this. Basically I have a table with a long list of condo's and there are three options...

Hi all I need a formula that will count how many 16 SL and 20 SE cars were sold in 2016. just 1 figure adding the 2 cars together. Thanks in advance <tbody> <tbody> Typr of Car date sold 20 LX 01-Nov-15 16 SL 01-Dec-15 18 SE 01-Jan-16 20 SE 01-Feb-16 18 LX 01-Mar-16 20 LX...

I have this COND column in Excel which I need to import into Access but as you see, each row has this long string that needs to be converted into rows: Sold to party, Price Group and Shipping Condition would need to be represented 5 times for this particular Price Group which has 5 different...

Hello, I am trying to do something and I have no idea how to set it up or if it can be done. I am using Excel to make a inventory system for my parents who have a small retail antique/collectibles business. They have different categories of items, which I am making in tabs. Each line has their...