All Questions
27
questions
0
votes
1
answer
137
views
Reference values in Excel Tables with a semantic reference?
Problem
I have an Excel Table Object:
In which I store assumptions for a formula.
Are there best practices for referencing a value in that table with a semantic reference?
Deeper Explanation
Attempt #...
- 101
0
votes
1
answer
250
views
Macro to check date range against criteria
I need VBA code to check each weekday date in a date range against a table in another sheet, if the corresponding value is >9% for any of the days, it should return a msg box
i.e, in the "...
1
vote
0
answers
840
views
VBA vlookup for multiple columns
I am trying to compare two tables of data on the same sheets and display matches in a 3rd table. I can get the first column in the 3rd table to return matches however the other matches don't display ...
- 11
1
vote
1
answer
638
views
Copying cell colors to another sheet
My active sheet (let's call it Sheet1) will be main for all users to edit and view.
User 1 only needs to view half the data in Sheet1 at a time so I've created a Sheet2 to only display the data that ...
- 11
-3
votes
1
answer
33
views
Cross Referencing Assistance?
So I am tasked with finding and noting the part numbers from one sheet, that includes a list of data of all part numbers of the company, and add them into or just make note that the part numbers is ...
- 1
1
vote
1
answer
72
views
Compare excel worksheets
Here is the problem I have been trying to resolve all morning - I have two Excel worksheet files:
Subset: This file has a subset of employees with various details including training status such as in-...
- 11
0
votes
1
answer
258
views
Weird VLOOKUP issue in a macro heavy worksheet
I have quite a weird issue with a workbook I built that is very macro dependent. It centers around a simple VLOOKUP().
Currently my macro creates a line item on one sheet (Sheet A), then copies said ...
- 101
-1
votes
1
answer
114
views
retrieve the entire column data If a particular text or pattern is matched
I have particular header(specific column) need to retrieve the entire column of the header to another sheet.Is there any formula to do it.
- 1
0
votes
1
answer
48
views
I need to do a mass find and replace ¿May I do it with a table of "subtitutions"?
I have a main table with patients and hospitals. The hospitals have typo errors and some of them are without an article, like following.
Name Hospital
----------------------------
Fulano ...
1
vote
2
answers
156
views
Excel lookup between dates
I have a spreadsheet that lists each client and the date when their status changed. e.g.
Client_Name Transaction_Date Status
ClientA 1/1/2017 Level_1
ClientB 2/1/2017 ...
- 518
1
vote
1
answer
7k
views
Excel: Combine multiple rows but keep column data?
I have an Excel spreadsheet (Excel 2011 for Mac) with 1175 rows containing species names (431 names total) and 72 columns (A:BT) of months from October 2011 to August 2017. Each row only has one cell ...
- 11
2
votes
1
answer
411
views
Using VLOOKUP to retrieve data in separate sheet based on value
I have long account codes separated by dashes so they look like ##### - ### - ## - ######. One of these dashes that separate the numbers is a departmental code. In my workbook I have a sheet called "...
- 33
1
vote
0
answers
63
views
Vlookup Assistance
I have a project where I need to lookup up/match multiple values from Column B to match a criteria selected from a drop down list in Column A.
The project pertains to different countries and their ...
- 11
0
votes
1
answer
297
views
Using VLOOKUP across worksheets without referencing the original worksheet
I've got a workbook that runs a few macros to pull in copies of sheets from a number of other workbook. I'm trying to set up one file that users can copy to their project folders and then just use ...
0
votes
0
answers
156
views
Effeciently Vlookup Values 400k rows x 10 columns - Arrays?
Thank you in advance for helping me with this. I have a dataset (400k rows x 10 columns) that I need to lookup values for in another workbook on 5 different tabs. How should I set this up for maximum ...
- 11
0
votes
0
answers
53
views
Excel Vlookup- adds up percentages with duplicate relationships
Please refer to the image below. This data has one column called entity ID and anther column, Parent entity and then the Percentage column for each relationship. Looking at the data I see there are ...
- 15
0
votes
0
answers
785
views
VBA vlookup error
There are about 1200 rows with data after the first part of the script has run. Afterwards I want to run a vlookup for column 6, which has the initials of the person handling the problem, against a ...
1
vote
0
answers
1k
views
FAST VBA based vlookup equivalent
Trying to copy the function of vlookup in VBA, the best I can come up with is this:
Function VBALOOKUP(LUcell As Variant, LUArray As Range, LUColi As Long, OutColi As Long) As Variant
Dim Y() As ...
- 774
0
votes
2
answers
114
views
Vlookup or VBA on getting specific data out of many single cells
I have a strange one. I extract data from an application into an Excel spreadsheet to do some high-level analysis. I have one column, called History, and it can have numerous entries inside a single ...
- 157
-1
votes
1
answer
97
views
vlookup - Is it possible to use vlookup to pull specific info like this?
I am trying to pull the following from each group of Numbers -
CHG000509443 05-16-2016 22:48:41 for the Requested
CHG000509443 05-17-2016 13:14:35 for the Approved
Note 1 - It is always the first ...
- 157
0
votes
1
answer
6k
views
How to populate information from one sheet to another in Excel Workbook?
My current task is to create a formula where my information from one sheet will auto populate in another sheet when the product description is copied.
To be specific, we need to have the items ...
0
votes
1
answer
693
views
Need to transfer a column's data. I have 2 sheets with same data and need to move corresponding data from one to another
I have 2 excel sheets and both have one column that has matching data. However Sheet2 has a column of data that Sheet1 does not have and I need to input the corresponding data from Sheet2 into Sheet1 ...
0
votes
2
answers
4k
views
How to lookup a value and return multiple unique values to a single cell - comma separated
I am attempting to lookup a unique identifier (Product Number) which is held in several different stock locations. For example:
__A__ __B__ __C__
1 Item # Warehouse ...
- 1
0
votes
2
answers
796
views
Needs VBA solution - Clear contents of 4 cells to left of cell with N/A Error
I have a table of data in which column L has a vlookup formula. In the rows where column L (i.e., the vlookup returns "#N/A"), I would like to clear the contents of the eight cells to the left (...
- 11
1
vote
1
answer
4k
views
How to lookup a value and return multiple unique values (remove duplicates) to a single cell - comma separated
I am trying to take a value (unique id) from column AC, do a lookup in column (B) and return (meaning concatenate) the multiple unique values from an adjacent column (C) to a single cell in column AD. ...
- 13
0
votes
1
answer
207
views
merge two exel sheets and update duplicate value
I have two exel sheets and I need to merge this sheets but in sheets 1 i Have 800 records in sheet 2 i have 20 records and some of value from sheets 2 are duplicated in sheet 1. I wan to update ...
- 1
12
votes
3
answers
397k
views
Searching for a value in Excel, returning yes or no
I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...
- 121