-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ref#
-
L
#REF! Error - copy/pasting data into cells, then cells on another sheet that = that cell displaying #REF!
Hello! I have a sheet (named "Raw Data by Month") where we copy/paste in daily financial data from another program. This raw data sheet is just meant for the purpose of housing the information. I have a bunch of other sheets, in the same excel document, that pull from those cells to display the...- lichldo
- Thread
- ref error ref#
- Replies: 8
- Forum: Excel Questions
-
P
Counting non-empty merged cells on another closed document with SUMPRODUCT
Hello. I am trying to count non-empty cells on another closed document with SUMPRODUCT. I am using this formula: =(SUMPRODUCT(('https://link/[Workbook.name]Worksheetname'!$Q$9:$Q$99999>"")+0)) Everything seems fine until the array encounters merged cells and returns #REF! from those cells as...- Pisus
- Thread
- count ref# sumproduct
- Replies: 2
- Forum: Excel Questions
-
W
Finding TRUE/FALSE w/VLOOKUP @ multiple values
Good afternoon, Trying to wrap this around my head and it's just not happening. In the example below, I just want to know in column F if the color BLUE appears at all in the reference # over in column B. I've realized that VLOOKUPs just stop at the first value it comes across from top-down, so...- WSBirch
- Thread
- column formula multiple ref# vlookup
- Replies: 3
- Forum: Excel Questions
