Is there a way to, for lack of better words, use a cell in a calculation only once. So that if i had a total...say 100 and said that if i put a number in these other cells it will subtract them from the 100, but when i erase the cells it would not add it back to the 100.....I know this might make no sense.....sorry, but i don't know how else to explain it....hopefully someone can decode this mess

7/26/2007 8:58:22 AM

why not run the calculation to determine the total with the information in the cells then delete those cells if you don't want them and just manually update or enter the number that the calculation originally gave you? Or you could just put those cells off to the side of your sheet where they wouldn't be seen or printed and still have them deduct from the total.

7/26/2007 9:16:03 AM

yeah, i was trying to keep the manual work to a minimum. I am working on putting some cells off to the side and to just keep a running total.......excel sucks....i wish i remembered how to write programs...

7/26/2007 9:25:30 AM

Fucking hell man. You need to post more than your mindless drivel about your problem than that shit, and expect us to decipher it for you. What the fuck do you think we are, a bunch of Enigmamaniacs or something?

7/26/2007 9:53:50 AM

LOL....oh, blind hate, i didn't mean to upset you so bad

I know it sucked...now shut up...you prolly wouldn't have known it anyways.

[Edited on July 26, 2007 at 11:22 AM. Reason : g]

7/26/2007 11:20:38 AM

I'm the Don Fucking Juan of Excel bitch. I'll can make a spreadsheet that'll suck your dick. So fuck off faggot.

7/26/2007 12:16:26 PM

Quote :

"excel sucks....i wish i remembered how to write programs..."

ummm.... no. you suck, apparently

7/26/2007 12:25:23 PM

excel is pretty awesome, you can do about anything in it so far as two dimensional data goes

7/26/2007 12:39:15 PM

uh, its quite capable of extending to 3+ dimensions with worksheets actually

7/26/2007 6:48:02 PM

yeah, you can. but you probably shouldn't for any kind of complex or especially large 3-d data sets, which i'd wager most problems that require 3-d analysis will probably be.

7/26/2007 8:27:42 PM

Why don't you just hide the cells instead of deleting them, that would be my easy answer

7/26/2007 8:38:12 PM

^^^Okay this is really flexing my dork, but after I wrote my post, I spent the next few minutes thinking about just that.

Using it as a 3 dimensional tool, then I started thinking of how I could actually use it to do 4d transforms too. Aaaaagghh goddamn linear math creeping back in my head, im a designer now dammit

7/26/2007 9:04:30 PM

Matlab bitches

7/26/2007 11:06:15 PM

You could write a macro for excel to add in a button that copies the current column, paste inserts it right after that column, empties everything in the paste-inserted column number-wise (leaving the title and relevant shit you have in the table), hides the column you put the numbers into, and adjusts the formula such that when you put a number in the new column (which doesn't appear to have moved by this point) it subtracts it from that total.

However, I have no idea how to write a macro, I'm only familiar with the concept, and unless you're doing this a LOT you're probably not going to save any time by doing this.

7/26/2007 11:21:09 PM