multiple values

Good afternoon everyone in Excel land. I'm not sure if what I want to do is possible or not, but here goes... Our sales manager wants to be able to enter a size of inventory (tires) in to an .xlsx that I've built her and have it return all items we have of that particular size. It could be...

<TABLE style="WIDTH: 378pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=504 border=0><COLGROUP><COL style="WIDTH: 54pt" width=72><COL style="WIDTH: 54pt" span=6 width=72><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP...

Hi everyone, I have an interesting challenge today. I'm trying to create a template file that runs a vlookup off of another file. The problem is the other file (which I don't own) can have multiple entries. I need a way of either flagging that there are multiple entries, OR a sum of all...

Hello Smart People, I have been working on this all day and it is driving me crazy. I have found tons of answers but none of them fit my situation. I have two worksheets. The first work sheet contains a list of people and the classes they have completed. Example <TABLE style="WIDTH: 144pt...

I have a SharePoint list with a Choice field that will allow multiple values. I would like to be able to analyze the data in an Excel pivot table. There are no problems exporting the SharePoint list to Excel, however when the Choice fields (that permit multiple values) are exported they are...

Hi, I have a database of customer data where I need to transfer out into individual tabs. In order to do this, I need to be able to use a vlookup and get all of the same customers in one group. e.g. Customer 1 Joe Bloggs Ltd Customer 2 Jane BLoggs Ltd Customer 1 Michael Bloggs Ltd I...

Hi, i've looked around the web for hours and hours and have as yet not found a solution that fits my requirements! When using VLookup, obviously it will return the first value it finds in the lookup range, however when I have duplicate rows, I require the various values to be returned, not...

so, I have what I imagine to be a simple and [I'm thinking what must be a] frequent problem ... I have two rows, one on top of the other ... top row is types of fruit [one per cell], lower row is simply "Y" or "N" depending on whether is like the fruit or not. what i want to do is, on a...

Hi, I'd be indebted to anyone who can help me with some Macro problems i'm having. I have a Macro, which works perfectly, for deleting any row where a cell in the active column does not contain a value: Sub del_1() Do While Not IsEmpty(ActiveCell) If Not...