Excel
Moderators: Shirley, Sabo, brian, rass, DaveInSeattle
- Johnny Carwash
- The Dude
- Posts: 5961
- Joined: Mon Mar 11, 2013 8:57 am
- Location: Land of 10,000 Sununus
Re: Excel
Creating a table in Word where you should have just done an Excel sheet should be punishable by a kick to the genitals.
Fanniebug wrote: P.S. rass! Dont write me again, dude! You're in ignore list!
- A_B
- The Dude
- Posts: 23519
- Joined: Mon Mar 11, 2013 7:36 am
- Location: Getting them boards like a wolf in the chicken pen.
Re: Excel
Sure...but a fucking letter in excel?Johnny Carwash wrote: ↑Tue Aug 06, 2019 8:27 am Creating a table in Word where you should have just done an Excel sheet should be punishable by a kick to the genitals.
You know what you need? A lyrical sucker punch to the face.
Re: Excel
Does anybody know anything about Google sheets? Like what happens if there's a public sheet that 30 or so people add rows to and you go in to make edits to all of your entries, so you sort it to isolate your rows and make changes to each row, and then remove the sort but then after that everybody's entries are all dicked up and not matching the row that you sorted because you're old and now realize that Google sheets doesn't work like Excel. Does my sort fuckery reflect in everyone else's views, or does only data entry record but not formatting?
Thank you!
Thank you!
And the unicorns shall come down with them, and the bullocks with the bulls; and their land shall be soaked with blood, and their dust made fat with fatness. - God
Re: Excel
It messes everyone's view up.Jerloma wrote: ↑Thu Sep 07, 2023 9:50 pm Does anybody know anything about Google sheets? Like what happens if there's a public sheet that 30 or so people add rows to and you go in to make edits to all of your entries, so you sort it to isolate your rows and make changes to each row, and then remove the sort but then after that everybody's entries are all dicked up and not matching the row that you sorted because you're old and now realize that Google sheets doesn't work like Excel. Does my sort fuckery reflect in everyone else's views, or does only data entry record but not formatting?
Thank you!
We us google Sheets for our IR/RFI Log on construction projects and if someone sorts the sheet by discipline (eg MEP engineer/structural engineer/architect) it's changes the view for everyone, annoys me intensely if they don't return sheet to the original format (sorry).
- degenerasian
- The Dude
- Posts: 12369
- Joined: Tue Mar 12, 2013 12:22 pm
Re: Excel
fucks up formulas too
Kung Fu movies are like porn. There's 1 on 1, then 2 on 1, then a group scene..
Re: Excel
I'm trying to generate a random sample from a spreadsheet. So I insert a column and then I add the function to the first cell below the header in row 2. Hit enter, and no number is generated; it still just has =RAND() there. Anyone know how to troubleshoot that?
And the unicorns shall come down with them, and the bullocks with the bulls; and their land shall be soaked with blood, and their dust made fat with fatness. - God
Re: Excel
Excel wizards, question:
The Air Force uses Air Force Specialty codes to define jobs in the military. When I pull rosters out of system they come as Excel files.
However, AFSCs like 3E231 or 3E071 default to looking like "3E+231" or "3E+71."
How the hell do I just format the cell to not recognize that "equation" crap? Either using general or text doesn't work. And removing all formats still uses the "+."
So frustrating, but I know it's fixable because I've seen other Excel spreadsheets without the issue. I just don't know how to do it.
The Air Force uses Air Force Specialty codes to define jobs in the military. When I pull rosters out of system they come as Excel files.
However, AFSCs like 3E231 or 3E071 default to looking like "3E+231" or "3E+71."
How the hell do I just format the cell to not recognize that "equation" crap? Either using general or text doesn't work. And removing all formats still uses the "+."
So frustrating, but I know it's fixable because I've seen other Excel spreadsheets without the issue. I just don't know how to do it.
mister d wrote:Couldn't have pegged me better.
EnochRoot wrote:I mean, whatever. Johnnie's all hot cuz I ride him.
- Johnny Carwash
- The Dude
- Posts: 5961
- Joined: Mon Mar 11, 2013 8:57 am
- Location: Land of 10,000 Sununus
Re: Excel
If I'm understanding right - ' (apostrophe) in front of what you type in the box should make it recognize it as not an equation.
e: Ryan beat me to it.
e: Ryan beat me to it.
Fanniebug wrote: P.S. rass! Dont write me again, dude! You're in ignore list!
Re: Excel
So this is probably the most basic question one could ever ask, but honestly I don't use Excel much in my job. I need to know which customers in column B do not exist in column A. How would this dummy go about that?
well this is gonna be someone's new signature - bronto
Re: Excel
Assuming all the names are exactly the same (so not "Houston Cheaters", "Hou Cheaters", "Houston", "Cheaters", etc), just add another column next to B where its =vlookup(B1,A:A,1,false) ... that checks column A to see if the name in B1 exists. Drag that formula down as far as you need in column B.
Re: Excel
How do I sum up a cell so that the formula shows the column header name? So that instead of this...
=SUM(J11,M11,O11,V11,X11,Z11,AF11,AG11)
This...
=[@5Avoid]+[@14Places]+[@21Talking]+[@28Remind]+[@30Event]
=SUM(J11,M11,O11,V11,X11,Z11,AF11,AG11)
This...
=[@5Avoid]+[@14Places]+[@21Talking]+[@28Remind]+[@30Event]
And the unicorns shall come down with them, and the bullocks with the bulls; and their land shall be soaked with blood, and their dust made fat with fatness. - God
Re: Excel
If I have a spreadsheet with several columns, how do I get a collapsed count for the header column in which I have it sorted? I've tried the Count and Subtotal functions but those seem to be for cells containing numbers. I just need to get a subtotal for each cell of text in the sorted column.
And the unicorns shall come down with them, and the bullocks with the bulls; and their land shall be soaked with blood, and their dust made fat with fatness. - God
Re: Excel
So I have a spreadsheet with a bunch of columns with client data, demographics, dates, etc. Each row accounts for an individual service provided and recorded in the database. I have it sorted by the Service Type column, and what I want is for the spreadsheet to count the number of each service type, so that at every change in that sorted column, it provides the subtotal for that service type. For example:
Administration - 146
Case Management - 1,365
Intake - 89
Treatment Plan - 412
Now I can just individually filter each service type and get the count that way, but I'm certain there's a function for this and I can't figure it out.
Administration - 146
Case Management - 1,365
Intake - 89
Treatment Plan - 412
Now I can just individually filter each service type and get the count that way, but I'm certain there's a function for this and I can't figure it out.
And the unicorns shall come down with them, and the bullocks with the bulls; and their land shall be soaked with blood, and their dust made fat with fatness. - God
Re: Excel
No there is no amount column. Those are just some of the values under the "Service Type" column. So if it look like this...
Service Type (Column Header)
Administration
Administration
Case Management
Case Management
Case Management
Case Management
Case Management
Intake
Intake
Intake
Treatment Plan
Treatment Plan
Treatment Plan
Treatment Plan
I want it to do this:
Service Type (Column Header)
Administration
Administration
Count: 2
Case Management
Case Management
Case Management
Case Management
Case Management
Count: 5
Intake
Intake
Intake
Count: 3
Treatment Plan
Treatment Plan
Treatment Plan
Treatment Plan
Count: 4
And the unicorns shall come down with them, and the bullocks with the bulls; and their land shall be soaked with blood, and their dust made fat with fatness. - God
- A_B
- The Dude
- Posts: 23519
- Joined: Mon Mar 11, 2013 7:36 am
- Location: Getting them boards like a wolf in the chicken pen.
Re: Excel
Sounds like you could have sorted and hand counted by this time. I don't mean that bad, and I love it when a spreadsheet works, but unless you're going to be doing this all the time and therefore need the formulas to work it's a boondoggle.
And doesn't subtotals let you use the count function and not just sum?
And doesn't subtotals let you use the count function and not just sum?
You know what you need? A lyrical sucker punch to the face.