items

I created a search form with a query in it. I want to be able to use the combo box (which I'm trying to fix currently) and then it will pull up search items. I need your help on trying to figure out how to click on the search item below for it to open the next form and search in that one?

https://1drv.ms/x/s!AvjBsEPEq12ngUm0YmMHEk1HGIPY?e=npLKjO My data has account numbers and their corresponding $ value Trying to add the $ value for those accounts which are not in the list in Column E I.e. add column B except the items highlighted in grey How best would you go about it? (My...

hi, I would like to be able to enter items from a workbook into another workbook . if possible to be able to type the first few letters of the item and have all the matching items come up in a dropdown list then be able to select the item and enter it in the workbook so that i can create a list...

I want to look at a filtered list and see how many items in col A are a Yes or a No. I know to look at the total items in the filtered list I'd write =subtotal(2,A1:A100). But how do I separate the two values?

I have made a drop down list that is searchable using formulas and it works. However if i type in 2x4 it gives me certain items. If i type in 2 x 4 with spaces it gives me different items. =IFERROR(VLOOKUP(ROWS($I$2:I2),$C$2:$D$3799,2,0),"") this one looks to see if there is text from what is...

I have a series of prices as; D4 = Item A, D5 = Item B D6 = Item C I have a IF statement in J15 which reads =IF(H15="YES",$D$4+D$6$,0) so adding Item A + Item C In I15, if this contains a "Yes", I want the above statement in J15 to add together all three items (so D4+D5+D6) What is the best...

Hello folks, I have an array of say (s,e,se,sw,s,n,ne,ne,s,e,se) and would like the count of the unique items in that array using VBA. 7 in this example I believe. Is this possible and how would it be done?

I was given tens of thousands of bills charged to customers. I am trying to determine if the bills are potentially accurate. The only data I have is the actual bill itself. Here's where things get complicated. There are four scenarios, each with their own nuances: Scenario 1 Nuances: 1. Base Fee...

Hi, Is there a trick outside of the Pivot to select the items in the search option by linking it to a list? I have 10 pre-defined items to select in the search bottom. I keep adding them using "Add current selection to filter". This is tricky and time consuming. Just wondering if you can help...

If I wanted to replace all the 456 items in the column below, then the delete blank rows where the 456 items were, what menu do I use? <tbody> 142 996 456 123 456 226 456 225 456 </tbody>

I posted this problem a couple months before and I thought I had it figured out but now I have a new problem. I recently upgraded my computer to Windows 10 so now I have Microsoft Office 365. In my wishlist sheet some of my items are blank when I know I have them listed in my stores sheet. For...

Hello. I am trying to import a webpage and its tables into excel I use the data tab, then from web, and import the webpage When I do this, the web view on the pop-up displays the webpage perfectly. Note - It does have the "table highlighting is disabled because...." On this webpage, there...

I have data that sort of looks like this 1 or many items -- > 0 or many children items ----> 0 or many children items ------> 0 or many children items --------> 0 or many children items In other words, the data is a hierarchical tree structure, where each brand has data needed. Some of these...

In column CB I have list of items then CE has their respective values. Now the items in CB are grouped into four - meaning each group has same value. So I need a way to display with a message box - VBA: Group 1 = Value 1 Group 2 = Value 2 Group 3 = Value 3 Group 4 = Value 4 I have been...

Hello, Using Excel 2016, I have a sheet with over 100 columns. I put a filter on it so I can quickly review each column for bad data, but I get a message a the bottom of the drop down saying "Not all items showing". When I click on it, I get a message saying "This column has more than 10,000...

I have a formula that works to solve and find my first MATCH. It is as follows: =INDEX(E31:E80,MATCH(TRUE,G31:G80="",0)) If it helps to understand, the data is for an auction. The formula looks into column G31:G80 to see what item(s) have not been sold yet. The items price is put into the...

Hello, I would like to know if anyone is able to help with some msgbox issue. Idea is to have a list of items be displayed in msgbox. I barely use msgbox and i found some info and played a bit and managed to get this code, but not sure how to edit it in a way that the range is from fix start...

Hi Guys, I receive a list of items pertaining a customer. I want to do is check if list A has an item from list B then create list C. The problem I’m having is that list A is all in one cell separated by a carriage return. So for example cell A3 has xxx xxy xxz, and can be up to 40 items. I...

Hi All, I have a series of columns for orders on my spreadsheet. The furthest left column contains item numbers, the second column contains the quantities ordered whilst the final column contains the item names. I'm trying to find a way whereby any items that are ordered multiple times have...

Hi, I have the following dax formulas for my cumulative total and % cumulative. Its working but not showing the correct cumulative in the technical sense Total Items Delivered: TotalItemsDelivered:=CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile...