prophetik music

i wound up using a few functions - primarily MATCH and INDEX - to just make it work with a few databoxes in the corner out of site. so it works now =) thanks anyways, guys, that concatenate code will be nice for future stuff i've got planned.

actually, i figured out a different way. it's a little sloppier, but it makes it work with the broken database i got stuck with. so i'm good for now =) thanks for the info, justin - i had no idea what concatenate did originally, so that helps a lot.

actually, wayward, that looks like what i want. can you notate that code a little more so that i can see where to plug stuff in? to be specific, the array is A40 to roughly M15750, with A being one set of numbers, B being one set of numbers, and G being the data i want pulled.

phill - right idea, but your thingie doesn't work. try looking for 61 in A - it doesn't return anything, even though there's two with 125 in the second column. even if i change one of them to 124, so that there's only one combo of 61 and 125, it returns 0. nutritious - i'd prefer not to, since we're talking about 15k rows of data. i can't manually assign it special IDs without it taking for eeeeeever. unless you know a way to automatically combine two sets of datainto a stacked set? like, A is 24 and B is F, so C is 24F? because i might be able to make that work, although it'll be a butcher job. i guess i'm looking for a vlookup(DataInColumnA AND DataInColumnB) function. i'd think it's doable with an if function, but i don't know how to tell it to run the if row-by-row until it finds the right information. i tried to get an index or a match function to work in there [vlookup(match(somethingorother), match(somethingorother2)), but i couldn't figure out how to make it work. there doesn't appear to be an if-then-else function, just if A, else B function. i guess i have to do it sloppy, by having two references, then having a stacked set of if(then) statements. i was hoping for a simple solution, or one that i knew would work, since i don't know if i can make it work without searching the whole thing every time. thanks for the help, guys =)

likely the drive isn't toast. he'd be getting write errors aplenty when attempting to transfer the data off if it was. likely it's a rootkit infector that ate his boot.ini and related files. with any version of windows, if you've turned off simple file sharing, you can easily go in and change, remove, or reset permissions, owner, etc on any file in any folder. it's how we used to delete the Vista and W7 folders in XP, where they're normally blocked from doing so thanks to administrative rights and file permissions.

hey, folks. hopefully someone here knows more about excel than me. i'm trying to get a formula that'll reference two data points in different columns in the same row, and output a third data point in a different column of the same row. so, for example, i've got ten rows. i want it to look in rows for two specific data points in columns A and B, and when it finds a row with both, spit out whatever's in column C in that row into a box. i can't seem to get lookup, vlookup, match, index, or a combo of them to work properly. the biggest issue i have is that while column A is in numerical order, there are tons of repeats of the datapoint in column A (hence why i need B to be referenced as well). how do i do this?

if it's causing a BSOD, it's because it's either broke your partition table or it's managed to delete essential windows processes that are required to reboot. i'm assuming you've already tried to boot into safe mode. your best option here is to just back up your files with an external enclosure onto another hard drive and reinstall windows. isn't this like the fifth time your computer got hosed by a virus? stop torrenting and P2Ping, man

zircon, i didn't see this before. cobian backup 5 (i think it's 5) allows you to schedule anything you want. that's the backup i use, have used for years, and it's great. it's a versioning software, though, so you're going to get versions of files rather than the most recent version only. beyond that, bacula might be what you're looking for. edit: http://www.fbackup.com/?

necrobump is when you bump a thread that's three pages old or more. it's easier to buy a 7200rpm drive initially, but you can always buy one later and upgrade. it's just annoying to either clone your drive over or reinstall everything. no, you can't daisy chain with firewire.

n-n-n-n-necrobump! the mac SSDs are faster than standard hard drives, but they're not faster than equivalent drives. a better CPU will benefit more than a better HDD. go with the larger HDD. you alwasy, always, always need more.

ohai i might have something sitting around...?

why the hell does it rain all day

i'm just that kind of guy.

spring man knight man tengu man gravity man toad man i have never played a single mega man game, or heard the music beyond remixes. i just went through the thread and picked a couple random ones. here's to creativity, and hopes that people didn't pick terrible tracks

plopped my yearly amount in the paypal box. can we get water this year?

alright, melody, it's up kaden, how much did you sell it for?

alrght, that makes more sense. it's a second-wave 80gb model, then - software compatible. it was AFTER those models - the F, G, etc models - that they took out the card reader and the extra slots. if it was a MSG4 special edition, it'd have a different code on it. you've got the same one i've got, i just forgot that mine had the card reader. except for a few instances (FFXII final battle's a good example), they're just as good as the hardware-emulation models, and the blu-ray player in them is the better version that doesn't jam or crap out as often. in my opinion, they're the best backwards-compatible PS3 you can get nowadays, notably since it's rare that you have issues with the hdd size in them.

check the serial on the bottom or back (forget where). launch-model hardware-emulation PS3s are worth more than first-revision software-emulation PS3s.

@nesper - from now on, please format things a little more like what i use on the front page. it takes forever to reformat everything each time =) @kaden - i was under the impression that the launch model PS3s were 60 or 20/30gb, (CECHA and CECHB). 40gb and 80gb backwards compatible models (CECHC and CECHE)didn't have the memory sticks, i thought.

it's my shit in a box

wat WAT y u cheat?

ccleaner doesn't clear out stuff specific to most legit programs - just temp files and other junk. so it'd likely not affect it at all.

OCR. go straight south from the spawn, you'll see my tower of man-power.

yeah, it's totally possible to use a large memory/cpu-intensive plugin that doesn't map MIDI properly in FL to do that, but it's memory/cpu-intensive, and it doesn't map MIDI properly in FL. it'd be nice to have something a little smaller that doesn't crash half the time to do that. it'd also be nice to be able to change the stutter or retrigger length in real time rather than having to set it beforehand.

use revo uninstaller to remove it, and try again.