What would the formula be to have newly entered rows automatically copied to the end of another set of columns if a particular value matches?
Example:
Advanced filter? (You can control it manually, or by a macro. And you can launch the macro by an Event)
Thanks, but Advanced Filter will not do.
I need an automated solution whereby when new data is enter in a new row, upon a match, that row is automatically copied and tacked onto the end of another set of columns that contains data from previous rows.
.
So, in the example, when entering new data in row A11, if B11=15, then automatically (not manually) copy that row to E4:G4, and do the same for all other subsequent rows where column B-15.
The description you provide does not fit a formula. You describe (parts of) an algorithm. So you will need to write a macro.
.
Not defined: Where does “particular value” comes from and if this should be a persistent copy or not (values stay in second column-set, even if removed from first).
.
To do it with formulas:
- Use MATCH() to find the first matching row and calculate/store/show the row-number in a hidden column.
- Show the matching values, based on the found row.
- The row below needs a MATCH-formula, wich starts below the row you already found, to show the next match.
- Add IF() around to avoid showingvsomething, when no match is found
- Drag your formulas down as far as you need…
1 Like
To questions of this kind (not exclusively concerning the view) always attach an example file (.ods for Calc) showing what you have and what you want to get.
Even experienced users may need tzo play a bit with an example before they can suggest a good solution.
Attach an example!
And what should happen if you enter date, integer, decimal with an integer other than 15 