The "ditto" means a single quote or double quotes. Hit CTRL + ' (apostrophe) and it should copy the FORMULA from the cell above. If you hit CTRL + " (ditto mark), it should copy the VALUE from the cell above, but not the formula. BTW. Thank you Mike & Bill for being such an inspiration in my life =)
Haiii For example Diameter 20 with +/-0.020 and measured value is 19.970/19.980. Here lower value have -0.010mm deviation. Same this how can get in excel? It will be useful to me in work Please help
It would be really useful if we could see what the data in the cells looks like. You can't post a picture here at TH-cam, but you can post a screenshot in a new thread at MrExcel: www.mrexcel.com/board/forums/excel-questions.10/ It is free to register and free to post.
![30 ชั่วโมงคนเดียว บนรถไฟชั้น 3 โซเวียต [Around The World Ep. 2]](http://i.ytimg.com/vi/MlE9boAVqDA/mqdefault.jpg)
Even after 11 years and new excel versions, this was fun to watch and even very usefull haha
The "ditto" means a single quote or double quotes. Hit CTRL + ' (apostrophe) and it should copy the FORMULA from the cell above. If you hit CTRL + " (ditto mark), it should copy the VALUE from the cell above, but not the formula.
BTW. Thank you Mike & Bill for being such an inspiration in my life =)
hEY CAN WE MEAN +/- stdEV IN THE SAME CELL??? I KNOW WE CAN CALCULATE MEAN AND STDEV SEPERATELY BUT HOW TO PUT THEM IN THE SAME CELL
Haiii
For example Diameter 20 with +/-0.020 and measured value is 19.970/19.980. Here lower value have -0.010mm deviation. Same this how can get in excel?
It will be useful to me in work
Please help
It would be really useful if we could see what the data in the cells looks like. You can't post a picture here at TH-cam, but you can post a screenshot in a new thread at MrExcel: www.mrexcel.com/board/forums/excel-questions.10/ It is free to register and free to post.
Hamy72 ... The ditto key is located left of the Enter key ( ' )
Same key as the quotes, but NO shift.
Kevin - thanks for your answer to Hamy72.
@@MrXL Sure.... 10 years ago.. Just catching up? LOL
krn14242 58,000 comments. I am considering randomly answering ten a day for 15.89 years. The question: is it better late than never?
Control Ditto? Can somebody translate how do you type this?
It is the Ctrl key and then the key that has both an apostrophe and the quotation mark.
Those evil Managers! lol