Author Topic: Excel (Read 786 times)

pawan89 · « **on:** May 18, 2011, 11:36:29 PM »

Is anyone who knows excel really well online right now?

swish · « **Reply #1 on:** May 19, 2011, 12:52:21 AM »

You'll have to wait for Babbs, I'm pretty sure he knows it.

He tried to do some limits once for BGT, it didn't work out though.

pawan89 · « **Reply #2 on:** May 19, 2011, 12:58:14 AM »

Quote from: swish on May 19, 2011, 12:52:21 AM

You'll have to wait for Babbs, I'm pretty sure he knows it.

He tried to do some limits once for BGT, it didn't work out though.

Babs to the rescue it shall be then!!

DirtyKash · « **Reply #3 on:** May 19, 2011, 06:37:57 AM »

I'm an expert at Lotus 1-2-3.

swish · « **Reply #4 on:** May 19, 2011, 12:15:10 PM »

Quote from: pawan89 on May 19, 2011, 12:58:14 AM

Quote from: swish on May 19, 2011, 12:52:21 AM
You'll have to wait for Babbs, I'm pretty sure he knows it.

He tried to do some limits once for BGT, it didn't work out though.

Babs to the rescue it shall be then!!

I shouldn't have said anything about Babb's, I think I scared him off.

Alex · « **Reply #5 on:** May 19, 2011, 02:15:31 PM »

Babs excels at everything

Babblelot · « **Reply #6 on:** May 19, 2011, 03:27:47 PM »

Excel expert proficient with various functions including, but not limited to, regression, VLookup, Visual Basics, Pivot Table, conditional formulas, charts, and formatting.
-Babblelot resume

Babblelot · « **Reply #7 on:** May 19, 2011, 03:29:10 PM »

I assumed you used Excel to score the GS Bracket Challenge. How do you do it?

pawan89 · « **Reply #8 on:** May 19, 2011, 06:26:19 PM »

Quote from: Babblelot on May 19, 2011, 03:29:10 PM

I assumed you used Excel to score the GS Bracket Challenge. How do you do it?

I do but I didn't need it that. That's pretty impressive Babbs, you DO know excel!! I have been having a lot of trouble with INDIRECT and references as well as developing algorithms to automate certain things. For instance lets say I have a list like the following, and I want to automate a process to list the top 5 performers, first by most titles won and then by grand slams won. how do you think i would go about doing it?

Name Titles GS
Federer 50 16
Nadal 85 14
Roddick 50 5
Djokovic 85 16

So I want them listed as first Djokovic (highest titles AND GS) then Nadal, then Federer then Roddick. Without using the simple But MANUAL sort function with two levels.

Right now what I have checks for the 85 then eliminates ALL 85s and so on so what I am left with is just Djokovic and Federer