Random thread about anything

rick1zoo2

81 wrote:

must be you.

i just created some fake data and my vlookp worked just fine

=VLOOKUP(A5,Sheet1!A:GC,173,FALSE)

=VLOOKUP($E3,'[2013 Budget Comparison.xls]sheet1'!$A$2:$FO$7843,AM$1,FALSE)


and then I tried to paste that into 16,209 rows by 169 columns, which is 2,739,321 cells.

it didn't like it.

RKCNDY

:crazy:

mydogmookieblaylock

everyone is so stupid.

I love when i tell the managers they need to tell there team to start doing something and they get real defensive with me. :fp:

81

rick1zoo2 wrote:

81 wrote:

must be you.

i just created some fake data and my vlookp worked just fine

=VLOOKUP(A5,Sheet1!A:GC,173,FALSE)

=VLOOKUP($E3,'[2013 Budget Comparison.xls]sheet1'!$A$2:$FO$7843,AM$1,FALSE)


and then I tried to paste that into 16,209 rows by 169 columns, which is 2,739,321 cells.

it didn't like it.

weird. did excel crash? i can see it bogging down. that's a lot of calculating.

81

RKCNDY wrote:

:crazy:

you no due excel

RKCNDY

81 wrote:

RKCNDY wrote:

:crazy:

you no due excel

I've created some things in excel, like purchase orders, but I'm not like playing with hundreds of thousands of numbers.

dankind

Leezestarr313 wrote:

kw18 wrote:

:shock:

Some of these old album covers really make you wonder ...





Still one of my faves, I think I have to get this when I see it somewhere

RKCNDY

how do you get voicemail off a blackberry? :?

LloydXmas

RKCNDY wrote:

how do you get voicemail off a blackberry? :?

Toss it in the trash

PJ_Soul

I am in Excel hell today too. :crazy: .... If you do it for long enough, it's kind of hypnotic. :shock:

LloydXmas

PJ_Soul wrote:

I am in Excel hell today too. :crazy: .... If you do it for long enough, it's kind of hypnotic. :shock:

Must be national excel day. I was in it all morning scrubbing a 171000 line census report

PJ_Soul

LloydXmas wrote:

PJ_Soul wrote:

I am in Excel hell today too. :crazy: .... If you do it for long enough, it's kind of hypnotic. :shock:

Must be national excel day. I was in it all morning scrubbing a 171000 line census report

Ugh.
I'm updating all the financial management records for the new fiscal year.

mydogmookieblaylock

LloydXmas wrote:

RKCNDY wrote:

how do you get voicemail off a blackberry? :?

Toss it in the trash

like this
http://www.youtube.com/watch?v=Ze3hthGRbRo

RKCNDY

mydogmookieblaylock wrote:

LloydXmas wrote:

RKCNDY wrote:

how do you get voicemail off a blackberry? :?

Toss it in the trash

like this
http://www.youtube.com/watch?v=Ze3hthGRbRo

I get to toss it in the trash next month.

"I forgot my work phone at home...let me know if someone calls"
"Harry is calling...and left a message"
"Harry is sitting across from the table from me"
:evil: why is he calling your phone then? :evil:

Mamasan23

PJ_Soul wrote:

I am in Excel hell today too. :crazy: .... If you do it for long enough, it's kind of hypnotic. :shock:

I hear ya sister. My new job is nothing but Excel templates and inventory reports. My eyes hurt!

81

Mamasan23 wrote:

PJ_Soul wrote:

I am in Excel hell today too. :crazy: .... If you do it for long enough, it's kind of hypnotic. :shock:

I hear ya sister. My new job is nothing but Excel templates and inventory reports. My eyes hurt!

have you considered sumif?

Heisenberg

Should I fore-go having a proper dining room in order to buy a 1960's 45 Jukebox?

BinauralJam

Heisenberg wrote:

Should I fore-go having a proper dining room in order to buy a 1960's 45 Jukebox?

Yes

Heisenberg

BinauralJam wrote:

Heisenberg wrote:

Should I fore-go having a proper dining room in order to buy a 1960's 45 Jukebox?

Yes

TV Trays it is

81

Heisenberg wrote:

Should I fore-go having a proper dining room in order to buy a 1960's 45 Jukebox?

define proper