1

https://docs.google.com/spreadsheets/d/1kwGbFd88cgifQRK_ZqsahQt1aDLzMTnmxHKs7mML5jA/edit?usp=sharing

How to get data entered in one cell to fill another cell in a different location with same values simultaneously when it is above or below certain values but when data is already present there to default to second or third alternative location that will be located either directly to the right or to the right and below present in a zigzag pattern.

the link has a detailed description of the question

0

2
  • updated link sorry , i have tried index and match but could not get to work but i am not very familiar with either.
    – XCATHADOR
    Jun 7 '19 at 16:22
  • That works for filling in values out of the columns that is already there but i was hoping for something that would take a value i entered and place it in the next available slot without rearranging the existing data that was already there kind of like once it has been simultaneously entered it is locked in there that way if a value in between a previous set of values comes up that fits the criteria it wont cause a reordering
    – XCATHADOR
    Jun 12 '19 at 8:14
0

0

E141:

=QUERY({$C$5:$C$110; $J$5:$J$110; $Q$5:$Q$110}, 
 "where Col1 is not null order by Col1 limit 1", 0)

F141:

=QUERY({$C$5:$C$110; $J$5:$J$110; $Q$5:$Q$110}, 
 "where Col1 is not null order by Col1 limit 1 offset 1", 0)

F140:

=QUERY({$C$5:$C$110; $J$5:$J$110; $Q$5:$Q$110}, 
 "where Col1 is not null order by Col1 limit 1 offset 2", 0)

E139:

=QUERY({$C$5:$C$110; $J$5:$J$110; $Q$5:$Q$110}, 
 "where Col1 is not null order by Col1 limit 1 offset 3", 0)

F139:

=QUERY({$C$5:$C$110; $J$5:$J$110; $Q$5:$Q$110}, 
 "where Col1 is not null order by Col1 limit 1 offset 4", 0)

etc.


or like:

0

3

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.