Copy Filtered Rows as Values in Excel Without Formulas

·

Hi! How to copy only filtered rows from formula-based column without formula? i need only values of formula. Is there a smart way to do it except copy+paste?

5 comments

Adnan M.
·
·
Hey K. M. Why do you want to copy and paste the values? Do you want to paste the values into another column?
Arturo O.
·
·
Hey Katarzyna, thanks for the inquiry! Curious to see an example of this use case. Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1730835900&signature=aa2b7cb6b863615b1138b1c029db5086d6d03bcf805637da8614cfe822adee7b&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSv0BZIf2BKsam%2FhVPuuzA%3D%3D%0A Also, if it helps, you can use the record screen feature located below to provide more details. Thanks! [App: Screen Recording by Birdie]
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
K. M.
·
·
Adnan M. Him yes, i want to create a new column with values from formula-based column 🙂
K. M.
·
·
Arturo O. Hi Arturo, thanks for reply. i already achieved my goal, so I won't record it, but i was curious if is it some smarter way to do it, because copy+paste sequence with big number of rows may get stuck and stop processing. Only after the third time I managed to copy all the values. Also i was curious, because i wanted to copy values from filtered rows and once when i copied selected, it pasted values in all rows. not only filtered ones.