item1

Hello, I am looking for a couple formulas to solve this issue, but one would be even better. I took a two formula approach in the example below. 1st formula will find rows in column A that begin with a defined letter, such as "M" in the example below, and then return a value in a different...

<tbody> A B C 1 Item1 -2 Station25 2 Item2 -5 Station26 3 Item3 -7 Station27 4 Item1 -8 Station28 5 Item3 -10 Station29 </tbody> Hello, I need help please. I have been searching the internet and cannot find this solution. Column B is plotted on a chart as...

Hi, I have an userform with a combo box and a textbox and I am trying to get the textbox to show the corresponding value of the chosen item in the combo box. The combobox is named ComboBox1 and the textbox is named Textbox1. When I select item1 I want the textbox to show the text for item1...

Hello guys, I am using xl since years but I am stuck at one point which I can not give a solution. I have cells as below: Item1, Model1 Item1, Model2 Item1, Model3 Item2, Model2 Item2, Model4 I need to result as below: Item1, Model1;Model2;Model3 Item2, Model2;Model4 I have tried countif to...

Hello, I would like to rate each item to find out why my "bread and butter" items are. e.g. ITEM1 would get something like CC and ITEM2 CA and ITEM14 AA. what formula can look at all items and score according to preset rules (e.g. top 10% = A and so on) <colgroup><col width="64" span="3"...

Hello All, I have a table of a list of sales to customers and I am trying to create a formulae that will give me the total value of items sold to a customer. Table <tbody> Customer Record Type Item Qty Price Cust1 SI Item1 2 1 Cust1 SC Item1 1 1 Cust2 SI Item2 3 2 Cust2 SI Item1 5 1...

Hello. I just tried posting this but got an error. Apologies for any possible double post. I want to achieve the following. User selects the item they want in A1 (dropdown menu), called ITEM1 In the second sheet, there are tables with the following properties such as ITEMS MATERIALS...

Does anyone know how best to navigate a pivot table sideways (i.e. on same row but from column to column) using VBA? If I pick any pivot item in the pivot table, I can find its parent item or column heading within the same column by simply doing Set obj = pivotItem.Paent However, I've been...