Tiger Board Logo

Donor's Den General Leaderboards TNET coins™ POTD Hall of Fame Map FAQ
GIVE AN AWARD
Use your TNET coins™ to grant this post a special award!

W
50
Big Brain
90
Love it!
100
Cheers
100
Helpful
100
Made Me Smile
100
Great Idea!
150
Mind Blown
150
Caring
200
Flammable
200
Hear ye, hear ye
200
Bravo
250
Nom Nom Nom
250
Take My Coins
500
Ooo, Shiny!
700
Treasured Post!
1000

YOUR BALANCE
Excel Bros: GITT
storage This topic has been archived - replies are not allowed.
Archives - General Boards Archive
add New Topic
Replies: 19
| visibility 1

Excel Bros: GITT

1

Aug 30, 2023, 9:40 AM

and explain to me how I can consolidate data across multiple spreadsheets.

For example: I have multiple spreadsheets with rows and rows of data that I don't need.

What I do need is my one row of data and the column headers.

Do I really need to copy and paste all of this?

2024 white level memberbadge-donor-05yr.jpg flag link military_tech thumb_downthumb_up

I like your funny words magic man


Re: Excel Bros: GITT

5

Aug 30, 2023, 9:41 AM






flag link military_tech thumb_downthumb_up

Could refer you to my wife but she'd probably roll her eyes

1

Aug 30, 2023, 9:46 AM

Call you an idiot, and tell you how to do it as she does it in 15 seconds. She will finish with a long sign and go back to her CMS data with all that var_function= crap in SAS.

2024 orange level memberbadge-donor-15yr.jpgringofhonor-tiggity-110.jpg flag link military_tech thumb_downthumb_up


You uh..... got her number?***

1

Aug 30, 2023, 9:48 AM



2024 white level memberbadge-donor-05yr.jpg flag link military_tech thumb_downthumb_up

I like your funny words magic man


Sure.

4

Aug 30, 2023, 9:49 AM

803-867-5309

Ask for Jenny.

2024 orange level memberbadge-donor-15yr.jpgringofhonor-tiggity-110.jpg flag link military_tech thumb_downthumb_up


How did you get my wife's number?***

3

Aug 30, 2023, 9:50 AM



2024 white level memberbadge-donor-10yr.jpg flag link military_tech thumb_downthumb_up

MauldinT, where are you???


Found it in a bathroom stall.***

2

Aug 30, 2023, 9:53 AM



2024 orange level memberbadge-donor-15yr.jpgringofhonor-tiggity-110.jpg flag link military_tech thumb_downthumb_up


best prank ever

4

Aug 30, 2023, 10:00 AM

wrote a college buddy's phone number in a truck stop bathroom stall saying:
"I Rate Poops. Text: whatever# for your score!"





took him about 4 or 5 months to finally open up to us that he kept getting these random pics of #### in a toilet

flag link military_tech thumb_downthumb_up

"where's the prank?"

2

Aug 30, 2023, 10:04 AM

~TOTE1

flag link military_tech thumb_downthumb_up

Ask ChatGPT.***

1

Aug 30, 2023, 9:53 AM



2024 purple level member flag link military_tech thumb_downthumb_up

drunk at the putt putt.


Don't you have like 3 masters degrees from various

4

Aug 30, 2023, 9:55 AM

colleges on a corner?

Did you NOT have to learn spreadsheet 101 in any of them?

badge-donor-05yr.jpg flag link military_tech thumb_downthumb_up

HE WAS TOO BUSY SPREADING SHEETS!!!!!!***

1

Aug 30, 2023, 9:58 AM



2024 purple level member flag link military_tech thumb_downthumb_up

drunk at the putt putt.


If all you want is one row

1

Aug 30, 2023, 10:07 AM

just copy the spreadsheet to a new one and delete what you don't want.

2024 orange level memberbadge-donor-15yr.jpgringofhonor-fatherg-110.jpg flag link military_tech thumb_downthumb_up

Excel user here, 16 years experience

4

Aug 30, 2023, 10:09 AM

Yes.

flag link military_tech thumb_downthumb_up


You must excel at it.***

3

Aug 30, 2023, 10:10 AM



2024 purple level member flag link military_tech thumb_downthumb_up

drunk at the putt putt.


Per chatgbt

1

Aug 30, 2023, 10:27 AM

Once upon a time in the bustling town of Dataville, there resided an individual known by the curious nickname "FBMooch." FBMooch had gained a reputation for their insatiable appetite for learning and their uncanny ability to untangle even the knottiest of problems. However, there was one puzzle that seemed to leave FBMooch scratching their head: the enigma of consolidating data across multiple spreadsheets.

One bright morning, FBMooch sat before their computer screen, a perplexed frown etched upon their face. They had been tasked with the challenge of consolidating data from an assortment of spreadsheets – a task that seemed as confounding as deciphering ancient hieroglyphics.

"Someone, anyone, enlighten me on the sorcery required to consolidate data from these spreadsheets," FBMooch muttered to themselves, their brow furrowing with consternation.

As fate would have it, a fellow townsfolk named SageSam happened to stroll by, their keen ears catching wind of FBMooch's vexation. SageSam was renowned far and wide for their spreadsheet wizardry, capable of weaving magic through cells and formulas.

"Ah, FBMooch, I perceive you're grappling with a spreadsheet conundrum," SageSam proclaimed with a knowing smile. "Fear not, for the art of data consolidation is within your grasp. Allow me to illuminate the path."

A glimmer of hope sparkled in FBMooch's eyes. "Oh, please, do share! I find myself lost amidst these columns and rows."

With a gentle demeanor, SageSam drew a chair close to FBMooch and began to expound, "Imagine, if you will, a bountiful orchard laden with diverse fruits. Each fruit represents a separate spreadsheet, brimming with unique data. However, your heart desires only the juiciest of fruits – the key data points and column headers."

FBMooch nodded in rapt attention, captivated by the analogy.

"Now, instead of laboring to pluck each individual fruit and rearrange them in a basket, you possess a potent spell known as 'Consolidation,'" SageSam continued, a twinkle in their eye. "This magical spell takes the form of tools such as 'Consolidate' or 'PivotTable,' tools as wondrous as the artifacts of legend."

FBMooch's interest was piqued. "PivotTables, you say? Those are like the hidden scrolls of spreadsheet wisdom."

SageSam chuckled softly. "Indeed! With the incantation of a PivotTable, you can summon forth your desired data, neatly arranging it within a new spreadsheet. It's akin to harvesting the finest fruits and assembling a magnificent feast."

FBMooch's understanding began to crystallize. "So, no more copying and pasting?"

SageSam shook their head. "No tedium of copying, no drudgery of pasting. A mere sequence of clicks, and behold – your consolidated data stands before you. A triumph of efficiency, a victory of intellect."

Over the course of the day, SageSam patiently guided FBMooch through the process of employing PivotTables to consolidate data across multiple spreadsheets. Step by step, FBMooch's bewilderment transformed into a sense of mastery and accomplishment.

As the sun dipped below the horizon, FBMooch leaned back in their chair, surveying the elegantly consolidated spreadsheet on their screen. "I can hardly fathom how clueless I once was about this. It's not the labyrinth I imagined."

SageSam smiled warmly. "We all stumble upon puzzles that confound us. What matters is the eagerness to learn and adapt. Now, armed with this newfound knowledge, you can illuminate the path for others who tread the same trail."

From that day onward, FBMooch became celebrated as the "Data Dynamo" in Dataville. Their journey from bewilderment to enlightenment inspired many to embrace the art of data consolidation, proving that challenges are conquerable with guidance and determination. And so, the town learned that seeking wisdom from others was a sign of strength, and sometimes, the solutions to complex riddles are simpler than they seem.

badge-donor-05yr.jpgringofhonor-aero.jpg flag link military_tech thumb_downthumb_up

This thread makes me so so so so so so so so

2

Aug 30, 2023, 10:37 AM

happy that excel isn’t in my life.

2024 orange level memberbadge-donor-05yr.jpg flag link military_tech thumb_downthumb_up


Aren't you in sales?

1

Aug 30, 2023, 11:03 AM

How can it not be?

badge-donor-05yr.jpg flag link military_tech thumb_downthumb_up

He is...more in collections now.***

2

Aug 30, 2023, 11:13 AM



badge-donor-05yr.jpgringofhonor-aero.jpg flag link military_tech thumb_downthumb_up

=if(username="tigermanac","EAD","")

1

Aug 30, 2023, 11:14 AM [ in reply to This thread makes me so so so so so so so so ]

love you man

flag link military_tech thumb_downthumb_up


Replies: 19
| visibility 1
Archives - General Boards Archive
add New Topic