Hi!
I´ve got two files. The first file is used to do some calculations of the second file. My first file finds out how many rows that are being used in the second file.
After that I want to find out how many times the value in cell B2 in my first file appears in my second file.
If I write this formula manually, there´s no problem.
=COUNTIF([file_two.xlsx]Sheet1!$A$2:$A$429;$B2))
However, I never know how many rows the second file is using, so I would like to set 429 using the value in the cell that I used in the beginning, the one that find out how many rows there were in my second file.
I´ve tried concatenate in different forms, but then I see my formula instead of the value it´s supposed to produce.
Anyone knows how to fix this?
I´ve got two files. The first file is used to do some calculations of the second file. My first file finds out how many rows that are being used in the second file.
After that I want to find out how many times the value in cell B2 in my first file appears in my second file.
If I write this formula manually, there´s no problem.
=COUNTIF([file_two.xlsx]Sheet1!$A$2:$A$429;$B2))
However, I never know how many rows the second file is using, so I would like to set 429 using the value in the cell that I used in the beginning, the one that find out how many rows there were in my second file.
I´ve tried concatenate in different forms, but then I see my formula instead of the value it´s supposed to produce.
Anyone knows how to fix this?