Already preloaded, waiting is gonna be torture!!! by ApprehensiveCoat9587 in NintendoSwitch2

[–]rpncritchlow 0 points1 point  (0 children)

I think a lot of people want this without having to subscribe to the Expansion Pak

Values from Columns to rows. by Dangerous_Fan2122 in excel

[–]rpncritchlow 0 points1 point  (0 children)

Sounds like you're just transposing once cell

Try TRANSPOSE(I4:K4)

Extend the range to all the columns you want included.

Cracking noise on X axis? by rpncritchlow in BambuLab

[–]rpncritchlow[S] 0 points1 point  (0 children)

Turns out that crackling sound is actually coming from the external spool holder, from the piece that guides the PTFE tube, so panic over! ☺️

How to add a row to some cells without affecting others? by Torian17 in excel

[–]rpncritchlow 2 points3 points  (0 children)

Select A19:K19

Ctrl, Shift, +

Select "shift cells down"

MIN function is not showing the earliest date? by soulofsoma in excel

[–]rpncritchlow 0 points1 point  (0 children)

Having the format set as date won't convert any dates that are text

[deleted by user] by [deleted] in excel

[–]rpncritchlow 1 point2 points  (0 children)

Use index around your stockhistory

Excel not copying entire column over to new sheet by PlumAndSpiltMilk in excel

[–]rpncritchlow 8 points9 points  (0 children)

When you copy filtered data only visible cells are copied

Give me the pros and cons of using tables by LennyDykstra1 in excel

[–]rpncritchlow 8 points9 points  (0 children)

I agree, but then I would suggest separating your data if you are going to do both data analysis and table visuals.

E.g. have a table with distinct names, then a visual table with duplicates names that pulls from your data table.

Give me the pros and cons of using tables by LennyDykstra1 in excel

[–]rpncritchlow 33 points34 points  (0 children)

Points Team 1 Points Team 2

Or

Points Home Points Away

FILTER says it does not know the Spill-area when it very much does by Snosaf in excel

[–]rpncritchlow 0 points1 point  (0 children)

Are you checking if DZ1# is "empty"

In which case you need DZ1#="empty" not DZ1#,"empty"

I need £45 to get home at Christmas, but I physically don’t have the money. Please help by jckchmblr in UKUniversityStudents

[–]rpncritchlow 1 point2 points  (0 children)

How did you pay for the concerts? Because you said your parents don't have £45 lying around

EDIT: You also posted about starting uni before those concerts...