Excel question

mister d · Post by **mister d** » Wed May 19, 2021 10:08 am

XLOOKUP???????

Giff · Post by **Giff** » Tue Jun 08, 2021 9:27 am

This is probably pretty basic, but can someone help me with a date formula. I basically have one go-live date where all other tasks are dependent on that date (i.e., task 1 is 90 days before go-live, task 2 is 80, etc.) How can I make the dates of these tasks automatically update when I update the go-live date?

Gunpowder · Post by **Gunpowder** » Tue Jun 08, 2021 9:43 am

Just add them. ie:

: excel.png (6.19 KiB) Viewed 611 times

Giff · Post by **Giff** » Tue Jun 08, 2021 9:45 am

Again proving the old adage, there are no stupid questions, just stupid people.

Thanks, GPJ.

Gunpowder · Post by **Gunpowder** » Tue Jun 08, 2021 9:46 am

Haa no such thing as a stupid question when it comes to Excel. I've become a wizard at it over the last year.

testuser2 · Post by **testuser2** » Tue Jun 08, 2021 12:11 pm

I've started using more templates to make things look better. I hate styling. They have some good basic project trackers.

elflaco2 · Post by **elflaco2** » Thu Jun 24, 2021 1:03 pm

we have an xls with 250+ lines.. each line corresponds to a player.. columns contain various scores and comments.. we need to convert these into 250 individual files to send out pre-season assessments to returning kids in the fall (yes, soccer)
i know there has to be a way to do this.. but my excel power fail me... help?

mister d · Post by **mister d** » Thu Jun 24, 2021 1:15 pm

Depends on the setup of the information versus the way the individual forms need to look. If its just "copy this line to send", I'd think you could set each row to print individually and PDF the 250 pages. If its taking that data into a new format, you could theoretically do 250 new tabs with references that you could change. Would be a lot of setup work but usable going forward.

elflaco2 · Post by **elflaco2** » Thu Jun 24, 2021 2:04 pm

tks....that would work.. i ended up doing a bit of research and figured out how to use mail merge onto the assessment template.. the next issue is how do i save each page separately? i can do it one a time.. tedious and laborious.. or by team and assign someone else to break it apart..we know we can save each assessment on to the player's file on the site.

A_B · Post by **A_B** » Thu Nov 11, 2021 11:57 am

I don't need any help, just wanted to let everyone know I made a fucking killer spreadsheet this morning.

GoodKarma · Post by **GoodKarma** » Thu Nov 11, 2021 12:19 pm

What was the subject/data?

A_B · Post by **A_B** » Thu Nov 11, 2021 12:26 pm

GoodKarma wrote: ↑Thu Nov 11, 2021 12:19 pm What was the subject/data?

It was a salary/benefit comparison for my board chairman for a side job I've been doing. Lots of data, but he only has to toggle five cells to get the full picture of 2021 vs. 2022 costs. We are trying to figure out how to keep the executive assistant on so had to include some sensitivities and whatnot since previously she didn't get benefits as she works for a firm that we pay for her services 3 days a week. So he can fiddle with those few inputs (two of which will be static but it's information I don't have because it's the guy taking over my interim position and I don't even want to know because I applied for the full-time position but did not get it). That means it's really just three cells that matter once he puts in whatever they agreed to for the new guy.

wlu_lax6 · Post by **wlu_lax6** » Thu Nov 11, 2021 1:23 pm

A_B wrote: ↑Thu Nov 11, 2021 12:26 pm
GoodKarma wrote: ↑Thu Nov 11, 2021 12:19 pm What was the subject/data?
It was a salary/benefit comparison for my board chairman for a side job I've been doing. Lots of data, but he only has to toggle five cells to get the full picture of 2021 vs. 2022 costs. We are trying to figure out how to keep the executive assistant on so had to include some sensitivities and whatnot since previously she didn't get benefits as she works for a firm that we pay for her services 3 days a week. So he can fiddle with those few inputs (two of which will be static but it's information I don't have because it's the guy taking over my interim position and I don't even want to know because I applied for the full-time position but did not get it). That means it's really just three cells that matter once he puts in whatever they agreed to for the new guy.

Hey let's let the guy we did not want for the job build the formulas for the impact of the job we did not give him. I mean what could go wrong?

Ryan · Post by **Ryan** » Wed Nov 24, 2021 12:31 pm

How do I add a "K" to chart data labels that reference a value in thousands of dollars?

Johnny Carwash · Post by **Johnny Carwash** » Fri Nov 26, 2021 10:07 am

Ryan wrote: ↑Wed Nov 24, 2021 12:31 pm How do I add a "K" to chart data labels that reference a value in thousands of dollars?

Did you figure this one out? I thought of a potential solution, but it's kind of a roundabout one.

Rex · Post by **Rex** » Fri Dec 10, 2021 7:57 pm

In for this.

Ryan · Post by **Ryan** » Fri Dec 10, 2021 10:00 pm

I get the feeling that saying “I could do this” here would be even stupider than saying it during the NBA Finals or something

Gunpowder · Post by **Gunpowder** » Fri Dec 10, 2021 10:02 pm

Ryan wrote: ↑Fri Dec 10, 2021 10:00 pm I get the feeling that saying “I could do this” here would be even stupider than saying it during the NBA Finals or something

Probably. Diarmuld Early 'bout to make history.

Gunpowder · Post by **Gunpowder** » Fri Dec 10, 2021 10:05 pm

Johnny Carwash wrote: ↑Fri Nov 26, 2021 10:07 am
Ryan wrote: ↑Wed Nov 24, 2021 12:31 pm How do I add a "K" to chart data labels that reference a value in thousands of dollars?
Did you figure this one out? I thought of a potential solution, but it's kind of a roundabout one.

I would do it with

=TEXT(A1/1000,"#,###.#")&"K"

(with A1 being a full number value)

You could change the section of the Text formula inside the parentheses to whatever convention you wanted to use.

Gunpowder · Post by **Gunpowder** » Fri Dec 10, 2021 10:08 pm

Also, if you want to actually use the K values in further calcs, I would prob just divide by 1000 into whatever convention you wanted and then edit my cells to a custom number and just write "K" at the end.

: excel.png (24.12 KiB) Viewed 410 times

Ryan · Post by **Ryan** » Sat Dec 11, 2021 8:14 am

Yeah I was trying to do it without touching the data. Looked like I could use custom formatting in the chart label options to append the K just like you showed but it didn’t work. Maybe I forgot quotes

Gunpowder · Post by **Gunpowder** » Mon Dec 13, 2021 3:28 pm

Ryan wrote: ↑Sat Dec 11, 2021 8:14 am Yeah I was trying to do it without touching the data. Looked like I could use custom formatting in the chart label options to append the K just like you showed but it didn’t work. Maybe I forgot quotes

Gotta have them quotes

Rush2112 · Post by **Rush2112** » Fri Jan 28, 2022 1:41 pm

I am a very basic Excel user, and I can't find a solution to this as I don't know what to look for, but I have a list of locations (that are repeated) and then the count of objects in that location I want to combine the locations into one list and add all the objects together.

Loc count
web 1
mus 3
web 2
bus 1
mus 2
etc....

I'd like

web 3
mus 5
bus 1

EnochRoot · Post by **EnochRoot** » Fri Jan 28, 2022 1:45 pm

Rush2112 wrote: ↑Fri Jan 28, 2022 1:41 pm I am a very basic Excel user, and I can't find a solution to this as I don't know what to look for, but I have a list of locations (that are repeated) and then the count of objects in that location I want to combine the locations into one list and add all the objects together.

Loc count
web 1
mus 3
web 2
bus 1
mus 2
etc....

I'd like

web 3
mus 5
bus 1

Sounds like subtotals is what you want. So you would sort by location, and then run a subtotal SUM on each Location.

A_B · Post by **A_B** » Fri Jan 28, 2022 1:45 pm

Rush2112 wrote: ↑Fri Jan 28, 2022 1:41 pm I am a very basic Excel user, and I can't find a solution to this as I don't know what to look for, but I have a list of locations (that are repeated) and then the count of objects in that location I want to combine the locations into one list and add all the objects together.

Loc count
web 1
mus 3
web 2
bus 1
mus 2
etc....

I'd like

web 3
mus 5
bus 1

Is the data above "i'd like" in one cell for each entry, or multiple cells? (To be clearer, is "web" in, say column A, and count in column b?)

Ryan · Post by **Ryan** » Fri Jan 28, 2022 1:46 pm

Insert - Pivot Table

: Untitled-1.png (62.66 KiB) Viewed 329 times

A_B · Post by **A_B** » Fri Jan 28, 2022 1:47 pm

Yes, let's have him do pivot tables.

Rush2112 · Post by **Rush2112** » Fri Jan 28, 2022 1:55 pm

Is the data above "i'd like" in one cell for each entry, or multiple cells? (To be clearer, is "web" in, say column A, and count in column b?)

Yes.

: image.png (5.85 KiB) Viewed 323 times

mister d · Post by **mister d** » Fri Jan 28, 2022 2:00 pm

Copy all the location codes from column A into column D to the right, select them all and click "Remove Duplicates" (its on the Data tab). Then, in column E, do =SUMIFS(B:B,A:A,D1).

mister d · Post by **mister d** » Fri Jan 28, 2022 2:03 pm

: image.png (17.01 KiB) Viewed 317 times

A_B · Post by **A_B** » Fri Jan 28, 2022 2:06 pm

I was going to suggest the FAPS method, but I guess the FASP method works, too.

Rush2112 · Post by **Rush2112** » Fri Jan 28, 2022 2:30 pm

Danke gents!

EdRomero · Post by **EdRomero** » Thu Apr 14, 2022 10:20 am

For Google Sheets is there a way to add and delete rows on multiple sheets? You can do it on Excel but I can't figure it out for Google. We have multiple sheets for the same students, and I want to be able to add and delete students without going to each sheet individually.

mister d · Post by **mister d** » Thu Apr 14, 2022 10:37 am

Google sheets is just 70% excel with no extra features so probably not?

A_B · Post by **A_B** » Thu Apr 14, 2022 10:56 am

The absolute worst part of hiring new, young people, is their FUCKING INSISTENCE that Google sheets is just as good as Excel and it's free.

Yeah, let me know when our finance department changes our files to Google. Until then, GTFOH.

mister d · Post by **mister d** » Thu Apr 14, 2022 11:03 am

Grab This Flaccid Ol’ Hog???

degenerasian · Post by **degenerasian** » Thu Apr 14, 2022 11:30 am

A_B wrote: ↑Thu Apr 14, 2022 10:56 am The absolute worst part of hiring new, young people, is their FUCKING INSISTENCE that Google sheets is just as good as Excel and it's free.

Yeah, let me know when our finance department changes our files to Google. Until then, GTFOH.

Not only that, but office documents can be tracked in a secured database (EDMS system). That way you can put security on it, like who can edit, who can read only, history and notes tracking etc...

Imagine the CEO's expense claim on Google Sheets! yes, GTFOH.

P.D.X. · Post by **P.D.X.** » Thu Apr 14, 2022 12:17 pm

You can literally do all of those things on Gsheets.

mister d · Post by **mister d** » Thu Apr 14, 2022 1:57 pm

Yeah, we do those. For basic data storage or matrix shit it’s fine but for actual financial usage it’s just bad excel.

The Sybian · Post by **The Sybian** » Thu Jul 07, 2022 2:49 pm

Not a question, but this popped into my youtube feed and I found it funny.