23 reputation
13
bio website
location
age 43
visits member for 1 year, 9 months
seen Sep 10 '12 at 7:23

Aug
22
awarded  Notable Question
Jan
29
awarded  Popular Question
Aug
7
comment “pbs” process crashing on OS-X
Hmmm... I'm on 10.6.8 (one of my boxes is a MBP CoreDuo), and my pbs manpage has basically zero information ("pbs is a helper tool for the Cocoa Frameworks"). i.imgur.com/AItEW.png
Aug
6
awarded  Student
Aug
6
asked “pbs” process crashing on OS-X
Jul
7
awarded  Scholar
Jul
7
accepted Excel, merge two sheets with one column as key
Jul
6
comment Excel, merge two sheets with one column as key
I kind of see what's happening there, but not completely. I ended up using something like this: =VLOOKUP($A2,'nni-pvcrep'!$A$2:$F$300,1,FALSE). To be honest, I had a really, really hard time finding any explanation of the table array. What I have there seems to work to match column A on one sheet with column A on another and then pull in the next column (B). IIUC, the "F" refers to the farthest column in the first sheet I want to look at, the 300 refers to the maximum rows to search down in the first sheet and the "1" is one column to the right of my first sheet match.
Jul
3
comment Excel, merge two sheets with one column as key
Yes, I need the data combined in a single sheet, matched on one column that has a common identifier between the two sheets.
Jul
2
asked Excel, merge two sheets with one column as key