Through the function of the CDF taken data. But copy and paste their values ​​in Excel file does not work. Here’s what comes out:

on the right, the data that I copied and pasted into the left side, but only the first number was successfully copied, and then some other numbers, and I copied the entire column on the right, and only 7 numbers were inserted. When I select cells for copying, it turns out as in the picture below. enter image description here

  • Not enough data to analyze. Options: hidden lines; data is not inserted as values ​​(heading - copying cells, in question - copying values ​​...). If not, find the opportunity to show the problem file. - vikttur
  • I inserted as values. If you cut and paste, the whole column falls under the formula and deteriorates, but is inserted correctly. And when I try to copy, it comes out as in the picture. Each cell is allocated separately, maybe because of this ?? - Nurqalfey
  • Each cell is allocated separately - hidden lines in the range. - vikttur
  • How can I fix this? - Nurqalfey
  • Display strings. You are copying only visible values. The copied values ​​are inserted all, but you do not see them all (the rows are also hidden in the insert range). - vikttur

0