Posts by hollowstag7

Benjamin Wilson7 said:Once you upload it, someone—either me or whoever else is around—will take a look at it.

Honestly, there isn't even much point in uploading it. I actually found a little error 🙂
I guess I messed around with the formula a bit just to make it look cleaner, and now it's kind of costing me some time.
In this specific case
For example:
if you have a cell containing this formula
1. =IF(P1="/";"1";IF(P1="//";"2";IF(P1="";"";"Wrong input"))) - copying this will result in an error
2. =IF(P1="/";"1";IF(P1="//";"2";IF(P1="";"0";"Wrong input"))) - when the cell is empty, copying results in a zero, which works fine

Benjamin Wilson7 said:I mean, is everything actually formatted as numbers, or did maybe some cells accidentally get set to text mode?

So when I try adding this IFERROR, I just keep getting that #NAME? error message.
Everything looks like it's formatted as a number with no decimals, so I don't know.
I guess I'll try to pull those two original lists out and post them here on the forum.

Thanks.
Book3.xlsx

Benjamin Wilson7 said:I mean, nobody's really gonna download some random .exe file, you know?

But then again, where am I even supposed to put it? Like, which server would I use?

Hey, I could really use some help here. I'm attaching a file as an example (it explains things a bit better in there). Basically, I'm trying to figure out how to copy content as Values.

http://www.datafilehost.com/d/3888a46f