Array to pull duplicate values from a different sheet
Hi,
I am having a problem using an array to pull in duplicate values on a different sheet. This array worked when it was pulling values from the same sheet but now won't work when I try and pull values from a different sheet on the same workbook.
The array I am using:
Please Login or Register to view this content.
"TE" is the name of the sheet I am referencing to
Unless this is column E COLUMN()-4 it is not going to return 1 which appears to be what you need.
A better and more robust approach would be (and this example assumes you are starting in column ... C)
COLUMNS($C$1:C$1)
Other than that make sure you are committing array formulas with Ctrl + Shift + Enter.
Did that help?
Dave
That worked! Thank you!
You are welcome. Thank you for the feedback and marking this Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks