Copy and paste from levels

S

swiftgirl

I recorded temperatures every 15 minutes for four months, and I need to use
the minimum daily temperatures for statistical calculations. I used the
Subtotals tool to find the min value for each day, and seperate the data into
layers.

However, now that I have the list of data I need, I can't figure out how to
use it. If I try to copy and past just the min values to another page, the
numbers change, even if I use "paste special", "values".

Can anybody help me please? Thanks
 
M

Ms-Exl-Learner

After pasting the value using pastespecial>>values, Check both cell formats.

Remember to Click Yes, if this post helps!
 
F

Fred Smith

How did the numbers change? Give us a few examples.
How did you copy and paste? Give us the steps you went through.

You should be able to make this process work.

Regards,
Fred
 
D

dlw

in your subtotal view, highlight the cells you want to copy, then on the menu
bar, Edit>Goto>Special>check Visible Cells Only
Now copy and paste as normal
 

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

Paste options button disappears 0
Function help: Reference cell based on another cell's value? 3
Paste Link and Link Text From Browser to Word 0
Pivot Table Calculations 0
Copy/Paste (Clipboard) Issues 1
How to find a result in an array in the same row as a minimum resu 3
Paste Special Values 2
how to get a simple macro to paste value 4

Top