RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 788
- Office Version
- 2010
- Platform
- Windows
Hello
My sheet has two elements, the Main tab which has a list of 10,000 6-letter codes down column A . And a temp sheet which has a similar amount of rows.
I'm doing a countif on the temp sheet to see which rows are already in the Main sheet:
This is returning 0 for every code in the Temp sheet, even though I know for a fact that the cells it's looking for exist. For example, one cell is "M64686" and it is EXACTLY "M64686" on the other sheet. In addition, the cells are both formatted the same, there are no leading or trailing spaces.
I have tried clicking in the cell and pressing enter, which usually works. It hasn't this time. I've also done text-to-columns and even some VBA such as:
This usually helps, as the Temp sheet originates from a CSV which is copied over into the temp file and sometimes we need to overwrite the value with the value to make it confirm as the correct format and be readable by Vlookups etc.
Any ideas? Thanks.
My sheet has two elements, the Main tab which has a list of 10,000 6-letter codes down column A . And a temp sheet which has a similar amount of rows.
I'm doing a countif on the temp sheet to see which rows are already in the Main sheet:
Excel Formula:
=COUNTIF('Main'!$A:$A,Temp!$A2)
This is returning 0 for every code in the Temp sheet, even though I know for a fact that the cells it's looking for exist. For example, one cell is "M64686" and it is EXACTLY "M64686" on the other sheet. In addition, the cells are both formatted the same, there are no leading or trailing spaces.
I have tried clicking in the cell and pressing enter, which usually works. It hasn't this time. I've also done text-to-columns and even some VBA such as:
VBA Code:
Do until cells(activecell.row, "A").value = ""
Activecell.value = activecell.value
activecell.offset(1,0).activate
Loop
This usually helps, as the Temp sheet originates from a CSV which is copied over into the temp file and sometimes we need to overwrite the value with the value to make it confirm as the correct format and be readable by Vlookups etc.
Any ideas? Thanks.