Fucking Excel man

Fucking Excel man.
My boss that i assume hates me, wants me to make excel sheet that allows to search for specific set of records. Lets say we have sheet with 4 tabs.
Each tab has people from different cities.
CityA, CityB, CityC, CityD
In those cities are people who do certain type of activity. In CityA we have Smith who is Biking and Kowalsky who is Hiking
In City B we have Shultz that is Crafting and Mcmilen that is Biking and so on
Let's say i want to find all biking people, where are they from and other things that'd be specified in each tab. How can i do that?
I can pay in my micropenis photos if anyone interested, or by not sending photos for others. That's really important for me, anons please help me out ;_;

Other urls found in this thread:

reddit.com/r/excel/
twitter.com/NSFWRedditVideo

Do your own homework.

reddit.com/r/excel/

You probably could've tried a little better to hide that it's your homework user, but then again ur a lazy git who doesn't do his homework

Wish that it could be my fucking homework, and i could only get f, but if i fail delivering this shitty excel sheet i feel like i might get really close to firing, and i really wouldn't want to lose my job even if its shitty

i made 50 thousand fucking dollars doing shit similar to that OP

git fucking gud

I just want to fucking kill myself, if i lose this job i'll fucking be literally homeless

I don't use proprietary software, so when I need to parse excel files I use Python + pandas.

Either write a function in VBA (literally has basic in the name) or use VLOOKUP.

This will take you an hour, at most.

pls no spoonfeeding

>My boss that i assume hates me,
what makes you think so? bosses just hate everyone cause they hate their own lives

Eh like i can use it. I'm not even accountant or some IT guy, i work there as archivist and can use excel at only basic level, how she assumed that i can do things like this is beyond me. And also how still she made me do that threating me of firing also. I should propably just kill myself

That bitch is good to their accountants and board members, all other people have really bad time with her

>That bitch is good to their accountants and board members
well there you found the source, she has to lick their asses too and that pisses her off and she takes it off on you guys

No, they're doing bit shady work for company so she praises them

nigga the board members are obviously stressing her out
is this your first job? all bosses are shit cause they all get shat on too, get used to it

Second, her board isn't stressing her out, she is one and only true god of company, and everyone has to do everything as she says. Board MEMEbers are just because law determines that they have to exist, and they sometimes can sign off documents when she is not around

Nigga u dumb
The board members are shareholders or their representatives, go read a book. If she wasn't doing what they wanted they would've run her out already.
Go ahead and get a new job if you can't stand her, it'll just be the same youngfag.

Sounds like a database task, not a spreadsheet task.

They don't. As i said, they're only because law is forcing them to be. Also they do other work, but every decision is made by boss, and she is only one who decides about literally EVERYTHING. I'd happly change job, but in my small city job market is nonexistent. Also don't teach me how does company that i work for work, when you literally have no idea.

>Also don't teach me how does company that i work for work
I'll teach you whatever i want to cause you're obviously the one with no idea on how businesses or the real world work.

This is actually trivial.
First of all you need all sheets to have the same data format, so the same columns and same order in each sheet. Then you consolidate all sheets into one. If you can do it by hand then go ahead, otherwise find VBA macro that will do it for you. Google how to. VBA consolidate sheets or something like that.
Create pivot table that goes over your consolidated data and lists all relevant data depending on filtered field (activity). Add slicer to allow people to change filter dynamically without going into pivot settings.
I probably skipped some things but just look up stuff I wrote about on google.

You really are retarded. Do you know that not every company works the same? Not to mention it differs from country to country?

This is what you should do, use VBA. Hope you pass the class user

Create a new tab with the amalgamated city a-d data on it, filter that one. Better still hide the tab and pretend you did something clever.

Thank you, that's really helpful, at least i have some sort of idea how to do it. Love you user

Good luck with 300+ cities that I have to do xD
Well, she is former accountant, and don't want anything else, I'd propably look up some access tutorial and do it there but oh well

How many records per city? Almost certain you should be using a database. Large spreadsheets often run like shit. Call your boss a fucking noob and chop up an access table.

nice english.

op is either severely retarded and struggles with something engineered for decades to be friendly for retards or he's a pajeet whose never had a formal education

you mean in india where jobs working for white men are fought over to the death.

did your brother die to get you this job? don't let his death be in vain, stay with the job and learn to suck white man dick and you might make it in this world Rajesh