past values

  1. O

    Cut and Paste Insert Cells if It Contains a Value

    Hello and thanks in advance to all those who attempt to assist and I will post a response on feedback to proposed solutions. I have a large data set which consists of more than 200,000 rows. I am searching column R to see if has total in it. If it does, I select it and all the cells within that...
  2. B

    Replacing formula with value

    Help me please!! I have a set of data which I need to partially paste values only. However, I don't want to replace all values. The vertical list of data includes sumif functions, sum functions, if functions and simple additions, divisions and multplications as well as blank cells. What i want...

Some videos you may like

This Week's Hot Topics

Top