-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
returning values
-
I
Returning Non Zero labels and quantities Without arrays
We have a database that keeps track of installed inventory and allows an auditor to record the type of inventory installed and the number that is installed. The auditor records this in a table that has all of the types of inventory populating a pull-down menu and a column to record the number...- IDS2019
- Thread
- Replies: 0
- Forum: Excel Questions
-
R
Return new values from a list without vlookup
I have two lists in two different files. List_2 is a variable. It is updated monthly and I do not know how many rows of data it will have or if there will be any new items in the list. List_1 is a pre-determined list. As an example, let's say there are 5 items in this list. In List_1...- rishijain11
- Thread
- Replies: 0
- Forum: Excel Questions
-
C
Returnig a set instance after a Succesful Find
Hi Everyone, This is what I have in my cells: <table border="0" cellpadding="0" cellspacing="0" height="15" width="517"><col width="111"><col width="406"><tbody><tr height="17"> <td class="xl155" style="height: 12.75pt; width: 83pt;" height="17" width="111"> </td> <td...- Chip_Excel
- Thread
- Replies: 2
- Forum: Excel Questions
-
B
Returning Values from a range based on another range
Hi all, Day range is A3:A33 Yes/No range is C3:C33 I'm looking for a formula or vba code that lists the days that have a yes value associated with them in a singular cell. For Example: Day 1 = yes " '' 2 = no " '' 3 = no " '' 4 = yes " '' 5 = yes So i need a formula that will return: Dates...- Baaron1
- Thread
- Replies: 4
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
loop through merged cells in a Column to get their addresses
- Replies: 46
I have one column. say column A, which has multiple merged cells of different ranges. for example first cell is merged from A2 to A15 whereas... -
Split a Column into 2, use a character limit that does not cut words in half.
- Replies: 31
Title says it all. I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The... -
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
Preventing duplicates
- Replies: 24
Hi everyone, I am using a userform to add data to my worksheet, my userform uses a combobox to to show the list that exsists but also allows for... -
EXCEL SHEET auto enter Dates
- Replies: 23
Hi All , I am came to this forum after a long time , this is the great platform and with awesome people , where stranger of no where will help... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...