-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ezzus
-
Make a column that automatically pastes the values from another column
Hi all, I currently have this setup: I would like to have column E automatically paste column D, but as values. Right now column D is filled with the formula (=A+B). I would like to have this pasted as values into column E, but done so on an automatic basis. The easiest solution I see would...- Jyggalag
- Thread
- ezz sverk ezz svork ezzus ezzus sverkus jonas edelhard sværke jonas sværke sanoj ekrævs ssnettet svorktallica
- Replies: 3
- Forum: Excel Questions
-
Edit formula so it returns blank value? Not working for some reason right now
Hi all, I have this formula: It pulls in data from here: However, despite this column being completely empty, it returns the value 0, rather than a blank cell as I have commanded it to. I have checked the cells in column H and there are nothing there, not even a space, so i do not...- Jyggalag
- Thread
- easy excel ezz ezzus ezzus sverkus fast formula goldstrome help index indexmatch jonas sværke match p90 jonas svaerke p90 rush svork p90 svork p90 svorkrush sanoj ekrævs svorkieboy vba vlookup
- Replies: 4
- Forum: Excel Questions
-
Make formula return date instead of value
Hi all, I have this very complex formula: It returns a date value from a different sheet. However, it is returned in a number format, rather than a date format. Any idea how to fix this? I believe that I can use the TEXT() formula, but I cannot figure out how :( If anybody can help me...- Jyggalag
- Thread
- date easy excel ez sverk ez svork ezz ezzus ezzus sverkus fast formula help index indexmatch jonas sværke match sanoj ekrævs sverk sverkieboy sverknation sverktallica svonkie svorkie svorkieboy svorknation svorktallica svorkus vba
- Replies: 3
- Forum: Excel Questions
