Radka
11-10-2004, 02:31 AM
I have data in Column B of my worksheet. And I have a value "VS", which is in range of ColumnB data. I have to find between which cell's values is my "VS" and the number of these cells(B10 and B11 and s.o).
For example, my value is VS=0,52. Range of data in ColumnB is from 0,49 to 0,56(increasing linear function) and ColumnB consists 100 cells. Maybe my value is between cells B16 and B17, or between B45 and B46. I have to find where exactly is my value VS?
Can anybody help me? Thanks in advance!
For example, my value is VS=0,52. Range of data in ColumnB is from 0,49 to 0,56(increasing linear function) and ColumnB consists 100 cells. Maybe my value is between cells B16 and B17, or between B45 and B46. I have to find where exactly is my value VS?
Can anybody help me? Thanks in advance!