insert the value of a cell in a colum that is bigger of an preestablished value

  • Thread starter Thread starter mogly69
  • Start date Start date
M

mogly69

I mean If I have this column
12
23
34
45
56
76
98

and an specific cell value is 50, I'd like to compare these value with
the values of all the column and choose the next one, in these case it
would be 56,
If the value of that cell were 15 then I'd like to introduce 23 in
another specific cell, how can I do that?
thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting to text file in multiple lines 3
Column number of last column that returns value ignore formulas 8
Insert rows by group and copy value 2
How to update a range of cells if cell value is equal to... 6
Arrays and scattered cell values or another way? 16
Move multiple values in single Cell To Cells of there own? 3
I need to use a countif but looking a cell value 5
Creating a range name based on cell content not being a negative value. 5

Back
Top